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.subsetconfigurat...@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]
