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 2003/09/10 22:00:22 UTC

DO NOT REPLY [Bug 23081] New: - DBCP - Bad DB Validation Query Hangs Everything

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=23081>.
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=23081

DBCP - Bad DB Validation Query Hangs Everything

           Summary: DBCP - Bad DB Validation Query Hangs Everything
           Product: Commons
           Version: 1.0 Final
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Dbcp
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: ahorton@ix.netcom.com


If the ValidationQuery assigned to a BasicDataSource is bogus (or typed wrong), 
the getConnection()  will just hang, and hang, and hang...  For example, try
SELECT * FROM X
or SELECT * FROM DUAL;   <=  note the semicolon which is invalid

I am running against an Oracle 9i DB with the thinODBC Oracle driver.

Thanks,
Ann