Re: Upgrade 2.3.2 to 2.3.3

Tue, 23 Feb 2010 02:36:43 -0800 

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]

Reply via email to