datasource « sybase « Java Database Q&A

1. "Stored procedure 'xxx' may be run only in unchained transaction mode." error when calling a procedure from a DataSource, in an EJB context

We have a Database in Sybase, which we access from a Java server. Access to the DB was made directly through the Sybase driver, using DriverManager. It was working correctly, we were ...

2. Sybase -- Insufficient information to connect to the data source

I'm having a problem with conn = DriverManager.getConnection( url, props ) ; I have tried (url) ... (url,, ... (url, props) AND I still receive an insufficient information error. Any suggestions? (This is for testing purposes) Thank you very very much. Error Message... creating DB Driver creating connection Exception: [MERANT][ODBC Sybase ASE driver]Insufficient information to connect to the data source. java.sql.SQLException: ...

3. Sybase datasource without metadata

I am having a problem using a tomcat 5.5.17 datasource with Sybase 9.0.2 and jconn2.jar (have also tried jconn3) I can connect using: Class.forName("com.sybase.jdbc2.jdbc.SybDriver"); String url = jdbc:sybase:Tds:HOST:2638/DATABASE"; Statement stmt = conn.createStatement(); However when I try the same thing through the datasource