Alfonso,
Any help is appreciated.
Here they are:
server.xml
----------
<Resource auth="Container" name="jdbc/postgres" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/postgres">
<parameter>
<name>url</name>
<value>jdbc:postgresql://roach/testdb</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value></value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.postgresql.Driver</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>username</name>
<value>******</value>
</parameter>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>password</name>
<value>*****</value>
</parameter>
</ResourceParams>
web.xml
---------
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd";>
<web-app>
<description>PostGresql Db Test</description>
<resource-ref>
<description>DB Conn</description>
<res-ref-name>jdbc/postgres</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Sharable</res-sharing-scope> <!--tried adding this, no effect -->
</resource-ref>
</web-app>
I also tried changing my context call from:
java:/comp/env
to
java:comp/env
with no effect.
thanks,
Paul
Alfonso Martinez wrote:
> Hi Paul,
>
> I am a newbie too, but trying to help. I had a problem like yours recently and found
>an error in my server.xml. I know you checked that file already, but can you send
>those (also web.xml) files to me please to see what I can do? Thanks
>
> Jose
>
> On Fri, Sep 20, 2002 at 11:10:41AM -0500, Paul Salazar wrote:
> > Hi,
> >
> > I am trying to setup a postgresql datasource on tomcat 4.1 with much
> > frustration.
> > I have read all the threads out there concerning this matter and I can't
> > see to
> > find anyone who has a working example. What I have is this:
> >
> > Redhat 7.2 server running:
> > Postgresql 7.2
> > Tomcat 4.1
> >
> > I have a working Tomcat app that can connect to the Db and perform
> > queries when manually loading the driver
> > 'Class.forName("org.postgresql.Driver");
> > and then doing a getConnection using the URL, Name, Password.
> >
> > But when trying to get a connection using a Datasource, as in,
> >
> > Context ctx = new InitialContext();
> > Context envctx = (Context)ctx.lookup("java:/comp/env");
> > DataSource ds = (DataSource)envctx.lookup("jdbc/postgres"); //jndi name
> > of the datasource
> > Connection conn = ds.getConnection();
> >
> > the getConnection() statement throws an SQLException: Cannot load JDBC
> > driver class 'null'
> >
> > I have gone over all the server.xml and web.xml files with a fine tooth
> > comb and assure
> > you that is not the problem. I have also tried using the jxDBCon drivers
> > with the same
> > results. I have come to the conclusion that it must be a tomcat problem.
> > Has anyone
> > gotten this to work with this config??
> >
> > Paul Salazar
> >
>
> > --
> > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
