Solution : https://service.sap.com/sap/support/notes/1078420 (SAP Service marketplace login required)
Summary :
This SAP Note outlines methods to set JDBC driver properties to solve delays or hang-ups in DB connection establishment via the JDBC adapter. Customizable driver properties, prefixed by 'driver:', can be set directly in the advanced mode table of sender and receiver channel configurations. Examples including settings for Oracle's JDBC thin driver demonstrate setting timeouts for socket reading and login. The importance of driver-specific documentation is emphasized as properties may differ by driver version. Directives for non-prefixed SQL query timeout settings are also provided. Support packages for various frameworks are detailed to assist with application.
Key words :
oracle database jdbc thin driver 10, db documentation/ jdbc driver documentation, advanced mode table section, 0 sp20 adapter framework core 3, 0 sp19 adapter framework core 3, 0 sp13 adapter framework core 7, 0 sp12 adapter framework core 7, 0 sp11 adapter framework core 7, 0 sp10 adapter framework core 7, oracle jdbc thin driver 10
Related Notes :
| 1398891 | XI/PI Adapter for Oracle: Overcoming DB Connection Issues |
| 1385571 | PI JDBC adapter: Connecting a DB2 for IBM i |