You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by je...@jakarta.apache.org on 2004/07/21 05:41:40 UTC
[jira] Commented: (JS1-183) nonexistent sequence error with oracle
The following comment has been added to this issue:
Author: Eric L. Wittle
Created: Tue, 20 Jul 2004 8:41 PM
Body:
I ran 1.4 for quite a while on Oracle 9i without seeing this problem. The class is auto-generated, I don't think the class itself was actually in the distribution.
Maybe this error needs to go into the FAQ?
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/JS1-183?page=comments#action_36797
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/JS1-183
Here is an overview of the issue:
---------------------------------------------------------------------
Key: JS1-183
Summary: nonexistent sequence error with oracle
Type: Bug
Status: Reopened
Project: Jetspeed
Components:
Database
Versions:
1.4b2-dev / CVS
Assignee: Jetspeed Developer Mailing List
Reporter: Christopher A. Petro
Created: Wed, 18 Dec 2002 11:48 PM
Updated: Tue, 20 Jul 2004 8:41 PM
Environment: Operating System: Other
Platform: All
Description:
I have checked out the latest jetspeed from cvs. The oracle schema and
population scripts ran fine, and I checked to make sure that all of the
database objects were created correctly. I selected from the sequences myself
to make sure they're working. When adding a new user, however, I get the
exception at the bottom of this description. Basically, it's selecting from
some non-existent sequence. I spent over an hour digging around the jetspeed
and torque code and was unable to even figure out where the sequence name was
being generated. The latest torque code depends on a jar that maven can't
find, so I wasn't able to test whether it was a problem in torque or jetspeed.
The torque configuration is right out of the installation docs and the oracle
jdbc drivers are being used, so I believe that that is all correct. I checked
Torque bugzilla and didn't see any related bugs reported for 3.0, so I'm
guessing this is a problem in jetspeed. Hopefully I'm not wasting anyone's
time.
java.sql.SQLException: ORA-02289: sequence does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe
(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery
(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:2672)
at oracle.jdbc.driver.OracleStatement.executeQuery
(OracleStatement.java:572)
at com.workingdogs.village.QueryDataSet.(Unknown Source)
at org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue
(SequenceIdGenerator.java:195)
at org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal
(SequenceIdGenerator.java:132)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
(BaseTurbineUserPeer.java:242)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
(BaseTurbineUserPeer.java:215)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser
(TurbineUserManagement.java:309)
at org.apache.jetspeed.services.JetspeedUserManagement.addUser
(JetspeedUserManagement.java:134)
at org.apache.jetspeed.services.JetspeedSecurity.addUser
(JetspeedSecurity.java:238)
at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform
(CreateNewUserAndConfirm.java:206)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.modules.pages.DefaultPage.doBuild
(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:563)
at org.apache.turbine.Turbine.doPost(Turbine.java:658)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.authenticator.SingleSignOn.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.coyote.tomcat4.CoyoteAdapter.service
(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:405)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio
n(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt
(PoolTcpEndpoint.java:508)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:533)
at java.lang.Thread.run(Thread.java:536)
java.sql.SQLException: ORA-02289: sequence does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe
(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery
(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:2672)
at oracle.jdbc.driver.OracleStatement.executeQuery
(OracleStatement.java:572)
at com.workingdogs.village.QueryDataSet.(Unknown Source)
at org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue
(SequenceIdGenerator.java:195)
at org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal
(SequenceIdGenerator.java:132)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
(BaseTurbineUserPeer.java:242)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
(BaseTurbineUserPeer.java:215)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser
(TurbineUserManagement.java:309)
at org.apache.jetspeed.services.JetspeedUserManagement.addUser
(JetspeedUserManagement.java:134)
at org.apache.jetspeed.services.JetspeedSecurity.addUser
(JetspeedSecurity.java:238)
at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform
(CreateNewUserAndConfirm.java:206)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.modules.pages.DefaultPage.doBuild
(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:563)
at org.apache.turbine.Turbine.doPost(Turbine.java:658)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.authenticator.SingleSignOn.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
t(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.coyote.tomcat4.CoyoteAdapter.service
(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:405)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio
n(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt
(PoolTcpEndpoint.java:508)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:533)
at java.lang.Thread.run(Thread.java:536)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org