Re: Upgrade 2.3.2 to 2.3.3
Juergen Hoffmann <[email protected]> Tue, 23 Feb 2010 11:36:12 +0100
| Newsgroups | gmane.comp.jakarta.turbine.user |
|---|---|
| Organization | Apache Software Foundation |
| Message-ID | <[email protected]> |
Hi Chris, did the error change with the new properties file? Kind regards Juergen Am 23.02.2010 10:42, schrieb Chris Jölly: > Hello Juergen, > > unfortunately this does not work. But I do not understand what this configuration should do. > A custom adapter requires a .adapter.className, isn't it? > > I followed the Torque 3.3 configuration how to and checked with the configuration that is > written by the maven goal which creates a Turbine application skeleton. > > However, I have no idea what is going wrong, as I am using Turbine since years for an > application, first with sapDB/MaxDB and since a year with OracleDB, but the upgrade to > 2.3.3 (because of Torque 3.3's possibility to use LEFT OUTER JOINS) seem to have the > framework completely destroyed. > > And there is no documentation on how to migrate existing 2.3.2 based applications to 2.3.3... > Upgrading Turbine in an Turbine based application was always a mess, but I was able to > manage it so far. But now it is in a state where I probably have to scan all source files > to figure out what needs to be done for the successful upgrade... :(( > > Thanks for your effort. > > Chris > > > >> -----Original Message----- >> From: Juergen Hoffmann [mailto:[email protected]] >> Sent: Dienstag, 23. Februar 2010 09:06 >> To: Turbine Users List >> Subject: Re: Upgrade 2.3.2 to 2.3.3 >> >> Hi Chris, >> >> try this as your Torque.properties: >> >> torque.applicationRoot = . >> >> torque.database.default=portaldb >> torque.database.default.adapter=oracle >> torque.database.portaldb.adapter=portaldb >> >> torque.dsfactory.portaldb.factory=org.apache.torque.dsfactory.SharedPoo >> lDataSourceFactory >> torque.dsfactory.portaldb.pool.maxActive=10 >> torque.dsfactory.portaldb.pool.testOnBorrow=true >> torque.dsfactory.portaldb.pool.validationQuery=SELECT 1 >> torque.dsfactory.portaldb.connection.driver >> =oracle.jdbc.driver.OracleDriver >> torque.dsfactory.portaldb.connection.url = jdbc:oracle:thin:@dev- >> srv:1521:DB >> torque.dsfactory.portaldb.connection.user = user >> torque.dsfactory.portaldb.connection.password = pwd >> >> torque.dsfactory.default.factory=org.apache.torque.dsfactory.SharedPool >> DataSourceFactory >> torque.dsfactory.default.pool.maxActive=10 >> torque.dsfactory.default.pool.testOnBorrow=true >> torque.dsfactory.default.pool.validationQuery=SELECT 1 >> torque.dsfactory.default.connection.driver >> =oracle.jdbc.driver.OracleDriver >> torque.dsfactory.default.connection.url = jdbc:oracle:thin:@dev- >> srv:1521:DB >> torque.dsfactory.default.connection.user = user >> torque.dsfactory.default.connection.password = pwd >> >> torque.idbroker.cleverquantity=true >> >> >> let me know if it worked >> >> Kind regards >> >> Juergen Hoffmann >> >> Am 22.02.2010 17:00, schrieb Chris Jölly: >> >>> Hello, >>> >>> sorry for the late reply, but i tried to fix the migration issues for >>> >> myself, >> >>> but it seems that this task is more complex than I have thought... >>> >>> I added the used configuration files and the problem I face now with >>> >> Torque >> >>> Security. We are using an Oracle database and it seems that the >>> >> idBroker has >> >>> Troubles reading meta data from the database: >>> >>> 2010-02-22 15:41:02,783 INFO >>> >> org.apache.turbine.services.BaseServiceBroker - Start Initializing >> service (late): SecurityService >> >>> 2010-02-22 15:41:02,799 DEBUG org.apache.torque.TorqueInstance - >>> >> getConfiguration() = >> org.apache.commons.configuration.SubsetConfiguration@13cae57 >> >>> 2010-02-22 15:41:02,924 ERROR org.apache.torque.oid.IDBroker - Could >>> >> not open a connection to the database default >> >>> org.apache.torque.TorqueException: >>> >> org.apache.commons.dbcp.SQLNestedException: Could not retrieve >> connection info from pool >> >>> at >>> >> org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:919) >> >>> at org.apache.torque.Torque.getConnection(Torque.java:314) >>> at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:237) >>> at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:203) >>> at >>> >> org.apache.torque.map.DatabaseMap.startIdBroker(DatabaseMap.java:351) >> >>> at >>> >> org.apache.torque.map.TableMap.setPrimaryKeyMethod(TableMap.java:584) >> >>> at >>> >> org.apache.turbine.services.security.torque.om.map.TurbineGroupMapBuild >> er.doBuild(TurbineGroupMapBuilder.java:71) >> >>> at >>> >> org.apache.torque.TorqueInstance.getMapBuilder(TorqueInstance.java:862) >> >>> at org.apache.torque.Torque.getMapBuilder(Torque.java:287) >>> at >>> >> org.apache.turbine.services.security.torque.om.BaseTurbineGroupPeer.<cl >> init>(BaseTurbineGroupPeer.java:84) >> >>> at java.lang.Class.forName0(Native Method) >>> at java.lang.Class.forName(Class.java:169) >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManagerConstants$1 >> .class$(GroupPeerManagerConstants.java:59) >> >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManagerConstants.< >> clinit>(GroupPeerManagerConstants.java:58) >> >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManager.init(Group >> PeerManager.java:92) >> >>> at >>> >> org.apache.turbine.services.security.torque.TorqueSecurityService.init( >> TorqueSecurityService.java:81) >> >>> at >>> >> org.apache.turbine.services.BaseServiceBroker.getService(BaseServiceBro >> ker.java:457) >> >>> at >>> >> org.apache.turbine.services.security.TurbineSecurity.getService(Turbine >> Security.java:69) >> >>> at >>> >> org.apache.turbine.services.security.TurbineSecurity.getAnonymousUser(T >> urbineSecurity.java:337) >> >>> at >>> >> org.apache.turbine.modules.actions.sessionvalidator.TemplateSessionVali >> dator.doPerform(TemplateSessionValidator.java:80) >> >>> at org.apache.turbine.modules.Action.perform(Action.java:51) >>> at >>> >> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:102) >> >>> at org.apache.turbine.Turbine.doGet(Turbine.java:751) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >> ationFilterChain.java:252) >> >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >> terChain.java:173) >> >>> at >>> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal >> ve.java:213) >> >>> at >>> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal >> ve.java:178) >> >>> at >>> >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato >> rBase.java:432) >> >>> at >>> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav >> a:126) >> >>> at >>> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav >> a:105) >> >>> at >>> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve >> .java:107) >> >>> at >>> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: >> 148) >> >>> at >>> >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:8 >> 69) >> >>> at >>> >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.pro >> cessConnection(Http11BaseProtocol.java:664) >> >>> at >>> >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoin >> t.java:527) >> >>> at >>> >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollo >> werWorkerThread.java:80) >> >>> at >>> >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo >> l.java:684) >> >>> at java.lang.Thread.run(Thread.java:619) >>> Caused by: org.apache.commons.dbcp.SQLNestedException: Could not >>> >> retrieve connection info from pool >> >>> at >>> >> org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConne >> ctionAndInfo(SharedPoolDataSource.java:171) >> >>> at >>> >> org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection >> (InstanceKeyDataSource.java:669) >> >>> at >>> >> org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection >> (InstanceKeyDataSource.java:653) >> >>> at >>> >> org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:912) >> >>> ... 39 more >>> Caused by: java.util.NoSuchElementException: Could not create a >>> >> validated object >> >>> at >>> >> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Generi >> cKeyedObjectPool.java:1049) >> >>> at >>> >> org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConne >> ctionAndInfo(SharedPoolDataSource.java:167) >> >>> ... 42 more >>> 2010-02-22 15:41:02,924 WARN org.apache.torque.oid.IDBroker - Could >>> >> not read from connection Metadata whether transactions are supported >> for the database default >> >>> java.lang.NullPointerException >>> at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:248) >>> at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:203) >>> at >>> >> org.apache.torque.map.DatabaseMap.startIdBroker(DatabaseMap.java:351) >> >>> at >>> >> org.apache.torque.map.TableMap.setPrimaryKeyMethod(TableMap.java:584) >> >>> at >>> >> org.apache.turbine.services.security.torque.om.map.TurbineGroupMapBuild >> er.doBuild(TurbineGroupMapBuilder.java:71) >> >>> at >>> >> org.apache.torque.TorqueInstance.getMapBuilder(TorqueInstance.java:862) >> >>> at org.apache.torque.Torque.getMapBuilder(Torque.java:287) >>> at >>> >> org.apache.turbine.services.security.torque.om.BaseTurbineGroupPeer.<cl >> init>(BaseTurbineGroupPeer.java:84) >> >>> at java.lang.Class.forName0(Native Method) >>> at java.lang.Class.forName(Class.java:169) >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManagerConstants$1 >> .class$(GroupPeerManagerConstants.java:59) >> >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManagerConstants.< >> clinit>(GroupPeerManagerConstants.java:58) >> >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManager.init(Group >> PeerManager.java:92) >> >>> at >>> >> org.apache.turbine.services.security.torque.TorqueSecurityService.init( >> TorqueSecurityService.java:81) >> >>> at >>> >> org.apache.turbine.services.BaseServiceBroker.getService(BaseServiceBro >> ker.java:457) >> >>> at >>> >> org.apache.turbine.services.security.TurbineSecurity.getService(Turbine >> Security.java:69) >> >>> at >>> >> org.apache.turbine.services.security.TurbineSecurity.getAnonymousUser(T >> urbineSecurity.java:337) >> >>> at >>> >> org.apache.turbine.modules.actions.sessionvalidator.TemplateSessionVali >> dator.doPerform(TemplateSessionValidator.java:80) >> >>> at org.apache.turbine.modules.Action.perform(Action.java:51) >>> at >>> >> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:102) >> >>> at org.apache.turbine.Turbine.doGet(Turbine.java:751) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >> ationFilterChain.java:252) >> >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >> terChain.java:173) >> >>> at >>> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal >> ve.java:213) >> >>> at >>> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal >> ve.java:178) >> >>> at >>> >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato >> rBase.java:432) >> >>> at >>> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav >> a:126) >> >>> at >>> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav >> a:105) >> >>> at >>> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve >> .java:107) >> >>> at >>> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: >> 148) >> >>> at >>> >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:8 >> 69) >> >>> at >>> >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.pro >> cessConnection(Http11BaseProtocol.java:664) >> >>> at >>> >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoin >> t.java:527) >> >>> at >>> >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollo >> werWorkerThread.java:80) >> >>> at >>> >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo >> l.java:684) >> >>> at java.lang.Thread.run(Thread.java:619) >>> 2010-02-22 15:41:02,924 WARN org.apache.torque.oid.IDBroker - Could >>> >> not close the connection which was used for testing whether >> transactions are supported >> >>> java.lang.NullPointerException >>> at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:263) >>> at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:203) >>> at >>> >> org.apache.torque.map.DatabaseMap.startIdBroker(DatabaseMap.java:351) >> >>> at >>> >> org.apache.torque.map.TableMap.setPrimaryKeyMethod(TableMap.java:584) >> >>> at >>> >> org.apache.turbine.services.security.torque.om.map.TurbineGroupMapBuild >> er.doBuild(TurbineGroupMapBuilder.java:71) >> >>> at >>> >> org.apache.torque.TorqueInstance.getMapBuilder(TorqueInstance.java:862) >> >>> at org.apache.torque.Torque.getMapBuilder(Torque.java:287) >>> at >>> >> org.apache.turbine.services.security.torque.om.BaseTurbineGroupPeer.<cl >> init>(BaseTurbineGroupPeer.java:84) >> >>> at java.lang.Class.forName0(Native Method) >>> at java.lang.Class.forName(Class.java:169) >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManagerConstants$1 >> .class$(GroupPeerManagerConstants.java:59) >> >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManagerConstants.< >> clinit>(GroupPeerManagerConstants.java:58) >> >>> at >>> >> org.apache.turbine.services.security.torque.GroupPeerManager.init(Group >> PeerManager.java:92) >> >>> at >>> >> org.apache.turbine.services.security.torque.TorqueSecurityService.init( >> TorqueSecurityService.java:81) >> >>> at >>> >> org.apache.turbine.services.BaseServiceBroker.getService(BaseServiceBro >> ker.java:457) >> >>> at >>> >> org.apache.turbine.services.security.TurbineSecurity.getService(Turbine >> Security.java:69) >> >>> at >>> >> org.apache.turbine.services.security.TurbineSecurity.getAnonymousUser(T >> urbineSecurity.java:337) >> >>> at >>> >> org.apache.turbine.modules.actions.sessionvalidator.TemplateSessionVali >> dator.doPerform(TemplateSessionValidator.java:80) >> >>> at org.apache.turbine.modules.Action.perform(Action.java:51) >>> at >>> >> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:102) >> >>> at org.apache.turbine.Turbine.doGet(Turbine.java:751) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >> ationFilterChain.java:252) >> >>> at >>> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >> terChain.java:173) >> >>> at >>> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal >> ve.java:213) >> >>> at >>> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal >> ve.java:178) >> >>> at >>> >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato >> rBase.java:432) >> >>> at >>> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav >> a:126) >> >>> at >>> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav >> a:105) >> >>> at >>> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve >> .java:107) >> >>> at >>> >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: >> 148) >> >>> at >>> >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:8 >> 69) >> >>> at >>> >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.pro >> cessConnection(Http11BaseProtocol.java:664) >> >>> at >>> >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoin >> t.java:527) >> >>> at >>> >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollo >> werWorkerThread.java:80) >> >>> at >>> >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo >> l.java:684) >> >>> at java.lang.Thread.run(Thread.java:619) >>> 2010-02-22 15:41:02,924 WARN org.apache.torque.oid.IDBroker - >>> >> IDBroker is being used with db 'default', which does not support >> transactions. IDBroker attempts to use transactions to limit the >> possibility of duplicate key generation. Without transactions, >> duplicate key generation is possible if multiple JVMs are used or other >> means are used to write to the database. >> >>> 2010-02-22 15:41:03,002 INFO >>> >> org.apache.turbine.services.BaseServiceBroker - Finish Initializing >> service (late): SecurityService >> >>> TurbineResources.properties: >>> ---------------------------- >>> >>> >>> >> services.SecurityService.classname=org.apache.turbine.services.security >> .torque.TorqueSecurityService >> >>> services.SecurityService.user.manager = >>> >> org.apache.turbine.services.security.torque.TorqueUserManager >> >>> services.SecurityService.user.class = >>> >> org.apache.turbine.services.security.torque.TorqueUser >> >>> services.SecurityService.group.class = >>> >> org.apache.turbine.services.security.torque.TorqueGroup >> >>> services.SecurityService.permission.class = >>> >> org.apache.turbine.services.security.torque.TorquePermission >> >>> services.SecurityService.role.class = >>> >> org.apache.turbine.services.security.torque.TorqueRole >> >>> services.SecurityService.torque.userPeer.class = >>> >> com.unycom.aportal.om.common.TurbineUserPeer >> >>> services.SecurityService.torque.groupPeer.class = >>> >> com.unycom.aportal.om.common.TurbineGroupPeer >> >>> services.SecurityService.torque.permissionPeer.class = >>> >> com.unycom.aportal.om.common.TurbinePermissionPeer >> >>> services.SecurityService.torque.rolePeer.class = >>> >> com.unycom.aportal.om.common.TurbineRolePeer >> >>> services.AvalonComponentService.lookup = >>> >> org.apache.torque.avalon.Torque >> >>> services.SecurityService.acl.class = >>> >> org.apache.turbine.util.security.TurbineAccessControlList >> >>> services.SecurityService.secure.passwords=false >>> services.SecurityService.secure.passwords.algorithm=SHA >>> >>> Torque.properties: >>> ------------------ >>> >>> torque.database.default=portaldb >>> >>> # Connection to Oracle DB >>> torque.database.portaldb.adapter=oracle >>> torque.dsfactory.portaldb.connection.driver = >>> >> oracle.jdbc.driver.OracleDriver >> >>> torque.dsfactory.portaldb.connection.url = jdbc:oracle:thin:@dev- >>> >> srv:1521:DB >> >>> torque.dsfactory.portaldb.connection.user = user >>> torque.dsfactory.portaldb.connection.password = pwd >>> >>> >>> >> torque.dsfactory.portaldb.factory=org.apache.torque.dsfactory.SharedPoo >> lDataSourceFactory >> >>> torque.defaults.pool.maxActive = 30 >>> torque.defaults.pool.testOnBorrow = true >>> torque.defaults.pool.validationQuery = SELECT 1 >>> >>> torque.idbroker.clever.quantity=false >>> torque.idbroker.prefetch=false >>> torque.idbroker.usenewconnection = false >>> torque.manager.useCache = true >>> >>> componentConfiguration.xml: >>> --------------------------- >>> >>> <componentConfig> >>> <!-- Torque Component --> >>> <torque> >>> <configfile>/WEB-INF/conf/Torque.properties</configfile> >>> </torque> >>> </componentConfig> >>> >>> >>> >>> >>>> -----Original Message----- >>>> From: Thomas Vandahl [mailto:[email protected]] >>>> Sent: Samstag, 13. Februar 2010 17:16 >>>> To: Turbine Users List >>>> Subject: Re: Upgrade 2.3.2 to 2.3.3 >>>> >>>> Chris Jölly wrote: >>>> >>>> >>>>> 2010-02-09 09:38:23,361 ERROR >>>>> >>>>> >>>> org.apache.turbine.services.security.torque.UserPeerManager - Could >>>> not instantiate a new user from supplied persistent: >>>> >>>> >>>>> java.lang.NoSuchMethodException: >>>>> >>>>> >>>> >> org.apache.turbine.om.security.TurbineUser.<init>(org.apache.torque.om. >> >>>> Persistent) >>>> >>>> >>>>> at java.lang.Class.getConstructor0(Unknown Source) >>>>> at java.lang.Class.getConstructor(Unknown Source) >>>>> at >>>>> >>>>> >>>> >> org.apache.turbine.services.security.torque.UserPeerManager.getNewUser( >> >>>> UserPeerManager.java:1494) >>>> >>>> Please supply the section of your TurbineResources.properties that >>>> configures the security service. That error looks as if something >>>> >> has >> >>>> been broken before. >>>> >>>> Bye, Thomas. >>>> >>>> >>>> -------------------------------------------------------------------- >>>> >> - >> >>>> To unsubscribe, e-mail: [email protected] >>>> For additional commands, e-mail: [email protected] >>>> >>>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >