Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-03 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 16:27, Les Hughes wrote: Ok. Summary time. Martin reflects my experience - I dumped tyrex and used DBCP as well. But aren't we trying to go direct without a pool? Having said that I've only ever managed to get datasources working when DBCP is being used... Check

Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
Hi I've just started to write servlets. Servlets that only do processing, without connecting to database work fine, but I have some problems to get the connection with postgresql via jdbc work. Tomcat: 4.0.4 (on linux) Postgresql: 7.2.1 (on linux) Jdbc: pgjdbc2.jar (from

Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 14:00, Les Hughes wrote: Two things, In your server.xml user I think should be username and driverName has been deprecated in favour of url which needs the servername and DB name as well (as in something like jdbc:postgresql://full.server.name/mybookdb - or

Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 14:53, Przemyslaw Kowalczyk wrote: I came to another conclusion. Even if there was some reference to hsql driver in my server.xml it shouldn't affect my own servlet, as it uses its own context. Am I right? przem -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED

Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 14:56, [EMAIL PROTECTED] wrote: Would you have other applications running in tomcat? No, I've just started to learn, so there are other apps. przem -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]

Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 15:00, [EMAIL PROTECTED] wrote: Is this normal : resource-ref res-ref-namejdbc/BookDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainter/res-auth /resource-ref More especially :

Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 15:06, Les Hughes wrote: web-app resource-ref descriptionDB Connection/description res-ref-namejdbc/TestDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref /web-app The description is missing

Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 15:16, Les Hughes wrote: Ignore the remove // comment - I was looking at my oracle notes :-) I really have no idea why it's trying to load the hsql driver if there's no ref in your server.xml Ok, the full versions (I cut off all comments): przem server.xml

Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

2002-07-02 Thread Przemyslaw Kowalczyk
On Tuesday 02 July 2002 15:43, [EMAIL PROTECTED] wrote: Do you have already connected to a postgresql db using a java app? Are you sure the parameters are correct? What is public? Where did you put the postgresql.jar? Yes, without any problems from 'standalone' application. I'm able to query