UDC J2EE SQLServer 2000 Driver for JDBC

[Former Member]

Hi everyone,

I have an UDC created according to How to …Configure UD Connect on the J2EE Server for JDBC Access to External Databases. In small number of records it seems working perfectly fine. But when record count is large like above 20000 records this message shows up and it finishes with error like:

Caller 09 contains an error message.

S:RSSDK:300 [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed

Note

If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.

Anyone having same problem any help would be appreciated...

[Former Member · Accepted solution]

am not sure it these helps

Note 1009063 - UDConnect displays erratic behaviour in loading data

Hope it Helps

Chetan

@CP..

[Former Member]

OSS helped me to solve the problem. Connection lifetime parameter solved the problem.

[Former Member]

We have found out that in J2EE Administrator configuration there is a parameter connection time. By default it is 20secs. We increased that time and results were satisfactory.

Thanks anyway..

[Former Member]

Hi, Ergin really apreciate you help, you can FIX you problem ?

I not can extract big volume the data, only when using filters in Selection the Package is ok.

Get errors :

<b>S:RSSDK:300 Closed Statement: getMetaData

S:RSSDK:300 Io exception: Socket closed

S:RSSDK:300 Exhausted Resultset

S:RSSDK:300 statement handle not executed</b>

Any idea for detect the problem, Logs in J2EE Admin not show specify the problem.

The principal problem is : <b>S:RSSDK:300 Closed Statement: getMetaData</b>

Maybe some parameter in RZ10, JCo RFC, J2ee Visual Admin, RFC in ABAP, etc ?

I Apply the Note 1009063, but not fix my problem.

Where you setting that parameters ?

Thank you.