cancel
Showing results for 
Search instead for 
Did you mean: 

Setting JDBC driver properties for DB

Former Member
0 Kudos

Hi Experts,

we have proxy to JDBC synchronous scenario, currently the messages are sitting in delivering status for long time.

SAP Note 1078420 - based on this note i need to configure the following parameters

driver:oracle.jdbc.ReadTimeout 1000

driver:oracle.net.CONNECT_TIMEOUT 1000

sqlquerytimeout

these parameters for Oracle, i am connecting to MSSQL2005 so can anyone please tell me what are the parameters for MSSQL2005 ????

Kind Regards,

kwangmo ku

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

We havent seen mentioned parameter working & their behaviour is strange.

One parameter which is supported by JDBC adapter for all DB is taskTimeout. Its value is in milliseconds & it works for both sender & receiver JDBC adapter.

Regards

Sushil

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Flok,

Check the queues using transactions SMQ1 (outbound)/SMQ2 (inbound). Resolve the displayed errors. You can cancel the messages from SXMB_MONI. Execute LUW if necessary and avoid deleting entries manually.

Regards,

Ravi.

Former Member
0 Kudos

Hi,

Can u pls check in Queues(SMQ2).If u find any thing in queues u have to activate/delete it.

Thanks

Ravi