I work whith rc5.
When I want to acces a table to find a classe who contain a Map, I have an
error because it try to find the internal table in the same database where
is the table. The table is in the Db2 db and internal table in the MySQL
db.
My repository.xml :
<jdbc-connection-descriptor
platform="MySQL"
jcd-alias="default"
default-connection="true"
jdbc-level="2.0"
driver="org.gjt.mm.mysql.Driver"
protocol="jdbc"
subprotocol="mysql"
dbalias="//arsodev1:3306/CoopgenUC"
username="root"
password="secret"
/>
<jdbc-connection-descriptor
platform="Db2"
jcd-alias="as400"
default-connection="false"
jdbc-level="2.0"
driver="com.ibm.as400.access.AS400JDBCDriver"
protocol="jdbc"
subprotocol="as400"
dbalias="//ASDEV"
username="RENARD"
password="123456"
/>
<!-- include user defined mappings here -->
&useruc;
<!-- include ojb internal mappings here -->
&internal;
When I don't need internal table all work fine but when i try to acces to
a Map/Collection have an error. repository_internal.xml is the one provide
with the rc5.
My problematic classe is define with :
<class-descriptor
class="com.arsoe.trelaze.coopgen.metier.cooperative.Cooperative"
table="CIADATA.COOP">
...
<collection-descriptor
name="mesInseminateurs"
element-class-ref="com.arsoe.trelaze.coopgen.metier.inseminateur.Inseminateur"
collection-class="org.apache.ojb.odmg.collections.DMapImpl">
<inverse-foreignkey field-ref="idCoop"/>
</collection-descriptor>
</class-descriptor>
Is someone have any idea of where could be my configuration mistake ?
The error :
[org.apache.ojb.broker.accesslayer.RsIterator] ERROR: Error while iterate
ResultSet for query org.apache.ojb.broker.accesslayer.RsQueryObject[
uery: Query from class
com.arsoe.trelaze.coopgen.metier.cooperative.Cooperative where
{code=C720}, class descriptor:
com.arsoe.trelaze.coopgen.metier.cooperative.Cooperative]
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.util.sequence.SequenceManagerException: Can't build
new sequence
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.util.sequence.SequenceManagerException: Can't build
new sequence
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollection(Unknown
Source)
at
org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollections(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
at
com.arsoe.trelaze.socle.dao.odmg.ODMGDataAccessObject.find(ODMGDataAccessObject.java:292)
...
Caused by: org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.util.sequence.SequenceManagerException: Can't build
new sequence
at org.apache.ojb.odmg.collections.DMapImpl.generateNewId(Unknown
Source)
at org.apache.ojb.odmg.collections.DMapImpl.<init>(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:306)
at java.lang.Class.newInstance(Class.java:259)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
... 52 more
Caused by: org.apache.ojb.broker.util.sequence.SequenceManagerException:
Can't build new sequence
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(Unknown
Source)
... 61 more
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: [SQL0204] OJB_HL_SEQ de type *FILE dans RENARD non
trou
�.
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.lookupStoreSequence(Unknown
Source)
... 64 more
Nicolas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
