[ 
http://issues.apache.org/jira/browse/DBCP-196?page=comments#action_12442199 ] 
            
Eric Ferrer commented on DBCP-196:
----------------------------------


   [[ Old comment, sent by email on Wed, 9 Aug 2006 16:53:19 -0700 ]]

Hope this makes it on JIRA, didnt see a way to post a comment.

OJB is told to use DBCP for connection pooling and the following properties are 
passed to it.

<jdbc-connection-descriptor jcd-alias="APPLICATION" 
  default-connection="true" platform="MsSQLServer" jdbc-level="4.0"
        driver="net.sourceforge.jtds.jdbc.Driver"
        dbalias="//myDatabase:4455/hDB;SelectMethod=cursor"
        username="hDB" password="hDB"
        eager-release="false" batch-mode="false" protocol="jdbc" 
subprotocol="jtds:sqlserver" 
        useAutoCommit="1" ignoreAutoCommitExceptions="false">
        <connection-pool maxActive="255" validationQuery="SELECT 1" />
</jdbc-connection-descriptor>

We have an enterprise license for SQL Server.  Waiting to get information from 
DBA on max number of concurrent users, etc.


---- "Henri Yandell (JIRA)" <[EMAIL PROTECTED]> wrote: 


> Unexpected error with DBCP and OJB where OJB was unable to get a connection.  
> The root cause appears to be a org.apache.commons.dbcp.SQLNestedException: 
> Cannot get a connection, pool exhausted, cause: null
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DBCP-196
>                 URL: http://issues.apache.org/jira/browse/DBCP-196
>             Project: Commons Dbcp
>          Issue Type: Bug
>         Environment: Jboss 4.0
> commons-dbcp-1.1.jar
> commons-pool-1.1.jar
> db-ojb-1.0.rc6.jar
>            Reporter: Eric Ferrer
>            Priority: Critical
>         Attachments: dbcp_exhausted_connection_error.txt
>
>
> Our application has been running fine for 9 months and this is the first time 
> I have encounted this error.  It happend randomly throughout the day in an 
> inconsistent pattern (user was entering data on web, user was searching for 
> data, ect.)  It did not occur on any particular screen.  Attached is the 
> stack trace from OJB Broker loadByExample request to DBCP error.  THe rest of 
> the stack trace was ommitted since it involves the uncaught exception entire 
> stack back to the web tier

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to