I also have a problem on this one having the error below:
[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service test.util.jdbc:insertService.\n[ADA.1.316] Cannot execute the SQL statement “INSERT INTO [dbo].[Table1] ([Field1],[Field2],[Field3],[Field4],[Field5],[Field6],[Field7]) VALUES(?,?,?,?,?,?,?)”. “\n(0) The connection is closed.”\nThe connection is closed.
The strange thing is, it only happens when inserting a record for the first time. Once the error occurred, when you try inserting again, the insert succeed.
After awhile when the Integration Server is on idle for 10mins or so, the Error throws again saying " The connection is closed".
I’m currently accessing to AZURE Database with these jdbc adapter connection settings
Connection Type:webMethods Adapter for JDBC Connection
Connection Management Properties
Enable Connection Pooling:TRUE
Minimum Pool Size:1
Maximum Pool Size:10
Pool Increment Size:1
Block Timeout (msec):1000
Expire Timeout (msec):1000
Startup Retry Count:0
Startup Backoff Timeout (sec):10
What am I missing here
Hoping for your replies