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.SharedPoolDataSourceFactory
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.SharedPoolDataSourceFactory
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.TurbineGroupMapBuilder.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.<clinit>(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(GroupPeerManager.java:92)
>   at org.apache.turbine.services.security.torque.TorqueSecurityService.init(TorqueSecurityService.java:81)
>   at org.apache.turbine.services.BaseServiceBroker.getService(BaseServiceBroker.java:457)
>   at org.apache.turbine.services.security.TurbineSecurity.getService(TurbineSecurity.java:69)
>   at org.apache.turbine.services.security.TurbineSecurity.getAnonymousUser(TurbineSecurity.java:337)
>   at org.apache.turbine.modules.actions.sessionvalidator.TemplateSessionValidator.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(ApplicationFilterChain.java:252)
>   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
>   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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:869)
>   at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>   at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.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.getPooledConnectionAndInfo(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(GenericKeyedObjectPool.java:1049)
>   at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(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.TurbineGroupMapBuilder.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.<clinit>(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(GroupPeerManager.java:92)
>   at org.apache.turbine.services.security.torque.TorqueSecurityService.init(TorqueSecurityService.java:81)
>   at org.apache.turbine.services.BaseServiceBroker.getService(BaseServiceBroker.java:457)
>   at org.apache.turbine.services.security.TurbineSecurity.getService(TurbineSecurity.java:69)
>   at org.apache.turbine.services.security.TurbineSecurity.getAnonymousUser(TurbineSecurity.java:337)
>   at org.apache.turbine.modules.actions.sessionvalidator.TemplateSessionValidator.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(ApplicationFilterChain.java:252)
>   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
>   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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:869)
>   at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>   at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.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.TurbineGroupMapBuilder.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.<clinit>(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(GroupPeerManager.java:92)
>   at org.apache.turbine.services.security.torque.TorqueSecurityService.init(TorqueSecurityService.java:81)
>   at org.apache.turbine.services.BaseServiceBroker.getService(BaseServiceBroker.java:457)
>   at org.apache.turbine.services.security.TurbineSecurity.getService(TurbineSecurity.java:69)
>   at org.apache.turbine.services.security.TurbineSecurity.getAnonymousUser(TurbineSecurity.java:337)
>   at org.apache.turbine.modules.actions.sessionvalidator.TemplateSessionValidator.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(ApplicationFilterChain.java:252)
>   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
>   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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:869)
>   at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>   at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.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.SharedPoolDataSourceFactory
>
> 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]
>
>