Re: JDBC DataSources with SYBASE Adaptive Server Anywhere

2006-03-07 Thread Tom Bednarz
Hello Petr, Well you did give me some hints that helped me a lot! I solved the problem late last night. It was one of the very nasty bitches It was as I assumed at the very beginning: If I debug my environment inside Eclipse it is not the same as running a deployed version in a Tomcat d

Re: JDBC DataSources with SYBASE Adaptive Server Anywhere

2006-03-06 Thread Hadraba Petr
Hello Thomas, thank you for your informations! I will order ASA developer edition and learn new database;-) Now, I'm looking for a database which provides internationalization features; specially ORDER BY [(var)char | text] column and I have no success: ASE and localization -- it's a workaround. P

Re: JDBC DataSources with SYBASE Adaptive Server Anywhere

2006-03-06 Thread Tom Bednarz
Hi Petr, Thanks for your feedback. It still does not work for me, no matter where I put the damn JAR file. So I will use my own pooling class directly in my webapp based on Apaches DBCP which is part of Jakarta Commons. It is probably faster then fiddeling with this bloody driver configuaratio

Re: JDBC DataSources with SYBASE Adaptive Server Anywhere

2006-03-05 Thread Hadraba Petr
Hi, I studied something about Sybase ASA and here are my pieces of knowledge: - ASA is, unlike ASE, ODBC based insted of TDS - the JDBC drivers are generic JDBC-to-ODBC bridge and can be used to access _any_ database throw ODBC - the JDBC drivers are not freely downloadable (I didn't find any) -

Re: JDBC DataSources with SYBASE Adaptive Server Anywhere

2006-03-03 Thread Tom Bednarz
Hi, Thanks for your help. It brought me one step further but did not yet solve the problem! It looks like the context.xml is mandatory. I moved the configuration from the server.xml to the context.xml. The error message changed as follows: org.apache.jasper.JasperException: Unable to get con

Re: JDBC DataSources with SYBASE Adaptive Server Anywhere

2006-03-03 Thread Hadraba Petr
Hi, I'm not using Sybase under Tomcat; I have PostgreSQL... Eclipse? My configuration is, Eclipse does not modify Tomcat configuration (this is the default) In your WebContent under META-INF create context.xml with the definition. The element does not require any attributes: And finaly,

JDBC DataSources with SYBASE Adaptive Server Anywhere

2006-03-03 Thread Tom Bednarz
I try to configure a JDBC DataSource for my Adaptive Server Anywhere 9 database. Unfortunately without any success so far! I use Tomcat 5.5.18. The error is well known and looks as follows: org.apache.jasper.JasperException: Unable to get connection, DataSource invalid: "org.apache.tomcat.dbcp