You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Mark Rowell <Ma...@credittrade.com> on 2003/03/27 17:44:42 UTC
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.newConnectio
nFromDriverManager(ConnectionFactoryAbstractImpl.java:236)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory
.makeObject(ConnectionFactoryPooledImpl.java:205)
[java] at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
romPool(ConnectionFactoryPooledImpl.java:65)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(ConnectionFactoryAbstractImpl.java:101)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connec
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(JdbcAccessImpl
.java:261)
[java] at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175)
[java] at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(RsIter
atorFactoryImpl.java:95)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2156)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(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.getIteratorByQuer
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:
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
[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.newConnectio
nFromDriverManager(ConnectionFactoryAbstractImpl.java:236)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory
.makeObject(ConnectionFactoryPooledImpl.java:205)
[java] at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
romPool(ConnectionFactoryPooledImpl.java:65)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(ConnectionFactoryAbstractImpl.java:101)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connec
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(JdbcAccessImpl
.java:261)
[java] at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175)
[java] at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(RsIter
atorFactoryImpl.java:95)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2156)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(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.getIteratorByQuer
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.newConnectio
nFromDriverManager(ConnectionFactoryAbstractImpl.java:246)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory
.makeObject(ConnectionFactoryPooledImpl.java:205)
[java] at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
romPool(ConnectionFactoryPooledImpl.java:65)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(ConnectionFactoryAbstractImpl.java:101)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connec
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(JdbcAccessImpl
.java:261)
[java] at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175)
[java] at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(RsIter
atorFactoryImpl.java:95)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2156)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(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.getIteratorByQuer
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.newConnectio
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:
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
[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.getConnectionF
romPool(ConnectionFactoryPooledImpl.java:69)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(ConnectionFactoryAbstractImpl.java:101)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connec
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(JdbcAccessImpl
.java:261)
[java] at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175)
[java] at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(RsIter
atorFactoryImpl.java:95)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2156)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(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.getIteratorByQuer
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.newConnectio
nFromDriverManager(ConnectionFactoryAbstractImpl.java:246)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory
.makeObject(ConnectionFactoryPooledImpl.java:205)
[java] at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
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.newConnectio
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:
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
[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(JdbcAccessImpl
.java:261)
[java] at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175)
[java] at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(RsIter
atorFactoryImpl.java:95)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2156)
[java] at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(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.getIteratorByQuer
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:
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
[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.getConnectionF
romPool(ConnectionFactoryPooledImpl.java:69)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(ConnectionFactoryAbstractImpl.java:101)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connec
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.newConnectio
nFromDriverManager(ConnectionFactoryAbstractImpl.java:246)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory
.makeObject(ConnectionFactoryPooledImpl.java:205)
[java] at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
[java] at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
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.newConnectio
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:armin.waibel@code-au-lait.de]
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" <Ma...@credittrade.com>
To: <oj...@db.apache.org>
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:mark.rowell@credittrade.com
>
> 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
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.
Re: OJB and getting a PersistenceBroker instance for a second non-default database
Posted by Armin Waibel <ar...@code-au-lait.de>.
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" <Ma...@credittrade.com>
To: "'OJB Users List'" <oj...@db.apache.org>
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:
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
> [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:
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
> [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:
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
> [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:
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1d6f122[
> [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:armin.waibel@code-au-lait.de]
> 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" <Ma...@credittrade.com>
> To: <oj...@db.apache.org>
> 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:mark.rowell@credittrade.com
> >
> > 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: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
> 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
Re: OJB/ODMG Question
Posted by Thomas Mahler <th...@web.de>.
Hi Julio,
Julio Barros wrote:
> Hi,
>
> I've got a question about how to do updates on persistent objects
> using JDO's ODMG Api. I would look at the mailing list archive but it
> does not seem to be working. I've also looked at the apache jdo
> website and there is a lot information there and I was wondering if
> anyone had any links to other tutorials or examples.
>
> I've looked at tutorial 2, especially UCEdit, which works fine and I
> understand what it is doing. That use-case, starts a transaction,
> gets an object, gets a write lock, modifies the object, and then
> commits the transaction.
>
> The thing is that I would like to modify an object in a different
> layer that is not db aware. I would like to use a db manager layer to
> do the reads and writes. If I've gotten the object in one transaction
> that was commited and then modified the object outside of a
> transaction, what should the save method look like?
>
> What I first tried to do was, start a transaction, get a write lock,
> commit the transaction. But that did not work probably because the
> lock did not detect a change in the object.
correct! the ODMG transaction manager can only detect changes made
within the same transaction.
> I then tried to, start a
> transaction, query for the object, copy the values into the new
> object, commit the transaction. But that did not work either, I'm
> guessing because my second query retrieved the object from the cache
> and then the transaction did not detect an actual change in the object
> since the lock was acquired after the object was really modified.
correct again.
ODMG has no notion of long transactions. That's why you have to to the
swizzling on your own.
To store an updated object X
You have to:
1. remove X from cache (with a PersistenceBroker call)
2. start the tx
3. query the db version of X (X') from the database.
(On querying it gets automatically locked to the transaction)
4. set all attributes of X' to the corresponding values of X
5. commit the tx
>
> Is there a way to mark the object "dirty"? Do I need to remove it
> from the cache? Is there a simpler solution?
Using the PersistenceBroker API for your db manager layer could be much
easier than using ODMG for that purpose.
The ODMG programming model is not very well suited for such a manager.
The ODMG programming model assumes that your business logic makes direct
use of ODMG transactions.
> What am I overlooking?
> Also, is there a good reference for OQL?
http://www.poet.com has excellent ODMG resources in the developer section.
>
> Thanks in advance,
>
> Julio
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
OJB/ODMG Question
Posted by Julio Barros <Ju...@E-String.com>.
Hi,
I've got a question about how to do updates on persistent objects
using JDO's ODMG Api. I would look at the mailing list archive but it
does not seem to be working. I've also looked at the apache jdo
website and there is a lot information there and I was wondering if
anyone had any links to other tutorials or examples.
I've looked at tutorial 2, especially UCEdit, which works fine and I
understand what it is doing. That use-case, starts a transaction,
gets an object, gets a write lock, modifies the object, and then
commits the transaction.
The thing is that I would like to modify an object in a different
layer that is not db aware. I would like to use a db manager layer to
do the reads and writes. If I've gotten the object in one transaction
that was commited and then modified the object outside of a
transaction, what should the save method look like?
What I first tried to do was, start a transaction, get a write lock,
commit the transaction. But that did not work probably because the
lock did not detect a change in the object. I then tried to, start a
transaction, query for the object, copy the values into the new
object, commit the transaction. But that did not work either, I'm
guessing because my second query retrieved the object from the cache
and then the transaction did not detect an actual change in the object
since the lock was acquired after the object was really modified.
Is there a way to mark the object "dirty"? Do I need to remove it
from the cache? Is there a simpler solution? What am I overlooking?
Also, is there a good reference for OQL?
Thanks in advance,
Julio