Re: Connection pool problem - Mailing list pgsql-jdbc

Here is another Stack trace, i got when
doing DriverManager.setLogWriter() :

DriverManager.getConnection("jdbc:postgresql://200.200.200.34:5432/geosiaradev")
    trying
driver[className=org.postgresql.Driver,org.postgresql.Driver@11ddcde]
org.postgresql.util.PSQLException
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:208)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
        at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
        at
fr.cerene.geosiara.gprs.receiver.ConnectionPool.getConnection(ConnectionPool.java:101)
        at
fr.cerene.geosiara.gprs.receiver.SQLoader.saveTrame2(SQLoader.java:210)
        at
fr.cerene.geosiara.gprs.receiver.SQLoader$1.run(SQLoader.java:317)
        at java.lang.Thread.run(Thread.java:534)
getConnection failed: org.postgresql.util.PSQLException: The connection
attempt failed because Exception: java.net.BindException: Address
already in use: connect
Stack Trace:

java.net.BindException: Address already in use: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
        at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
        at java.net.Socket.connect(Socket.java:452)
        at java.net.Socket.connect(Socket.java:402)
        at java.net.Socket.<init>(Socket.java:309)
        at java.net.Socket.<init>(Socket.java:124)
        at org.postgresql.core.PGStream.<init>(PGStream.java:47)
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:197)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
        at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
        at
fr.cerene.geosiara.gprs.receiver.ConnectionPool.getConnection(ConnectionPool.java:101)
        at
fr.cerene.geosiara.gprs.receiver.SQLoader.saveTrame2(SQLoader.java:210)
        at
fr.cerene.geosiara.gprs.receiver.SQLoader$1.run(SQLoader.java:317)
        at java.lang.Thread.run(Thread.java:534)
End of Stack Trace

java.lang.NullPointerException
        at
fr.cerene.geosiara.gprs.receiver.SQLoader.saveTrame2(SQLoader.java:227)
        at
fr.cerene.geosiara.gprs.receiver.SQLoader$1.run(SQLoader.java:317)
        at java.lang.Thread.run(Thread.java:534)


Stéphane RIFF wrote:

> Here is the NullPointerExceptionStack trace
> java.lang.NullPointerException
>        at
> fr.cerene.geosiara.gprs.receiver.SQLoader.saveTrame(SQLoader.java:139)
>        at
> fr.cerene.geosiara.gprs.receiver.SQLoader$1.run(SQLoader.java:229)
>        at java.lang.Thread.run(Thread.java:534)
>
> fr.cerene.geosiara.gprs.receiver.SQLoader.saveTrame(SQLoader.java:139)
>        fr.cerene.geosiara.gprs.receiver.SQLoader$1.run(SQLoader.java:229)
>        java.lang.Thread.run(Thread.java:534)
>
> but it didn't give more information on the last exception
> ........
> Thanks
>
> Guillaume Cottenceau wrote:
>
>> Oliver Jowett <oliver 'at' opencloud.com> writes:
>>
>>
>>
>>> Stéphane RIFF wrote:
>>>
>>>
>>>
>>>> 2005-03-01 12:23:44,156 : [WARN] SQLoader -
>>>> java.lang.NullPointerException
>>>>
>>>
>>> Can you get a stack trace for this exception? (the NPE, not the
>>> earlier one)
>>>
>>
>>
>> Stephan - in case, here's a method to get a human readable
>> stacktrace given an Exception object, if you don't use java 1.5:
>>
>>    public static String backtrace( Exception e ) {
>>        StackTraceElement[] trace = e.getStackTrace();
>>        StringBuffer sb = new StringBuffer();
>>        for ( int i = 2; i < trace.length; i++ ) {
>>            sb.append( "\t" ).append( trace[i].toString() ).append(
>> "\n" );
>>        }
>>        return sb.toString();
>>    }
>>
>>
>>
>
>
>



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.7 - Release Date: 01/03/2005