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.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.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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
