Hi Armin Oh, on temporarily switching to RC1 my userID/pw problem went away -- they are specified in the repository file -- I guess that when PBKey was supplied with null userID and password this is what appears in the debut output for the repository in 0.9.9.
Many thanks Mark -----Original Message----- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 9:45 AM To: OJB Users List Subject: Re: OJB and getting a PersistenceBroker instance for a second non-default database Hi Mark, ----- Original Message ----- From: "Mark Rowell" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 10:08 AM Subject: RE: OJB and getting a PersistenceBroker instance for a second non-default database > Armin > > I am using 0.9.9 as RC1 failed a lot of tests with the JSQLConnect driver I > was using (lots of socket closed exceptions > on SQLServer) -- RC1 unit tests did work with the MS JDBC driver but that is > slooooow, and when returning large numbers > of "rows" tends to crash my VM (1.4.1_02) Sounds very strange, maybe a configuration problem. Do you use the standard settings of OJB config files (repository + OJB.properties), where do you use different settings? I'm a little bit confused, because the stack trace of your previous post shows an oracle-driver. > > [java] sub-protocol=oracle > > [java] db-alias=thin:@165.193.152.53:1521:OPRD_CT1 > > [java] user=<null> > > [java] password=***** > > [java] eager-release=false > > [java] ConnectionPoolDescriptor={testOnReturn=false, The connection descriptor indicate that in your repository file wasn't set a user. Is this right? If so, you couldn't lookup a PB instance using PBKey("insight"). Somewhere OJB needs to know the the user/password. regards, Armin > > Mark > > -----Original Message----- > From: Armin Waibel [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 27, 2003 5:50 PM > To: OJB Users List > Subject: Re: OJB and getting a PersistenceBroker instance for a second > non-default database > > > Hi Mark, > > I add the following test > > public void testPBLookup() throws Exception > { > PBKey key = new PBKey(TestHelper.FAR_AWAY_JCD_ALIAS); > PersistenceBroker broker = > PersistenceBrokerFactory.createPersistenceBroker(key); > // get connection to check lookup > Connection con = > broker.serviceConnectionManager().getConnection(); > con.isClosed(); > assertNotNull(broker); > assertEquals(key.getAlias(), broker.getPBKey().getAlias()); > broker.close(); > > key = new PBKey(TestHelper.DEF_JCD_ALIAS); > broker = PersistenceBrokerFactory.createPersistenceBroker(key); > // get connection to check lookup > con = broker.serviceConnectionManager().getConnection(); > con.isClosed(); > assertNotNull(broker); > assertEquals(key.getAlias(), broker.getPBKey().getAlias()); > broker.close(); > } > > All works fine. > Which version do you use? > Could you post your test case? > > regards, > Armin > > ----- Original Message ----- > From: "Mark Rowell" <[EMAIL PROTECTED]> > To: "'OJB Users List'" <[EMAIL PROTECTED]> > Sent: Thursday, March 27, 2003 5:44 PM > Subject: RE: OJB and getting a PersistenceBroker instance for a second > non-default database > > > > Hi Armin > > > > Here is the stack trace; when I create a PBKey specifying the userID > and > > password it works just fine. > > > > [java] 0 ERROR [main] > accesslayer.ConnectionFactoryAbstractImpl - > > Error getting Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver) > > [java] java.sql.SQLException: invalid arguments in call > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > > [java] at > > oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) > > [java] at > > oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:183) > > [java] at > > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346) > > [java] at > > > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java: > 468) > > [java] at > > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:512) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:193) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:236) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFac > tory > > .makeObject(ConnectionFactoryPooledImpl.java:205) > > [java] at > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown > Source) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect > ionF > > romPool(ConnectionFactoryPooledImpl.java:65) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnec > > tion(ConnectionFactoryAbstractImpl.java:101) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Co > nnec > > tionManagerImpl.java:129) > > [java] at > > > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Stat > > ementManager.java:711) > > [java] at > > > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccess > Impl > > .java:261) > > [java] at > > > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175) > > [java] at > > > org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Rs > Iter > > atorFactoryImpl.java:95) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu > ery( > > PersistenceBrokerImpl.java:2156) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuer > y(Pe > > rsistenceBrokerImpl.java:1550) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorByQuery( > Pers > > istenceBrokerImpl.java:1536) > > [java] at > > > org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getIteratorBy > Quer > > y(DelegatingPersistenceBroker.java:278) > > [java] at > > com.credittrade.market.CTPriceDetail.main(CTPriceDetail.java:120) > > [java] 282 ERROR [main] accesslayer.JdbcAccessImpl - > > PersistenceBrokerException during the execution of the query: Used > > ConnectionManager instance could not obtain a connection: Could not > borrow > > connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > [java] jcd-alias=insight > > [java] default-connection=false > > [java] dbms=Oracle > > [java] jdbc-level=2.0 > > [java] driver=oracle.jdbc.driver.OracleDriver > > [java] protocol=jdbc > > [java] sub-protocol=oracle > > [java] db-alias=thin:@165.193.152.53:1521:OPRD_CT1 > > [java] user=<null> > > [java] password=***** > > [java] eager-release=false > > [java] ConnectionPoolDescriptor={testOnReturn=false, > maxWait=5000, > > timeBetweenEvictionRunsMillis=-1, testOnBorrow=true, > > numTestsPerEvictionRun=10, maxActive=10, removeAbandonedTimeout=300, > > removeAbandoned=false, maxIdle=-1, testWhileIdle=false, > > whenExhaustedAction=0, logAbandoned=false, > > minEvictableIdleTimeMillis=600000} > > [java] batchMode=false > > [java] sequenceDescriptor=<null> > > [java] ]: Error getting Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver): invalid arguments in call > > [java] java.sql.SQLException: invalid arguments in call > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > > [java] at > > oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) > > [java] at > > oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:183) > > [java] at > > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346) > > [java] at > > > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java: > 468) > > [java] at > > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:512) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:193) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:236) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFac > tory > > .makeObject(ConnectionFactoryPooledImpl.java:205) > > [java] at > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown > Source) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect > ionF > > romPool(ConnectionFactoryPooledImpl.java:65) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnec > > tion(ConnectionFactoryAbstractImpl.java:101) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Co > nnec > > tionManagerImpl.java:129) > > [java] at > > > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Stat > > ementManager.java:711) > > [java] at > > > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccess > Impl > > .java:261) > > [java] at > > > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175) > > [java] at > > > org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Rs > Iter > > atorFactoryImpl.java:95) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu > ery( > > PersistenceBrokerImpl.java:2156) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuer > y(Pe > > rsistenceBrokerImpl.java:1550) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorByQuery( > Pers > > istenceBrokerImpl.java:1536) > > [java] at > > > org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getIteratorBy > Quer > > y(DelegatingPersistenceBroker.java:278) > > [java] at > > com.credittrade.market.CTPriceDetail.main(CTPriceDetail.java:120) > > [java] rethrown as > > [java] org.apache.ojb.broker.accesslayer.LookupException: Error > getting > > Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver): invalid arguments in call > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:246) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFac > tory > > .makeObject(ConnectionFactoryPooledImpl.java:205) > > [java] at > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown > Source) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect > ionF > > romPool(ConnectionFactoryPooledImpl.java:65) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnec > > tion(ConnectionFactoryAbstractImpl.java:101) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Co > nnec > > tionManagerImpl.java:129) > > [java] at > > > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Stat > > ementManager.java:711) > > [java] at > > > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccess > Impl > > .java:261) > > [java] at > > > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175) > > [java] at > > > org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Rs > Iter > > atorFactoryImpl.java:95) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu > ery( > > PersistenceBrokerImpl.java:2156) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuer > y(Pe > > rsistenceBrokerImpl.java:1550) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorByQuery( > Pers > > istenceBrokerImpl.java:1536) > > [java] at > > > org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getIteratorBy > Quer > > y(DelegatingPersistenceBroker.java:278) > > [java] at > > com.credittrade.market.CTPriceDetail.main(CTPriceDetail.java:120) > > [java] Caused by: java.sql.SQLException: invalid arguments in > call > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > > [java] at > > oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) > > [java] at > > oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:183) > > [java] at > > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346) > > [java] at > > > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java: > 468) > > [java] at > > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:512) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:193) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:236) > > [java] ... 14 more > > [java] rethrown as > > [java] org.apache.ojb.broker.accesslayer.LookupException: Could > not > > borrow connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > [java] jcd-alias=insight > > [java] default-connection=false > > [java] dbms=Oracle > > [java] jdbc-level=2.0 > > [java] driver=oracle.jdbc.driver.OracleDriver > > [java] protocol=jdbc > > [java] sub-protocol=oracle > > [java] db-alias=thin:@165.193.152.53:1521:OPRD_CT1 > > [java] user=<null> > > [java] password=***** > > [java] eager-release=false > > [java] ConnectionPoolDescriptor={testOnReturn=false, > maxWait=5000, > > timeBetweenEvictionRunsMillis=-1, testOnBorrow=true, > > numTestsPerEvictionRun=10, maxActive=10, removeAbandonedTimeout=300, > > removeAbandoned=false, maxIdle=-1, testWhileIdle=false, > > whenExhaustedAction=0, logAbandoned=false, > > minEvictableIdleTimeMillis=600000} > > [java] batchMode=false > > [java] sequenceDescriptor=<null> > > [java] ]: Error getting Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver): invalid arguments in call > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect > ionF > > romPool(ConnectionFactoryPooledImpl.java:69) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnec > > tion(ConnectionFactoryAbstractImpl.java:101) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Co > nnec > > tionManagerImpl.java:129) > > [java] at > > > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Stat > > ementManager.java:711) > > [java] at > > > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccess > Impl > > .java:261) > > [java] at > > > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175) > > [java] at > > > org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Rs > Iter > > atorFactoryImpl.java:95) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu > ery( > > PersistenceBrokerImpl.java:2156) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuer > y(Pe > > rsistenceBrokerImpl.java:1550) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorByQuery( > Pers > > istenceBrokerImpl.java:1536) > > [java] at > > > org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getIteratorBy > Quer > > y(DelegatingPersistenceBroker.java:278) > > [java] at > > com.credittrade.market.CTPriceDetail.main(CTPriceDetail.java:120) > > [java] Caused by: > org.apache.ojb.broker.accesslayer.LookupException: > > Error getting Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver): invalid arguments in call > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:246) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFac > tory > > .makeObject(ConnectionFactoryPooledImpl.java:205) > > [java] at > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown > Source) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect > ionF > > romPool(ConnectionFactoryPooledImpl.java:65) > > [java] ... 11 more > > [java] Caused by: java.sql.SQLException: invalid arguments in > call > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > > [java] at > > oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) > > [java] at > > oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:183) > > [java] at > > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346) > > [java] at > > > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java: > 468) > > [java] at > > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:512) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:193) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:236) > > [java] ... 14 more > > [java] rethrown as > > [java] org.apache.ojb.broker.PersistenceBrokerException: Used > > ConnectionManager instance could not obtain a connection: Could not > borrow > > connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > [java] jcd-alias=insight > > [java] default-connection=false > > [java] dbms=Oracle > > [java] jdbc-level=2.0 > > [java] driver=oracle.jdbc.driver.OracleDriver > > [java] protocol=jdbc > > [java] sub-protocol=oracle > > [java] db-alias=thin:@165.193.152.53:1521:OPRD_CT1 > > [java] user=<null> > > [java] password=***** > > [java] eager-release=false > > [java] ConnectionPoolDescriptor={testOnReturn=false, > maxWait=5000, > > timeBetweenEvictionRunsMillis=-1, testOnBorrow=true, > > numTestsPerEvictionRun=10, maxActive=10, removeAbandonedTimeout=300, > > removeAbandoned=false, maxIdle=-1, testWhileIdle=false, > > whenExhaustedAction=0, logAbandoned=false, > > minEvictableIdleTimeMillis=600000} > > [java] batchMode=false > > [java] sequenceDescriptor=<null> > > [java] ]: Error getting Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver): invalid arguments in call > > [java] at > > > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Stat > > ementManager.java:715) > > [java] at > > > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccess > Impl > > .java:261) > > [java] at > > > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175) > > [java] at > > > org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Rs > Iter > > atorFactoryImpl.java:95) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu > ery( > > PersistenceBrokerImpl.java:2156) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuer > y(Pe > > rsistenceBrokerImpl.java:1550) > > [java] at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorByQuery( > Pers > > istenceBrokerImpl.java:1536) > > [java] at > > > org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getIteratorBy > Quer > > y(DelegatingPersistenceBroker.java:278) > > [java] at > > com.credittrade.market.CTPriceDetail.main(CTPriceDetail.java:120) > > [java] Caused by: > org.apache.ojb.broker.accesslayer.LookupException: > > Could not borrow connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > [java] jcd-alias=insight > > [java] default-connection=false > > [java] dbms=Oracle > > [java] jdbc-level=2.0 > > [java] driver=oracle.jdbc.driver.OracleDriver > > [java] protocol=jdbc > > [java] sub-protocol=oracle > > [java] db-alias=thin:@165.193.152.53:1521:OPRD_CT1 > > [java] user=<null> > > [java] password=***** > > [java] eager-release=false > > [java] ConnectionPoolDescriptor={testOnReturn=false, > maxWait=5000, > > timeBetweenEvictionRunsMillis=-1, testOnBorrow=true, > > numTestsPerEvictionRun=10, maxActive=10, removeAbandonedTimeout=300, > > removeAbandoned=false, maxIdle=-1, testWhileIdle=false, > > whenExhaustedAction=0, logAbandoned=false, > > minEvictableIdleTimeMillis=600000} > > [java] batchMode=false > > [java] sequenceDescriptor=<null> > > [java] ]: Error getting Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver): invalid arguments in call > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect > ionF > > romPool(ConnectionFactoryPooledImpl.java:69) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnec > > tion(ConnectionFactoryAbstractImpl.java:101) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Co > nnec > > tionManagerImpl.java:129) > > [java] at > > > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Stat > > ementManager.java:711) > > [java] ... 8 more > > [java] Caused by: > org.apache.ojb.broker.accesslayer.LookupException: > > Error getting Connection from DriverManager with url > > (jdbc:oracle:thin:@165.193.152.53:1521:OPRD_CT1) and driver > > (oracle.jdbc.driver.OracleDriver): invalid arguments in call > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:246) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFac > tory > > .makeObject(ConnectionFactoryPooledImpl.java:205) > > [java] at > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown > Source) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect > ionF > > romPool(ConnectionFactoryPooledImpl.java:65) > > [java] ... 11 more > > [java] Caused by: java.sql.SQLException: invalid arguments in > call > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > [java] at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > > [java] at > > oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) > > [java] at > > oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:183) > > [java] at > > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346) > > [java] at > > > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java: > 468) > > [java] at > > oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:512) > > [java] at > > java.sql.DriverManager.getConnection(DriverManager.java:193) > > [java] at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:236) > > [java] ... 14 more > > > > And here is my repository fragment (I have xxxxx'ed out the userID and > > password as this is a live database!) > > > > <jdbc-connection-descriptor > > jcd-alias="insight" > > default-connection="false" > > platform="Oracle" > > jdbc-level="2.0" > > driver="oracle.jdbc.driver.OracleDriver" > > protocol="jdbc" > > subprotocol="oracle" > > dbalias="thin:@165.193.152.53:1521:OPRD_CT1" > > username="xxxxxxxx" > > password="xxxxxxxxx" > > batch-mode="false" > > eager-release="false" > > useAutoCommit="2" > > ignoreAutoCommitExceptions="false" > > > > > > > <connection-pool > > maxActive="10" > > validationQuery="" /> > > > > </jdbc-connection-descriptor> > > > > Many thanks > > > > Mark > > > > -----Original Message----- > > From: Armin Waibel [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 27, 2003 4:23 PM > > To: OJB Users List > > Subject: Re: OJB and getting a PersistenceBroker instance for a second > > non-default database > > > > > > Hi Mark, > > > > > I tried the single argument constructor for PBKey but no joy. > > this should be possible, could you post an example and > > the resulting stack trace? > > > > regards, > > Armin > > > > ----- Original Message ----- > > From: "Mark Rowell" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, March 27, 2003 5:00 PM > > Subject: OJB and getting a PersistenceBroker instance for a second > > non-default database > > > > > > > Hi > > > > > > I know I can get a default PB instance using > defaultPersistenceBroker > > on > > > PBFactory and that for a second database I can get a broker if I > > specify the > > > alias and the userID and password > > > to use for the second repositiry, but is there a way of getting a > > broker > > > instance for the second database whereby it picks up the userID and > > password > > > specified in the repository file? > > > > > > I tried the single argument constructor for PBKey but no joy. > > > > > > Thanks > > > > > > Mark > > > > > > ---------------------------------------------------------------- > > > Mark Rowell > > > CreditTrade > > > > > > T: +44 (020) 7400 5078 > > > M: mailto:[EMAIL PROTECTED] > > > > > > CreditTrade Limited is regulated by the FSA. (c) CreditTrade 2002. > All > > rights reserved. The information and data contained in this email is > > provided for the information purposes of the addressee only and should > > not be reproduced and/or distributed to any other person. It is > provided > > without any warranty whatsoever and unless stated otherwise consists > > purely of indicative market prices and other information. > > > > > > Any opinion or comments expressed or assumption made in association > > with the data or information provided in this email is a reflection of > > CreditTrades judgement at the time of compiling the data and is > subject > > to change. CreditTrade hereby makes no representation and accepts no > > responsibility or liability as to the completeness or accuracy of this > > email. > > > > > > The content of this email is not intended as an offer or > solicitation > > for, or recommendation of, the purchase or sale of any financial > > instrument, or as an official confirmation of any transaction, and > > should not be construed as investment advice. > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > CreditTrade Limited is regulated by the FSA. (c) CreditTrade 2002. All > rights reserved. The information and data contained in this email is > provided for the information purposes of the addressee only and should > not be reproduced and/or distributed to any other person. It is provided > without any warranty whatsoever and unless stated otherwise consists > purely of indicative market prices and other information. > > > > Any opinion or comments expressed or assumption made in association > with the data or information provided in this email is a reflection of > CreditTrades judgement at the time of compiling the data and is subject > to change. CreditTrade hereby makes no representation and accepts no > responsibility or liability as to the completeness or accuracy of this > email. > > > > The content of this email is not intended as an offer or solicitation > for, or recommendation of, the purchase or sale of any financial > instrument, or as an official confirmation of any transaction, and > should not be construed as investment advice. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > CreditTrade Limited is regulated by the FSA. (c) CreditTrade 2002. All rights reserved. The information and data contained in this email is provided for the information purposes of the addressee only and should not be reproduced and/or distributed to any other person. It is provided without any warranty whatsoever and unless stated otherwise consists purely of indicative market prices and other information. > > Any opinion or comments expressed or assumption made in association with the data or information provided in this email is a reflection of CreditTrades judgement at the time of compiling the data and is subject to change. CreditTrade hereby makes no representation and accepts no responsibility or liability as to the completeness or accuracy of this email. > > The content of this email is not intended as an offer or solicitation for, or recommendation of, the purchase or sale of any financial instrument, or as an official confirmation of any transaction, and should not be construed as investment advice. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] CreditTrade Limited is regulated by the FSA. (c) CreditTrade 2002. All rights reserved. The information and data contained in this email is provided for the information purposes of the addressee only and should not be reproduced and/or distributed to any other person. It is provided without any warranty whatsoever and unless stated otherwise consists purely of indicative market prices and other information. Any opinion or comments expressed or assumption made in association with the data or information provided in this email is a reflection of CreditTrades judgement at the time of compiling the data and is subject to change. CreditTrade hereby makes no representation and accepts no responsibility or liability as to the completeness or accuracy of this email. The content of this email is not intended as an offer or solicitation for, or recommendation of, the purchase or sale of any financial instrument, or as an official confirmation of any transaction, and should not be construed as investment advice. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
