Thread: error - driver -- postgresql 7.4.2 --Suse 9.0

error - driver -- postgresql 7.4.2 --Suse 9.0

From
tgutierrez@unipamplona.edu.co
Date:
greetings

I have the following error when connecting from tomcat, appears to me:

Err no se puedo cargar el driver en DefinitionConnectionPortal -->
DefinitionConnectionPortal Cannot create PoolableConnectionFactory
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory, cause:
Connection refused. Check that the hostname and port is correct, and that
the postmaster is running with the -i flag, which enables TCP/IP
networking.
        at org.postgresql.Connection.openConnection(Connection.java:136)
        at org.postgresql.Driver.connect(Driver.java:122)
        at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
        at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
        at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
        at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)


driver that we used is: jdbc7.1-1.2.jar

thanks

Tania Gutierrez



Re: error - driver -- postgresql 7.4.2 --Suse 9.0

From
Kris Jurka
Date:

On Mon, 4 Oct 2004 tgutierrez@unipamplona.edu.co wrote:

> greetings
>
> I have the following error when connecting from tomcat, appears to me:

The error message is pretty clear:

> Connection refused. Check that the hostname and port is correct, and that
> the postmaster is running with the -i flag, which enables TCP/IP
> networking.

This message is perhaps outdated as the more recommended method of
enabling tcp/ip connections is by enabling tcpip_socket in
postgresql.conf.

> driver that we used is: jdbc7.1-1.2.jar

This is unrelated to your immediate problem, but if you are using a 7.4
server you should also be using a 7.4 jdbc driver.

Kris Jurka

Re: error - driver -- postgresql 7.4.2 --Suse 9.0

From
Dave Cramer
Date:
Why are you using a 7.1 driver with a 7.4 database ?

that withstanding do you have tcpip=true in the postgresql.conf or the
-i flag in the startup script ?

Dave
On Mon, 2004-10-04 at 18:48, tgutierrez@unipamplona.edu.co wrote:
> greetings
>
> I have the following error when connecting from tomcat, appears to me:
>
> Err no se puedo cargar el driver en DefinitionConnectionPortal -->
> DefinitionConnectionPortal Cannot create PoolableConnectionFactory
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory, cause:
> Connection refused. Check that the hostname and port is correct, and that
> the postmaster is running with the -i flag, which enables TCP/IP
> networking.
>         at org.postgresql.Connection.openConnection(Connection.java:136)
>         at org.postgresql.Driver.connect(Driver.java:122)
>         at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
>         at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
>         at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
>         at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
>         at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
>
>
> driver that we used is: jdbc7.1-1.2.jar
>
> thanks
>
> Tania Gutierrez
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com