portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dave.nor...@ihs.com
Subject Re: [jira] Commented: (JS1-509) org.apache.jetspeed.services.security.UserException: Failed to create account 'Dave': ORA-02289: sequence does not exist
Date Wed, 11 Aug 2004 14:32:28 GMT





Dear jetspeed-dev@jakarta.apache.org,

I believe I have followed the instructions and am still getting the error
detailed below.

1. I download the 1.5 source zip and expand it.
2. I run the oracle sql scripts to create and populate oracle database
tables.
3. I alter the tutorial's project.xml (See Below).
4. I alter the Torque.properties.merge file from the first tutorial's src
path to reflect the desired oracle mappings (See Below).
5. I use Maven 1.0 to build the first tutorial and generate jportal.jar.
[c:\maven_1.0\bin\maven -Dtutorial=1 jetspeed:deploy]  I use j2sdk 1.4.1
_02.
6. I look in the resulting jportal.war and open the Torque.properites file.
The desired mappings have taken precedence.
7. I move the jportal.jar to the JBOSS 3.2.3 deploy path and start JBOSS.
The portal runs and accesses oracle.
8. I make a change to an oracle tutorial table (Coffees) and restart.  The
change shows on the portal.
9. I try to create a new user account and get the error (See Bottom).

Thanks, in advance,

Dave Nordin
Engineer, IHS


project.properties:

# Copyright 2004 The Apache Software Foundation
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

maven.repo.remote = http://www.bluesunrise.com/maven/,
http://www.ibiblio.org/maven/

maven.xdoc.date=left
maven.xdoc.version=
maven.xdoc.includeProjectDocumentation=no
maven.xdoc.poweredby.image=
maven.xdoc.poweredby.title=
maven.xdoc.poweredby.url=
maven.xdoc.date = left

maven.jetspeed.vanilla.war = ${basedir}/../target/jetspeed.war

# -------------------------------------------------------------------
#
#  Torque Preferences
#
# -------------------------------------------------------------------
schemaDirectory = ${maven.src.dir}/schema
torque.useClasspath = true
torque.basePrefix = Base
torque.addSaveMethod = true
torque.addGetByNameMethod = true
torque.complexObjectModel = true
torque.addTimeStamp = true
torque.addIntakeRetrievable = false
torque.saveException = Exception

project = tutorial
database = oracle
targetPackage = org.apache.jetspeed.om.torque
#torque.retrievableInterface = org.apache.fulcrum.intake.Retrievable
torque.database.url = jdbc:hsqldb:hsql://localhost
torque.database.driver = org.hsqldb.jdbcDriver
torque.database.user = sa
torque.database.password =

# -------------------------------------------------------------------
#
#  Jetspeed Plugin Preferences
#
# -------------------------------------------------------------------
war.src = ${basedir}/src/webapp
war.stage.dir = ${basedir}/stage
maven.war.src = ${war.stage.dir}/webapp

maven.merge.properties =
JetspeedResources,JetspeedSecurity,TurbineResources,Torque
maven.war.appserver.home = /bluesunrise/apache/catalina

jetspeed.dist.version = 1.5


Torque.properties.merge

# Copyright 2004 The Apache Software Foundation
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

### torque.database.default=default
torque.database.default.adapter=oracle
### Oracle
torque.dsfactory.default.connection.driver =
oracle.jdbc.driver.OracleDriver
torque.dsfactory.default.connection.url =
jdbc:oracle:thin:@testdb2.ihs.com:1522:LMGRDEV
torque.dsfactory.default.connection.user = DNORDIN
torque.dsfactory.default.connection.password = dnordin1


>From jetpeed.log:

2004-08-11 08:10:21,166 [TP-Processor2] DEBUG JetspeedTemplatePage -
JetspeedTemplatePage: Setting type to: text/html; charset=iso-8859-1
2004-08-11 08:10:21,213 [TP-Processor2] ERROR CreateNewUserAndConfirm -
CreateNewUserAndConfirm
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.<init>(Unknown Source)
      at
org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue(SequenceIdGenerator.java:199)
      at
org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal(SequenceIdGenerator.java:133)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:720)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639)
      at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:241)
      at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:214)
      at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:283)
      at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:95)
      at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
      at
org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:171)
      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:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:536)
rethrown as org.apache.torque.TorqueException: ORA-02289: sequence does not
exist
      at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:730)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639)
      at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:241)
      at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:214)
      at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:283)
      at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:95)
      at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
      at
org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:171)
      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:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
rethrown as
org.apache.jetspeed.services.security.UserException: Failed to create
account 'dnordin': ORA-02289: sequence does not exist
      at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:292)
      at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:95)
      at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
      at
org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:171)
      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:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      at java.lang.Thread.run(Thread.java:536)
2004-08-11 08:10:21,260 [TP-Processor2] DEBUG JetspeedTemplatePage -
JetspeedTemplatePage: requested template = ShowError.vm





                                                                           
             jetspeed-dev@jaka                                             
             rta.apache.org                                                
                                                                        To 
             08/05/2004 12:19          dave.nordin@ihs.com                 
             PM                                                         cc 
                                                                           
                                                                   Subject 
                                       [jira] Commented: (JS1-509)         
                                       org.apache.jetspeed.services.securi 
                                       ty.UserException: Failed to create  
                                       account 'Dave': ORA-02289: sequence 
                                       does not exist                      
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




The following comment has been added to this issue:

     Author: David Sean Taylor
    Created: Thu, 5 Aug 2004 11:18 AM
       Body:
Did you follow the 2 steps found here:

http://portals.apache.org/jetspeed-1/database.html


before building?


I've seen this happen before because the Torque bindings are generated to
bind to HSQL-style sequence generation, not Oracle.
---------------------------------------------------------------------
View this comment:
  http://issues.apache.org/jira/browse/JS1-509?page=comments#action_37068

---------------------------------------------------------------------
View the issue:
  http://issues.apache.org/jira/browse/JS1-509

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: JS1-509
    Summary: org.apache.jetspeed.services.security.UserException: Failed to
create account 'Dave': ORA-02289: sequence does not exist
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Jetspeed

   Assignee:
   Reporter: Dave Nordin

    Created: Thu, 5 Aug 2004 8:43 AM
    Updated: Thu, 5 Aug 2004 11:18 AM
Environment: Win 2000; Jetspeed 1.5; JBOSS 3.2.3; Oracle 9.1; Built with
Maven 2.0

Description:
After building the Jetspeed tutorial from source (1.5), I can get
connected to oracle.  I can alter data in the tutorial (coffee) database
table (now in oracle) and the changes show up.  If I try t create a new
jetspeed account, I get the following error:

org.apache.jetspeed.services.security.UserException: Failed to create
account 'Dave': ORA-02289: sequence does not exist

I can see that others have had this problem, but have yet to get an
explanation that works for me.  Below are my torque.properties settings.

torque.database.default.adapter=oracle

torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory

torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
### Oracle
torque.dsfactory.default.connection.driver =
oracle.jdbc.driver.OracleDriver
torque.dsfactory.default.connection.url =
jdbc:oracle:thin:@global120.ihs.com:1625:PPVDEV
torque.dsfactory.default.connection.user = PPVX
torque.dsfactory.default.connection.password = Pay4


Thanks, Dave

Dave Nordin
Engineer IHS



---------------------------------------------------------------------
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


Mime
View raw message