Skip site navigation (1) Skip section navigation (2)

Re: JNDI Tomcat and PostgreSQL Error

From: Lucas <lucas75(at)gmail(dot)com>
To: jamesohara <johara(at)energyts(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JNDI Tomcat and PostgreSQL Error
Date: 2008-12-16 10:24:31
Message-ID: 494781DF.3010000@gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Basically

    The .jar from postgresql is not loaded.
    Put it inside the tomcat lib dir (not the WEB-INF/lib).

jamesohara escreveu:
> Hi,
>
> I am getting the following error: java.lang.RuntimeException: Cannot load
> JDBC driver class 'org.postgresql.Driver'
>
> when trying to connect to a postgreSQL database using JNDI with Tomcat. My
> configuration file and code is below.
>
> try {
> 			
> 			InitialContext context = new InitialContext();
> 			Context envContext  = (Context)context.lookup("java:/comp/env");
> 			DataSource dataSource = (DataSource)envContext.lookup("jdbc/eb");
> 			thisConnection = dataSource.getConnection();
> 			
> 			//Register it, as we now have a connection
> 			request.setAttribute(ServletUtils.STATEMENT_ATTRIBUTE_NAME, this);
> 			statement = thisConnection.createStatement();
> 		} catch (Exception e) 
>
> XML:
>
> <Context path="/eBench8" docBase="C:\Documents and
> Settings\johara.ETS.000\workspace\eB\eB" debug="1" reloadable="true">
>   <Resource name="jdbc/eb" auth="Container" type="javax.sql.DataSource"
> driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost/eb"
> username="user" password="pass" maxActive="40" maxIdle="10" maxWait="1000"
> accessToUnderlyingConnectionAllowed="true" /> 
>   </Context>
>
> Does anyone know why I could be getting this error. As far as I know
> everything is in its right place. ANy help would be appreciated.
>
> Thanks,
> James
>   


In response to

pgsql-jdbc by date

Next:From: Craig ServinDate: 2008-12-16 19:13:06
Subject: ResultSet performance question
Previous:From: jamesoharaDate: 2008-12-10 22:16:30
Subject: JNDI Tomcat and PostgreSQL Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group