PGConnection (LargeObject) / JNDI Tomcat Issue

Поиск
Список
Период
Сортировка
От Marc SCHNEIDER
Тема PGConnection (LargeObject) / JNDI Tomcat Issue
Дата
Msg-id 768569414@web.de
обсуждение исходный текст
Ответы Re: PGConnection (LargeObject) / JNDI Tomcat Issue  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
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
driversonly. 

I tried to use the org.postgresql.ds.common.PGObjectFactory class but when I connect to the database I get the
followingerror : 
"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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PPOSTGRES][PSQL] Segmentation fault
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: PGConnection (LargeObject) / JNDI Tomcat Issue