tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacob Kjome <>
Subject Re: Tomcat 4.1.9 beta, Postgresql jndi / jdbc problem
Date Fri, 23 Aug 2002 18:51:49 GMT
Hello Peter,

I reported this bug earlier this week and it was fixed the same day.
Current CVS and Tomcat-4.1.10 will have the fix.

<user> is the old syntax.  It is supposed to be <username> for the
DBCP stuff.  The admin was still assuming that it was "user".

Here's the bug report:


Friday, August 23, 2002, 12:21:08 PM, you wrote:

PY> I would be interested in any comments on the following problem I 
PY> encountered setting up a jdbc datasource to Postgresql on Tomcat 4.1.9 beta.

PY> os - RedHat Linux 7.1 i386
PY> db - Postgresql 7.1.3
PY> driver - jdbc7.1-1.2.jar (jdbc driver for pg 7.1, java2)
PY> tc - Tomcat 4.1.9 beta.

PY> The problem arose after I used the new web admin interface to set up a 
PY> jdbc datasource to my Postgresql database (although the web admin 
PY> doesn't seem to be the problem). I received the error:

PY> "org.apache.jasper.JasperException: The user property is missing. It is 
PY> mandatory."

PY> However, the user property was not in fact missing.

PY> The web admin inserted the following resource parameters into my 
PY> server.xml (abridged):
PY> <parameter>
PY>    <name>user</name>
PY>    <value>postgres</value>
PY> </parameter>
PY> <parameter>
PY>    <name>url</name>
PY>    <value>jdbc:postgresql:testdb1</value>
PY> </parameter>
PY> <parameter>
PY>    <name>password</name>
PY>    <value>password_here</value>
PY> </parameter>

PY> The part above is identical to the corresponding parts in my 4.0.x 
PY> jndi/jdbc setup(s), which work fine.

PY> I discovered the following workarounds in server.xml:
PY> (1) attach the user parameter to the end of the jdbc url (e.g., 
PY> jdbc:postgresql:testdb1?user=postgres), or
PY> (2) change the parameter named "user" to "username", as in
PY> <parameter>
PY>    <name>username</name>
PY>    <value>postgres</value>
PY> </parameter>

PY> The Postgresql documentation clearly states that the property in 
PY> questions is "name".

PY> Any comments are appreciated.

PY> Thanks,
PY> Peter Yellman

PY> --
PY> To unsubscribe, e-mail:   <>
PY> For additional commands, e-mail: <>

Best regards,

To unsubscribe, e-mail:   <>
For additional commands, e-mail: <>

View raw message