Probelm Connecting to Sybase Database frrom J2EE Web Applica

Vladk10000

Hiddukel1
missheadmistress
BalmungX
ChaosDragonMaster

Please vote for me once a day!

Special thanks to hiddukel1 for paying $5.00 to the community chest and making us one step closer to getting gold!

Programming Board V.3 > Java > Probelm Connecting to Sybase Database frrom J2EE Web Applica
	Next Topic >>

Author	Comment
hemanthjava Registered Member Posts: 1 (1/16/06 5:04 am) Reply	Probelm Connecting to Sybase Database frrom J2EE Web Applica Hi, I get the following error when I connect to the Sybase database from my web-app. I put Set chained off in the procedure and nothing happenend. There seems to be a probelm in the Java Side. Exception : ------------ com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'p_inter_status_dz' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. Note: My Stored Procedure call is surrounded with a try/catch/finally, always closing the connection in the finally. Regards, Hemanth www.javaprogrammingworld.com

Email This To a Friend
Topic Control Image

- Programming Board V.3 - Java -