I know that this topic has probably been beaten to death but I'm still
confused. The generated dbpsml schema has sequences such as:
CREATE SEQUENCE JETSPEED_USER_PROFILE_SEQ INCREMENT BY 1 START WITH 1
NOMAXVALUE NOCYCLE NOCACHE ORDER
When I try to run PsmlImporter, the Torque goes after a sequence with
different name:
[07 Nov 2002 17:07:13 DEBUG] - select JETSPEED_USER_PROFILE.nextval from
dual
[07 Nov 2002 17:07:13 WARN] -
DatabasePsmlManagerService.createOrSaveDocument: profile:
BaseProfile[user/admin/html/default.psml] tableName: JETSPEED_USER_PROFILE
java.sql.SQLException: ORA-02289: sequence does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1819)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2015)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:571)
at com.workingdogs.village.QueryDataSet.<init>(Unknown Source)
at
org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue(SequenceIdGene
rator.java:195)
at
org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal(SequenceIdGenera
tor.java:132)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:206)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:499)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.doInsertOrUpdate(Jetsp
eedUserProfilePeer.java:105)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.insert(JetspeedUserPro
filePeer.java:65)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eOrSaveDocument(DatabasePsmlManagerService.java:647)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eDocument(DatabasePsmlManagerService.java:607)
at
org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas
torPsmlManagerService.java:1255)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java:
210)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImporter.java
:179)
I don't think that sequence can be named the same as table name. What goes?
I am using:
Oracle
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
Oracle JDBC driver
8.1.7.1.0
Best regards,
Mark C. Orciuch
Next Generation Solutions, Ltd.
e-Mail: [EMAIL PROTECTED]
web: http://www.ngsltd.com
--
To unsubscribe, e-mail: <mailto:jetspeed-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@;jakarta.apache.org>
