Hello,
I have a problem with HSQLDB, I use OJB 0.9.8.
When I store an object with a primary key, I obtain this exception.
Have you an idea ?
<class-descriptor
class="test.banque.domaine.compte.OperationCredit"
table="OPERATION"
>
<field-descriptor id="1"
name="id"
column="OPE_ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="compteId"
column="ACC_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="libelle"
column="OPE_LABEL"
jdbc-type="VARCHAR"
/>
<field-descriptor id="4"
name="montant"
column="OPE_AMOUNT"
jdbc-type="DOUBLE"
/>
<field-descriptor id="5"
name="date"
column="OPE_DATE"
jdbc-type="DATE"
conversion="aston.solution.ojb.converters.DateToDateSQL"
/>
</class-descriptor>
Exception :
DBMS:Hsqldb
DRIVER: org.hsqldb.jdbcDriver
PROTOCOL: jdbc
SUBPROTOCOL: hsqldb
DBALIAS: hsql://localhost:9001
USERNAME: sa
PASSWORD:
EAGER RELEASE: false
at
org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Sequen
ceGenerator.java:92)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId(Sequ
enceManagerHiLoImpl.java:65)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUniqueId(Persistence
BrokerImpl.java:2272)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getUniqueId(Deleg
atingPersistenceBroker.java:248)
at
org.apache.ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(ClassDe
scriptor.java:1082)
at
org.apache.ojb.broker.metadata.ClassDescriptor.getKeyValuesForObject(ClassDe
scriptor.java:931)
at
org.apache.ojb.broker.metadata.ClassDescriptor.getKeyValues(ClassDescriptor.
java:908)
at
org.apache.ojb.broker.metadata.ClassDescriptor.getKeyValues(ClassDescriptor.
java:883)
at org.apache.ojb.broker.Identity.<init>(Identity.java:191)
... 21 more
Caused by: org.apache.ojb.broker.PersistenceBrokerException: Could not
borrow connection from pool -
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
JdbcConnectionDescriptor
DBMS:Hsqldb
DRIVER: org.hsqldb.jdbcDriver
PROTOCOL: jdbc
SUBPROTOCOL: hsqldb
DBALIAS: hsql://localhost:9001
USERNAME: sa
PASSWORD:
EAGER RELEASE: false
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(St
atementsForClassImpl.java:245)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Sta
tementsForClassImpl.java:188)
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Stat
ementManager.java:632)
at
org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(JdbcAccess.java:24
0)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:249)
at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(RsIter
atorFactoryImpl.java:95)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2505)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQueryE
xtentAware(PersistenceBrokerImpl.java:1719)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Pe
rsistenceBrokerImpl.java:1599)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Pe
rsistenceBrokerImpl.java:1250)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Pe
rsistenceBrokerImpl.java:1405)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Pe
rsistenceBrokerImpl.java:1431)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Pe
rsistenceBrokerImpl.java:1418)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Persis
tenceBrokerImpl.java:1818)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getObjectByQuery(
DelegatingPersistenceBroker.java:275)
at
org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Sequen
ceGenerator.java:57)
... 29 more
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not
borrow connection from pool -
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
JdbcConnectionDescriptor
DBMS:Hsqldb
DRIVER: org.hsqldb.jdbcDriver
PROTOCOL: jdbc
SUBPROTOCOL: hsqldb
DBALIAS: hsql://localhost:9001
USERNAME: sa
PASSWORD:
EAGER RELEASE: false
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
romPool(ConnectionFactoryPooledImpl.java:69)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(ConnectionFactoryAbstractImpl.java:89)
at
org.apache.ojb.broker.accesslayer.ConnectionManager.getConnection(Connection
Manager.java:122)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(St
atementsForClassImpl.java:240)
... 44 more
Caused by: java.util.NoSuchElementException
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
l.java:720)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
romPool(ConnectionFactoryPooledImpl.java:65)
... 47 more
