great info. I've got the following mysql setup in torque.properties: torque.database.billing.adapter=mysql torque.dsfactory.billing.connection.driver=com.mysql.jdbc.Driver torque.dsfactory.billing.connection.url=jdbc:mysql://localhost:3306/test torque.dsfactory.billing.connection.user=user1 torque.dsfactory.billing.connection.password=pass1
# torque.dsfactory.billing.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory torque.dsfactory.billing.pool.defaultMaxConnections=10 torque.dsfactory.billing.pool.maxExpiryTime=3600 torque.dsfactory.billing.pool.connectionWaitTimeout=10 and I see the following in my browser when I hit http://localhost:8080/jetspeed. I've placed the mysql JDBC driver in the WEB-INF/lib directory and re-warred/redeployed everything. This error occurs whether I specify the user/pwd as properties or if I change the DB URL to pass them via that mechanism. I'm using the mysql-connector-java-2.0.14-bin.jar driver for JDBC access to MySQL. Any ideas or pointers to the torque.dsfactory.* property syntax? I couldn't find these on the Torque project reference page(s). thanks Horrible Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Connection object is null! at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTurbineUserPeer.java:130) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTurbineUserPeer.java:109) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:164) at org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserManagement.java:98) at org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnonymousUser(TurbineAuthentication.java:184) at org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:107) at org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:157) at org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:97) at org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:103) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.Turbine.doGet(Turbine.java:468) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:427) at org.apache.jsp.index_jsp._jspService(index_jsp.java:42) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533) at java.lang.Thread.run(Thread.java:536) On Tue, 2002-11-19 at 11:36, David Sean Taylor wrote: > > > > -----Original Message----- > > From: Eric White [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 19, 2002 6:36 AM > > To: [EMAIL PROTECTED] > > Subject: accessing mysql from a dbbrowser portlet > > > > > > I don't want to replace hypersonic as the user/group/role db under > > Jetspeed, I just want to access a mysql db from a dbbrowser portlet (one > > that I'd write or hijack from the demos/examples). > > > > But, I'm looking for the special sauce recipe of tasks I'm supposed to > > perform. Can somebody point me to the right sequence of URLs. > > > > I understand torque.properties fits in here somewhere but, after > > reviewing the last few month's of mailing list posts, it appears that I > > have to generate some files for torque/turbine to consume as part of the > > object-to-relational mapping stage. > > > The dbbrowserportlet works generically on a database using > java.sql.ResultSetMetaData, so it doesn't make use of torque at all except > for the connection. > > Here is one way to configure a second database connection pool in the > Torque.properties. It is named 'ender': > > torque.database.ender.adapter=oracle > torque.dsfactory.ender.connection.driver = oracle.jdbc.driver.OracleDriver > torque.dsfactory.ender.connection.url = > jdbc:oracle:thin:@yourSid:1521:yourSchema > torque.dsfactory.ender.connection.user = jetspeed > torque.dsfactory.ender.connection.password = password > torque.dsfactory.ender.factory=org.apache.torque.dsfactory.TorqueDataSourceF > actory > torque.dsfactory.ender.pool.defaultMaxConnections=10 > torque.dsfactory.ender.pool.maxExpiryTime=3600 > torque.dsfactory.ender.pool.connectionWaitTimeout=10 > > To use this connection pool in the DatabaseBrowserPortlet, specify it by > name: > > <!-- to use an alternate torque pool, set this parameter --> > <parameter name="poolname" value="ender" hidden="false"/> > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
