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)
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]
