wwilbur
Occasional Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: ERROR: org.postgresql.util.PSQLException: FATAL: too many connections
I went ahead and used another Postgresql database that does not contain PCI information. It worked Sincerely, Bill Wilbur Quality Assurance Analyst Information Technology O'Reilly Auto Parts (417) 862-2674 ext. 1603 The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.3.3KViews1like1CommentERROR: org.postgresql.util.PSQLException: FATAL: too many connections
I have closed all connections to the Postgresql database, closed all apps connecting to it, rebooted my computer and still get the above message. This has happened many times for the Postgresql databases. Is there a way to fix. I do not have admin to increase connections so need to find a way to make sure all connections are closed before starting scriptSolved3.3KViews0likes5Commentsjava.sql.DataTruncation: Data truncation error
I am able to update and insert into a DB2 schema and table using DBeaver but when I try to do these in ReadyAPI I get the error message java.sql.DataTruncation: Data truncation error Here is the groovy script code for insert: import groovy.sql.Sql import com.eviware.soapui.support.GroovyUtilsPro; def groovyUtilsPro = new GroovyUtilsPro(context) //def sql = groovyUtilsPro.getGroovySql('sysdev2') def storeNumber = context.expand( '${getDataFromDWDataDWSMast#storeNumber}' ) def lineCode = context.expand( '${getDataFromDWDataDWSMast#lineCode}' ) def itemNumber = context.expand( '${getDataFromDWDataDWSMast#itemNumber}' ) def dSAC = context.expand( '${#TestCase#dSAC}' ) def qOH = context.expand( '${getDataFromDWDataDWSMast#QOH}' ) def qOO = context.expand( '${getDataFromDWDataDWSMast#QOO}' ) def dSQBO = context.expand( '${getDataFromDWDataDWSMast#DSQBO}' ) def mAX = context.expand( '${getDataFromDWDataDWSMast#MAX}' ) def mIN = context.expand( '${getDataFromDWDataDWSMast#MIN}' ) def sPSUPL = context.expand( '${getDataFromDWDataDWSMast#SPSUPL}' ) def dSSWSQ = context.expand( '${getDataFromDWDataDWSMast#DSSWSQ}' ) def dSDOLT = context.expand( '${getDataFromDWDataDWSMast#DSDOLT}' ) def dSLOAD = context.expand( '${getDataFromDWDataDWSMast#DSLOAD}' ) def dSALCD = context.expand( '${#TestCase#dSALCD}' ) def dSUSER = context.expand( '${getDataFromDWDataDWSMast#DSUSER}' ) def dSDEAL = context.expand( '${getDataFromDWDataDWSMast#DSDEAL}' ) def dSCORE = context.expand( '${getDataFromDWDataDWSMast#DSCORE}' ) def line = ("'" + lineCode + "'") def item = ("'" + itemNumber + "'") Map dbConnParams = [ url: 'jdbc:as400://sysdev2.oreillyauto.com;libraries=OPPDATA', user: 'xxxxxxx', password: 'xxxxxx', driver: 'com.ibm.as400.access.AS400JDBCDriver'] def sql = Sql.newInstance(dbConnParams) def result = sql.executeInsert ("INSERT INTO DWDATA.DWSMAST (STR#, LINE, ITEM#, DSAC, QOH, QOO, DSQBO, MAX, MIN, SPSUPL, DSSWSQ, DSDOLT, DSLOAD, DSALCD, DSUSER, DSDEAL, DSCORE) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", [storeNumber, line, item, dSAC, qOH, qOO, dSQBO, mAX, mIN, sPSUPL, dSSWSQ, dSDOLT, dSLOAD, dSALCD, dSUSER, dSDEAL, dSCORE]) sql.close() and here is for update: import groovy.sql.Sql import com.eviware.soapui.support.GroovyUtilsPro; def groovyUtilsPro = new GroovyUtilsPro(context) def sql = groovyUtilsPro.getGroovySql('sysdev2') String storeNumber = context.expand( '${getRandomStoreNumberCustomerName#storeNumber}' ) String lineCode = context.expand( '${getPart#lineCode}' ) String itemNumber = context.expand( '${getPart#itemNumber}' ) def line = ("'" + lineCode + "'") def item = ("'" + itemNumber + "'") Map dbConnParams = [ url: 'jdbc:as400://sysdev2.oreillyauto.com;libraries=OPPDATA', user: 'xxx', password: 'xxxx', driver: 'com.ibm.as400.access.AS400JDBCDriver'] def con = Sql.newInstance(dbConnParams) def result = sql.execute("UPDATE OPPDATA.DWSMAST SET QOH = 10, MAX = 50 WHERE STR# = ${storeNumber} AND LINE = ${line} AND ITEM# = ${item}") sql.close()Solved3.5KViews0likes4Comments