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

Re: PGConnection (LargeObject) / JNDI Tomcat Issue

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Marc SCHNEIDER <marco_2025(at)web(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PGConnection (LargeObject) / JNDI Tomcat Issue
Date: 2006-01-18 17:37:23
Message-ID: 1E7BC982-3287-4E97-A29D-8DB51786F605@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Marc,

Check dbcp's documentation, there is a way to get the underlying  
connection.

You will have to first cast to some dbcp connection, then get the  
connection and cast it.

Dave
On 18-Jan-06, at 11:56 AM, Marc SCHNEIDER wrote:

> Hello,
>
> I have trouble to get Tomcat and JDBC work with LargeObject.
>
> I am using JNDI for database access
>
>  <Resource name="jdbc/aguila" auth="Container"  
> type="java.sql.DataSource"/>
>     <ResourceParams name="jdbc/aguila">
>         <parameter>
>             <name>factory</name>
>             <value>org.apache.commons.dbcp.BasicDataSourceFactory</ 
> value>
>         </parameter>
> 	<parameter>
> 	    <name>driverClassName</name>
> 	    <value>org.postgresql.Driver</value>
> 	</parameter>
> 	<parameter>
> 	    <name>url</name>
> 	    <value>jdbc:postgresql://localhost:5432/intradev</value>
> 	</parameter>
> 	<parameter>
> 	    <name>username</name>
> 	    <value>myuser</value>
> 	</parameter>
> 	<parameter>
> 	    <name>password</name>
> 	    <value>mypass</value>
> 	</parameter>
>     </ResourceParams>
>
> Here is my code :
>
>       LargeObjectManager lom = ((org.postgresql.PGConnection) 
> this.connection).getLargeObjectAPI();
>
> I get the following error :
>
> java.lang.ClassCastException
> This is because the connection is an instance of  
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper
> and I'm trying to get a org.postgresql.PGConnection connection.
>
> I saw on the web that people used  
> org.postgresql.jdbc3.Jdbc3ObjectFactory but this class is available  
> with jdbc 7.x drivers only.
>
> I tried to use the org.postgresql.ds.common.PGObjectFactory class  
> but when I connect to the database I get the following error :
> "no PostgreSQL user name specified in startup packet"
>
> Here is my config :
> DB : PostgreSQL 8.0
> Driver jdbc : postgresql-8.0-312.jdbc3.jar
> Java Server : Tomcat 5.0.28
> Os : Win XP
>
> Any idea ???
>
> Regards,
> Marc SCHNEIDER.
> ______________________________________________________________________ 
> ____
> Erweitern Sie FreeMail zu einem noch leistungsstärkeren E-Mail- 
> Postfach!		
> Mehr Infos unter http://freemail.web.de/home/landingpad/?mc=021131
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


In response to

Responses

pgsql-jdbc by date

Next:From: Sergei DubovDate: 2006-01-18 18:58:15
Subject: 8.1 JDBC Driver Does Not Compile
Previous:From: Marc SCHNEIDERDate: 2006-01-18 16:56:23
Subject: PGConnection (LargeObject) / JNDI Tomcat Issue

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