JDBC Channel : Connection reset

[Former Member]

Hi,

I have created a JDBC channel and activated it. when i went into Adapter moniter, i found that the channel was working fine. I have used this channel in my scenarios also (File to DB). Later( after 2 days), i had made some dummy changes and activated it. but this time it showed up a "RED" light.

The following is the error:

Processing Error: Accessing database connection 'jdbc:microsoft:sqlserver://<servername>:1433;DatabaseName=<dbname>' failed:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset Addtional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

Available JDBC drivers: oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant com.microsoft.jdbc.sqlserver.SQLServerDriver, 2.2 JDBC compliant

What can is the problem...

Regards,

christina.

[Former Member · Accepted solution]

Hi Christina,

As u said, u were trying stored procedures, u can have a look at my latest weblog "JDBC stored Procedures".

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Hope it will solve some of your future problems too.

)

Cheers,

Siva Maranani

[Former Member · Accepted solution]

Hi Siva

I am not able to view your blog on Stored Procedures. Could you please let me know the correct URL?

[Former Member · Accepted solution]

URL is

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1671] [original link is broken] [original link is broken] [original link is broken];

[Former Member]

Hi Siva,

Thanks for your proactive reply.

Your blog has really helped me out. I could resolve some errors by directly refering to your blog.

Now, i could succesfully execute the stode procedure.

Thankx a lot )

thanks,

Christina

[Former Member]

Hi,

Ur error is similar to the following. Refer to the following thread.

U need to add the parameter SelectMethod=cursor in your connection parameter,

jdbc:microsoft:sqlserver://<hostname>:1433;DatabaseName=<dbname>;SelectMethod=cursor

Cheers,

Siva Maranani.

[Former Member]

Hi,

Yes it works!!.. I have given you the points.... )

I was actually trying out a JDBC Stored procedure scenario. I got the following error when executed the scenario....

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: ERROR:Processing request: Error when executing statement for table/stored proc. 'sp_XYZ': java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.</SAP:AdditionalText>

what is the solution for the problem...

Regards,

christina.