Sorry, this was truly a "novice" post but I learned something. Forgot to build the peers for Oracle target.
> -----Original Message----- > From: Mark Orciuch [mailto:mark_orciuch@;ngsltd.com] > Sent: Thursday, November 07, 2002 5:13 PM > To: Jetspeed Developers List > Subject: Database Psml profiler under Oracle > > > 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(OracleStat > ement.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(Sequ > enceIdGene > rator.java:195) > at > org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal(Sequen > ceIdGenera > 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.doInsertOrUp > date(Jetsp > eedUserProfilePeer.java:105) > at > org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.insert(Jetsp > eedUserPro > filePeer.java:65) > at > org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerSer > vice.creat > eOrSaveDocument(DatabasePsmlManagerService.java:647) > at > org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerSer > vice.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(PsmlImpo > rter.java: > 210) > at > org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImp > orter.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> -- To unsubscribe, e-mail: <mailto:jetspeed-dev-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:jetspeed-dev-help@;jakarta.apache.org>
