You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by bu...@apache.org on 2002/10/26 13:21:45 UTC

DO NOT REPLY [Bug 13988] New: - permission error makes connection loop 

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13988>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13988

permission error makes connection loop 

           Summary: permission error makes connection loop
           Product: Commons
           Version: 1.0 Final
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Dbcp
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: theo.van.rijn@kabelfoon.nl


A validation query in a Tomcat datasource, for which the connecting user had no
authorization, made the connect 'loop'.

I use postgresql 7.2 and tried both the latest pgjdbc2.jar and the older
jdbc7.1-1.2.jar in combination with two JVM's: IBMJava2-13 and Sun j2sdk1.4.1.

I found the problem by turning postgresql logging on. I found this in the log:
postgres[10846]: [23] ERROR:  cashflows: Permission denied.
The problem was solved by granting access to the table I used in the validation
query.

This is the top of the stack during the lockup:
Thread [Thread-5] (Suspended)
	java.net.SocketInputStream.socketRead0(java.io.FileDescriptor, byte[], int,
int, int) line: not available [native method]
	java.net.SocketInputStream.read(byte[], int, int) line: 129 [local variables
unavailable]
	java.io.BufferedInputStream.fill() line: 183 [local variables unavailable]
	java.io.BufferedInputStream.read() line: 201 [local variables unavailable]
	org.postgresql.PG_Stream.ReceiveChar() line: 141 [local variables unavailable]
	org.postgresql.jdbc2.Connection(org.postgresql.Connection).openConnection(java.lang.String, int, java.util.Properties, java.lang.String, java.lang.String, org.postgresql.Driver) line: 265 [local variables unavailable]
	org.postgresql.Driver.connect(java.lang.String, java.util.Properties) line: 149
[local variables unavailable]
	org.apache.commons.dbcp.DriverConnectionFactory.createConnection() line: not
available
	org.apache.commons.dbcp.PoolableConnectionFactory.makeObject() line: not available
	org.apache.commons.dbcp.AbandonedObjectPool(org.apache.commons.pool.impl.GenericObjectPool).borrowObject() line: not available [local variables unavailable]
	org.apache.commons.dbcp.AbandonedObjectPool.borrowObject() line: not available
	org.apache.commons.dbcp.PoolingDataSource.getConnection() line: not available
	org.apache.commons.dbcp.BasicDataSource.getConnection() line: not available

I have a problem connecting the java code of the commons-dbcp package in my
workbench. This is why I can't debug the commons code.

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>