-----Original Message-----
From: Juergen Hoffmann [mailto:[email protected]]
Sent: Dienstag, 23. Februar 2010 11:36
To: Turbine Users List
Subject: Re: Upgrade 2.3.2 to 2.3.3
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.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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]