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

Re: PGConnection (LargeObject) / JNDI Tomcat Issue

From: Mark Lewis <mark(dot)lewis(at)mir3(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 19:13:33
Message-ID: 1137611613.17090.33.camel@archimedes (view raw or flat)
Thread:
Lists: pgsql-jdbc
Marc,

Here's some sample code:

PGConnection pgCon =
(PGConnection)((DelegatingConnection)con).getInnermostDelegate();

-- Mark Lewis

On Wed, 2006-01-18 at 12:37 -0500, Dave Cramer wrote:
> 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
> >
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq

In response to

pgsql-jdbc by date

Next:From: Dave CramerDate: 2006-01-18 19:26:57
Subject: Re: 8.1 JDBC Driver Does Not Compile
Previous:From: Sergei DubovDate: 2006-01-18 18:58:15
Subject: 8.1 JDBC Driver Does Not Compile

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