You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Alexander Wallace <to...@rwsoft-online.com> on 2002/08/12 17:33:09 UTC
JNDI JDBC COnnection pooling problem...
Hello. This has to be a very simple one for those who know.
I'm getting a java.lang.NullPointerException in my app, in the second
line here:
Context ctx = (Context) new InitialContext().lookup("java:comp/env");
conn = ((DataSource) ctx.lookup("jdbc/pgsql")).getConnection(); **Error
happens here**
And have the following in my server.xml (I put my whole context in case
my error is there)
<Context path="/lto" docBase="lto" debug="0"
reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_lto_log." suffix=".txt"
timestamp="true"/>
<Environment name="maxExemptions" type="java.lang.Integer"
value="15"/>
<Parameter name="context.param.name"
value="context.param.value" override="false"/>
<Resource name="jdbc/pgsql" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/pgsql">
<parameter><name>user</name><value>awallace</value></parameter>
<parameter><name>password</name><value>passwd</value></parameter>
<parameter><name>driverClassName</name>
<value>org.postgresql.Driver</value></parameter>
<parameter><name>driverName</name>
<value>jdbc:postgresql://10.100.101.1/awallace</value></parameter>
</ResourceParams>
<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"/>
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
<Realm className="org.apache.catalina.realm.JDBCRealm"
debug="99"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://10.100.101.1/awallace?user=awallace;password=passwd"
userTable="tbl_users" userNameCol="user_name"
userCredCol="password"
userRoleTable="user_roles"
roleNameCol="role_name"
digest="MD5"/>
</Context>
Thank you in advance.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: JNDI JDBC COnnection pooling problem...
Posted by Alexander Wallace <to...@rwsoft-online.com>.
I changed to username, it didn't work either.
Thanks.
On Tue, 2002-08-13 at 04:05, Andrew wrote:
> Try changing the name of your parameter from 'user' to 'username'
>
>
> That worked for me with another driver (MSSQL Server JDBC Driver)
>
>
> - Andrew
>
> > -----Original Message-----
> > From: Alexander Wallace [mailto:tomcater@rwsoft-online.com]
> > Sent: Monday, August 12, 2002 11:33 AM
> > To: tomcat-user@jakarta.apache.org
> > Subject: JNDI JDBC COnnection pooling problem...
> >
> >
> > Hello. This has to be a very simple one for those who know.
> >
> > I'm getting a java.lang.NullPointerException in my app, in
> > the second line here:
> >
> > Context ctx = (Context) new InitialContext().lookup("java:comp/env");
> > conn = ((DataSource)
> > ctx.lookup("jdbc/pgsql")).getConnection(); **Error happens here**
> >
> > And have the following in my server.xml (I put my whole
> > context in case my error is there)
> >
> > <Context path="/lto" docBase="lto" debug="0"
> > reloadable="true" crossContext="true">
> > <Logger className="org.apache.catalina.logger.FileLogger"
> > prefix="localhost_lto_log." suffix=".txt"
> > timestamp="true"/>
> > <Environment name="maxExemptions" type="java.lang.Integer"
> > value="15"/>
> > <Parameter name="context.param.name"
> > value="context.param.value" override="false"/>
> >
> > <Resource name="jdbc/pgsql" auth="Container"
> > type="javax.sql.DataSource"/>
> > <ResourceParams name="jdbc/pgsql">
> >
> > <parameter><name>user</name><value>awallace</value></parameter>
> >
> > <parameter><name>password</name><value>passwd</value></parameter>
> > <parameter><name>driverClassName</name>
> > <value>org.postgresql.Driver</value></parameter>
> > <parameter><name>driverName</name>
> >
> > <value>jdbc:postgresql://10.100.101.1/awallace</value></parameter>
> > </ResourceParams>
> > <Resource name="mail/Session" auth="Container"
> > type="javax.mail.Session"/>
> > <ResourceParams name="mail/Session">
> > <parameter>
> > <name>mail.smtp.host</name>
> > <value>localhost</value>
> > </parameter>
> > </ResourceParams>
> >
> > <Realm className="org.apache.catalina.realm.JDBCRealm"
> > debug="99"
> > driverName="org.postgresql.Driver"
> >
> > connectionURL="jdbc:postgresql://10.100.101.1/awallace?user=aw
> > allace;password=passwd"
> > userTable="tbl_users"
> > userNameCol="user_name" userCredCol="password"
> > userRoleTable="user_roles"
> > roleNameCol="role_name"
> > digest="MD5"/>
> > </Context>
> >
> >
> >
> > Thank you in advance.
> >
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <mailto:tomcat-user-> unsubscribe@jakarta.apache.org>
> > For
> > additional commands,
> > e-mail: <ma...@jakarta.apache.org>
> >
> >
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: JNDI JDBC COnnection pooling problem...
Posted by Andrew <an...@attbi.com>.
Try changing the name of your parameter from 'user' to 'username'
That worked for me with another driver (MSSQL Server JDBC Driver)
- Andrew
> -----Original Message-----
> From: Alexander Wallace [mailto:tomcater@rwsoft-online.com]
> Sent: Monday, August 12, 2002 11:33 AM
> To: tomcat-user@jakarta.apache.org
> Subject: JNDI JDBC COnnection pooling problem...
>
>
> Hello. This has to be a very simple one for those who know.
>
> I'm getting a java.lang.NullPointerException in my app, in
> the second line here:
>
> Context ctx = (Context) new InitialContext().lookup("java:comp/env");
> conn = ((DataSource)
> ctx.lookup("jdbc/pgsql")).getConnection(); **Error happens here**
>
> And have the following in my server.xml (I put my whole
> context in case my error is there)
>
> <Context path="/lto" docBase="lto" debug="0"
> reloadable="true" crossContext="true">
> <Logger className="org.apache.catalina.logger.FileLogger"
> prefix="localhost_lto_log." suffix=".txt"
> timestamp="true"/>
> <Environment name="maxExemptions" type="java.lang.Integer"
> value="15"/>
> <Parameter name="context.param.name"
> value="context.param.value" override="false"/>
>
> <Resource name="jdbc/pgsql" auth="Container"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/pgsql">
>
> <parameter><name>user</name><value>awallace</value></parameter>
>
> <parameter><name>password</name><value>passwd</value></parameter>
> <parameter><name>driverClassName</name>
> <value>org.postgresql.Driver</value></parameter>
> <parameter><name>driverName</name>
>
> <value>jdbc:postgresql://10.100.101.1/awallace</value></parameter>
> </ResourceParams>
> <Resource name="mail/Session" auth="Container"
> type="javax.mail.Session"/>
> <ResourceParams name="mail/Session">
> <parameter>
> <name>mail.smtp.host</name>
> <value>localhost</value>
> </parameter>
> </ResourceParams>
>
> <Realm className="org.apache.catalina.realm.JDBCRealm"
> debug="99"
> driverName="org.postgresql.Driver"
>
> connectionURL="jdbc:postgresql://10.100.101.1/awallace?user=aw
> allace;password=passwd"
> userTable="tbl_users"
> userNameCol="user_name" userCredCol="password"
> userRoleTable="user_roles"
> roleNameCol="role_name"
> digest="MD5"/>
> </Context>
>
>
>
> Thank you in advance.
>
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:tomcat-user-> unsubscribe@jakarta.apache.org>
> For
> additional commands,
> e-mail: <ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>