Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 43596 invoked from network); 8 Aug 2004 11:50:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 8 Aug 2004 11:50:03 -0000 Received: (qmail 79054 invoked by uid 500); 8 Aug 2004 11:50:02 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 79018 invoked by uid 500); 8 Aug 2004 11:50:02 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 79003 invoked by uid 99); 8 Aug 2004 11:50:02 -0000 X-ASF-Spam-Status: No, hits=-2.8 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.27.1) with SMTP; Sun, 08 Aug 2004 04:50:01 -0700 Received: (qmail 43574 invoked from network); 8 Aug 2004 11:50:00 -0000 Received: from localhost.hyperreal.org (HELO ?127.0.0.1?) (127.0.0.1) by localhost.hyperreal.org with SMTP; 8 Aug 2004 11:50:00 -0000 Message-ID: <411613B5.3000800@apache.org> Date: Sun, 08 Aug 2004 13:51:17 +0200 From: Armin Waibel User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Developers List Subject: Re: Please test the new commons-sql dbhandling References: <410963CE.9030001@first.fhg.de> <4111EECB.4000106@apache.org> <4111FAE0.90407@apache.org> <4111FEDA.7070807@first.fhg.de> <411204B7.4090803@apache.org> <41120663.3050005@apache.org> <41160FEA.7000703@first.fhg.de> In-Reply-To: <41160FEA.7000703@first.fhg.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: localhost.hyperreal.org 1.6.2 0/1000/N X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Thomas Dudziak wrote: > MaxDB works now with commons-sql dbhandling - I made ASCII (i.e. none > specified) the default and added the ability to specify database > properties in the task (e.g. for UNICODE). > However, I get one more unit test failures with commons-sql than I get > with torque: > > hmm, I think this isn't a real failure. Assume that the failure was caused by the internal sapDB connection pool or some other limitation > Caused by: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP > DBTech JDBC: Cannot connect to jdbc:sapdb://localhost/OJB [Task limit]. I run the dbhandling + test suite on my machine without this failure. Great work Tom! Armin > Testcase: testMultithreadedLazyRead took 9,922 sec > Caused an ERROR > Used ConnectionManager instance could not obtain a connection > org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager > instance could not obtain a connection > at > org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(StatementManager.java:660) > > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAccessImpl.java:550) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.java:1245) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.doGetObjectByIdentity(PersistenceBrokerImpl.java:1368) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBrokerImpl.java:1347) > > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(DelegatingPersistenceBroker.java:312) > > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(DelegatingPersistenceBroker.java:312) > > at > org.apache.ojb.broker.MultithreadedReadTest$TestHandleLazyRead.runTestCase(MultithreadedReadTest.java:326) > > at > org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase$TestCaseRunnable.run(JUnitExtensions.java:186) > > at java.lang.Thread.run(Thread.java:534) > Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not > borrow connection from pool - > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@186df0f[ > jcd-alias=default > default-connection=true > dbms=MaxDB > jdbc-level=2.0 > driver=com.sap.dbtech.jdbc.DriverSapDB > protocol=jdbc > sub-protocol=sapdb > db-alias=//localhost/OJB > user=ojbtest > password=***** > eager-release=false > ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, > maxActive=21, maxWait=5000, removeAbandoned=false, > numTestsPerEvictionRun=10, testWhileIdle=false, > minEvictableIdleTimeMillis=600000, testOnReturn=false, > logAbandoned=false, removeAbandonedTimeout=300, > timeBetweenEvictionRunsMillis=-1, testOnBorrow=true} > batchMode=false > useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE > ignoreAutoCommitExceptions=false > > sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDescriptor@32784a[ > > sequenceManagerClass=class > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > Properties={autoNaming=true, globalSequenceId=false, > globalSequenceStart=10000, grabSize=20} > ] > ] > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(ConnectionFactoryPooledImpl.java:85) > > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:116) > > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:105) > > at > org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(StatementManager.java:652) > > ... 9 more > Caused by: org.apache.ojb.broker.accesslayer.LookupException: Error > getting Connection from DriverManager with url > (jdbc:sapdb://localhost/OJB) and driver (com.sap.dbtech.jdbc.DriverSapDB) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(ConnectionFactoryAbstractImpl.java:259) > > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.makeObject(ConnectionFactoryPooledImpl.java:231) > > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) > > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(ConnectionFactoryPooledImpl.java:81) > > ... 12 more > Caused by: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP > DBTech JDBC: Cannot connect to jdbc:sapdb://localhost/OJB [Task limit]. > at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:183) > at java.sql.DriverManager.getConnection(DriverManager.java:512) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(ConnectionFactoryAbstractImpl.java:253) > > ... 15 more > > Caused an ERROR > Used ConnectionManager instance could not obtain a connection > org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager > instance could not obtain a connection > at > org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(StatementManager.java:660) > > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAccessImpl.java:550) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.java:1245) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.doGetObjectByIdentity(PersistenceBrokerImpl.java:1368) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBrokerImpl.java:1347) > > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(DelegatingPersistenceBroker.java:312) > > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(DelegatingPersistenceBroker.java:312) > > at > org.apache.ojb.broker.MultithreadedReadTest$TestHandleLazyRead.runTestCase(MultithreadedReadTest.java:326) > > at > org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase$TestCaseRunnable.run(JUnitExtensions.java:186) > > at java.lang.Thread.run(Thread.java:534) > Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not > borrow connection from pool - > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@186df0f[ > jcd-alias=default > default-connection=true > dbms=MaxDB > jdbc-level=2.0 > driver=com.sap.dbtech.jdbc.DriverSapDB > protocol=jdbc > sub-protocol=sapdb > db-alias=//localhost/OJB > user=ojbtest > password=***** > eager-release=false > ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, > maxActive=21, maxWait=5000, removeAbandoned=false, > numTestsPerEvictionRun=10, testWhileIdle=false, > minEvictableIdleTimeMillis=600000, testOnReturn=false, > logAbandoned=false, removeAbandonedTimeout=300, > timeBetweenEvictionRunsMillis=-1, testOnBorrow=true} > batchMode=false > useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE > ignoreAutoCommitExceptions=false > > sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDescriptor@32784a[ > > sequenceManagerClass=class > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > Properties={autoNaming=true, globalSequenceId=false, > globalSequenceStart=10000, grabSize=20} > ] > ] > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(ConnectionFactoryPooledImpl.java:85) > > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:116) > > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:105) > > at > org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(StatementManager.java:652) > > ... 9 more > Caused by: org.apache.ojb.broker.accesslayer.LookupException: Error > getting Connection from DriverManager with url > (jdbc:sapdb://localhost/OJB) and driver (com.sap.dbtech.jdbc.DriverSapDB) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(ConnectionFactoryAbstractImpl.java:259) > > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.makeObject(ConnectionFactoryPooledImpl.java:231) > > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) > > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(ConnectionFactoryPooledImpl.java:81) > > ... 12 more > Caused by: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP > DBTech JDBC: Cannot connect to jdbc:sapdb://localhost/OJB [Task limit]. > at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:183) > at java.sql.DriverManager.getConnection(DriverManager.java:512) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(ConnectionFactoryAbstractImpl.java:253) > > ... 15 more > > > > Any idea ? > > Tom > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org > For additional commands, e-mail: ojb-dev-help@db.apache.org > > > --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org