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
|