Ok I followed your instructions on the wiki. I still can't seem to get it running. My Torque.properties looks like this:
torque.database.default=default torque.database.default.adapter=db2app torque.database.default.adapter=db2400 ##torque.dsfactory.default.connection.driver = com.ibm.as400.access.AS400JDBCDriver torque.dsfactory.default.connection.driver = com.p6spy.engine.spy.P6SpyDriver torque.dsfactory.default.connection.url = jdbc:as400://<serverip>;libraries=LWPSML torque.dsfactory.default.connection.user = username torque.dsfactory.default.connection.password = password torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory Still getting a null pointer, further examination of the jetspeed.log file shows that there's "No Datasource Configured for connection default". ______________________ Shawn Haworth LWSI/WebDev Programmer 501.558.4619 401.744.5337 Siegfried Goeschl <[EMAIL PROTECTED]> 03/22/2006 08:32 AM Please respond to "Turbine Users List" <[email protected]> To Turbine Users List <[email protected]> cc Subject Re: SQL Query Logging / Debugging Hi Shawn, currently I work on non-Turbine application but I got P6Spy running with +) Turbine/Tomcat +) BEA WebLogic with EJBs +) my current contracting job based on RESIN with a custom connection pool The following link might help in Turbine land http://wiki.apache.org/db-torque/FrequentlyAskedQuestions#head-46f663e01bea72682fdc5f60ae02f2a47de29fec Cheers, Siegfried Goeschl [EMAIL PROTECTED] wrote: > Great, thanks for the idea. I'm trying to configure this for Tomcat 5, > unfortunately their instructions on the site are outdated (version 3.x). > Which webserver are you using? > > > ______________________ > Shawn Haworth > LWSI/WebDev Programmer > 501.558.4619 401.744.5337 > > > > Siegfried Goeschl <[EMAIL PROTECTED]> > 03/22/2006 06:20 AM > Please respond to > "Turbine Users List" <[email protected]> > > > To > Turbine Users List <[email protected]> > cc > > Subject > Re: SQL Query Logging / Debugging > > > > > > > Hi Shawn, > > I use a different approach using (in a different context) > > +) P6Spy as JDBC proxy driver > +) Log4J to write the P6SPY logs to a SocketAppender > +) SQLProfiler (http://www.jahia.net/jahia/page597.html) which visualize > the JDBC access > > This week it helped me to trace an escaping problem related to the JDBC > driver internals ... :-) > > Cheers, > > Siegfried Goeschl > > [EMAIL PROTECTED] wrote: > >>Hi all, >> >> I'm trying to facilitate the SQL queries called by Jetspeed. In > > >>the TRP, I setup log4j to do so.. but I still don't see the queries or >>errors. I know I'm getting an error because I get an SQL exception when > > >>logging in (i'm using the DB2/400 as a test database). >> >>Here's my entry in TRP: >> >> > > services.LoggingService.system.destination.file=/WEB-INF/log/jetspeed.log > > services.LoggingService.system.className=org.apache.turbine.services.logging.FileLogger > >>services.LoggingService.system.level=DEBUG >> >>>From what I've read this should be good enough to send the queries to >>jetspeed.log. Anyone else encounter this or know another approach? >> >> >>______________________ >>Shawn Haworth >>LWSI/WebDev Programmer > > > --------------------------------------------------------------------- > 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]
