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]
