I did make that change - thanks, and I am using the ojdbc14.jar, but
still can't get it to work.

I got a capture of the stacktrace and did notice that I'm getting:
"There was no DataSourceFactory configured for the connection
SAMPLEAPP"

So I tried to configure as many of the torque.dsfactory properties that
I knew with no luck.

Here is the trace for what it's worth:

      java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at
org.apache.turbine.services.security.torque.UserPeerManager.doSelect(UserPeerManager.java:765)
        at
org.apache.turbine.services.security.torque.TorqueUserManager.retrieve(TorqueUserManager.java:184)
        at
org.apache.turbine.services.security.torque.TorqueUserManager.retrieve(TorqueUserManager.java:284)
        at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:729)
        at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:301)
        at
org.apache.turbine.app.sampleapp.modules.actions.LoginUser.doPerform(LoginUser.java:41)
        at
org.apache.turbine.modules.actions.VelocityAction.doPerform(VelocityAction.java:84)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionEvent.java:120)
        at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.java:110)
        at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:134)
        at org.apache.turbine.Turbine.loginAction(Turbine.java:909)
        at org.apache.turbine.Turbine.doGet(Turbine.java:733)
        at org.apache.turbine.Turbine.doPost(Turbine.java:891)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
        at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
        at java.lang.Thread.run(Thread.java:534)
Caused by: org.apache.torque.TorqueException: There was no
DataSourceFactory configured for the connection SAMPLEAPP
        at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1374)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:406)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:374)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelect(BaseTurbineUserPeer.java:343)
        ... 43 more
Caused by: java.lang.NullPointerException: There was no
DataSourceFactory configured for the connection SAMPLEAPP
        at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:749)
        at org.apache.torque.Torque.getConnection(Torque.java:306)
        at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365)
        ... 46 more
rethrown as org.apache.torque.TorqueException: doSelect failed
        at
org.apache.turbine.services.security.torque.UserPeerManager.doSelect(UserPeerManager.java:771)
        at
org.apache.turbine.services.security.torque.TorqueUserManager.retrieve(TorqueUserManager.java:184)
        at
org.apache.turbine.services.security.torque.TorqueUserManager.retrieve(TorqueUserManager.java:284)
        at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:729)
        at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:301)
        at
org.apache.turbine.app.sampleapp.modules.actions.LoginUser.doPerform(LoginUser.java:41)
        at
org.apache.turbine.modules.actions.VelocityAction.doPerform(VelocityAction.java:84)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionEvent.java:120)
        at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.java:110)
        at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:134)
        at org.apache.turbine.Turbine.loginAction(Turbine.java:909)
        at org.apache.turbine.Turbine.doGet(Turbine.java:733)
        at org.apache.turbine.Turbine.doPost(Turbine.java:891)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
        at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
        at java.lang.Thread.run(Thread.java:534)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at
org.apache.turbine.services.security.torque.UserPeerManager.doSelect(UserPeerManager.java:765)
        ... 38 more
Caused by: org.apache.torque.TorqueException: There was no
DataSourceFactory configured for the connection SAMPLEAPP
        at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1374)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:406)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:374)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelect(BaseTurbineUserPeer.java:343)
        ... 43 more
Caused by: java.lang.NullPointerException: There was no
DataSourceFactory configured for the connection SAMPLEAPP
        at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:749)
        at org.apache.torque.Torque.getConnection(Torque.java:306)
        at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365)
        ... 46 more
rethrown as org.apache.turbine.util.security.DataBackendException:
Failed to retrieve user 'admin': doSelect failed
        at
org.apache.turbine.services.security.torque.TorqueUserManager.retrieve(TorqueUserManager.java:188)
        at
org.apache.turbine.services.security.torque.TorqueUserManager.retrieve(TorqueUserManager.java:284)
        at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:729)
        at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:301)
        at
org.apache.turbine.app.sampleapp.modules.actions.LoginUser.doPerform(LoginUser.java:41)
        at
org.apache.turbine.modules.actions.VelocityAction.doPerform(VelocityAction.java:84)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionEvent.java:120)
        at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.java:110)
        at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:134)
        at org.apache.turbine.Turbine.loginAction(Turbine.java:909)
        at org.apache.turbine.Turbine.doGet(Turbine.java:733)
        at org.apache.turbine.Turbine.doPost(Turbine.java:891)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
        at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
        at java.lang.Thread.run(Thread.java:534)
Caused by: org.apache.torque.TorqueException: doSelect failed
        at
org.apache.turbine.services.security.torque.UserPeerManager.doSelect(UserPeerManager.java:771)
        at
org.apache.turbine.services.security.torque.TorqueUserManager.retrieve(TorqueUserManager.java:184)
        ... 37 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at
org.apache.turbine.services.security.torque.UserPeerManager.doSelect(UserPeerManager.java:765)
        ... 38 more
Caused by: org.apache.torque.TorqueException: There was no
DataSourceFactory configured for the connection SAMPLEAPP
        at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1374)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:406)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:374)
        at
org.apache.turbine.app.sampleapp.om.BaseTurbineUserPeer.doSelect(BaseTurbineUserPeer.java:343)
        ... 43 more
Caused by: java.lang.NullPointerException: There was no
DataSourceFactory configured for the connection SAMPLEAPP
        at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:749)
        at org.apache.torque.Torque.getConnection(Torque.java:306)
        at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365)
        ... 46 more

>>> [EMAIL PROTECTED] 9/23/2004 12:26:37 PM >>>
Sorry to post again - almost forgot - make sure you change your
torque.properties so that the following property is replaced with:

torque.defaults.pool.validationQuery = SELECT 1 FROM DUAL

(instead of "SELECT 1")


Also, I happen to use the ojdbc14.jar version of Oracle's drivers -
don't
know if it makes a bit of difference, but something to maybe try...


Bradford A. Folkens
[EMAIL PROTECTED] 
 
 

> -----Original Message-----
> From: John Harris [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, September 23, 2004 1:20 PM
> To: [EMAIL PROTECTED] 
> Subject: DataBackendException and Oracle 8i
> 
> I'm trying to learn Turbine 2.3 and am using the default 
> skeleton built by doing "maven -Dturbine.app.name=sample 
> turbine:setup" - with the build.properties file appropriately 
> configured.
> 
> 1. I use the default config files, tweaking the database 
> params as needed.
> 2. The oracle database already exists, so I use the 
> torque:jdbc target to generate my sample-schema.xml file 3. 
> Next I generate and insert the sql files into the db - so 
> that TURBINE_USER, etc are created within my schema 4. I 
> created a test Login.vm to authenticate against the 
> TURBINE_USER table 5. I then compile (java:compile) and 
> deploy (turbine:deploy) 6. Verify classes12.jar is in place - 
> Oracle's jdbc driver
> 
> I keep getting the error
> "org.apache.turbine.util.security.DataBackendException: 
> Failed to retrieve user 'admin': doSelect failed". I'm not 
> sure what I'm doing wrong - I can't find anything in the 
> archives. I'm using the antelope sample app as a guide, but 
> instead of using their Fulcrum Security Service - I'm just 
> trying to use the one already configured out of the box.
> 
> Thanks,
> 
> John
> 
>
---------------------------------------------------------------------
> 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