Created jira for this: https://wso2.org/jira/browse/JAGGERY-209 ( A blocker IMO)
Also, how can I set properties of the DB connection such as maxactive, minidle, timeouts? A minimum set of these should be supported by the API. Another question is how do I close the connection? I assume db.query() always opens and closes a DB connection. That is inefficient if I have a number of queries to run. On Tue, May 1, 2012 at 1:42 AM, Tharindu Mathew <[email protected]> wrote: > Hi, > > Can $subject be done? It reports that the driver is missing. I don't see > anything in the docs about setting driver class name. > > Note: I added the jdbc driver to repository/components/lib as well and > checked > > Stacktrace: > > [2012-05-01 01:31:36,865] ERROR > {org.wso2.carbon.scriptengine.engine.RhinoEngine} - > org.mozilla.javascript.WrappedException: Wrapped > org.wso2.carbon.scriptengine.exceptions.ScriptException: Error connecting > to the database : jdbc:mysql://localhost:3306/gadgetgen > (/gadgetgen/gadgetgen.jag#11) > [2012-05-01 01:31:36,865] ERROR > {org.wso2.carbon.jaggery.core.manager.WebAppManager} - > org.mozilla.javascript.WrappedException: Wrapped > org.wso2.carbon.scriptengine.exceptions.ScriptException: Error connecting > to the database : jdbc:mysql://localhost:3306/gadgetgen > (/gadgetgen/gadgetgen.jag#11) > org.wso2.carbon.scriptengine.exceptions.ScriptException: > org.mozilla.javascript.WrappedException: Wrapped > org.wso2.carbon.scriptengine.exceptions.ScriptException: Error connecting > to the database : jdbc:mysql://localhost:3306/gadgetgen > (/gadgetgen/gadgetgen.jag#11) > at > org.wso2.carbon.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:477) > at > org.wso2.carbon.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:231) > at > org.wso2.carbon.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:212) > at > org.wso2.carbon.jaggery.core.JaggeryServlet.doGet(JaggeryServlet.java:42) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) > at > org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:109) > at > org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:155) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999) > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565) > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1620) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:680) > Caused by: org.mozilla.javascript.WrappedException: Wrapped > org.wso2.carbon.scriptengine.exceptions.ScriptException: Error connecting > to the database : jdbc:mysql://localhost:3306/gadgetgen > (/gadgetgen/gadgetgen.jag#11) > at > org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1654) > at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:175) > at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:417) > at org.mozilla.javascript.BaseFunction.construct(BaseFunction.java:328) > at > org.mozilla.javascript.ScriptRuntime.newObject(ScriptRuntime.java:2266) > at org.wso2.carbon.rhino.c4._c0(/gadgetgen/gadgetgen.jag:11) > at org.wso2.carbon.rhino.c4.call(/gadgetgen/gadgetgen.jag) > at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) > at > org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) > at org.wso2.carbon.rhino.c4.call(/gadgetgen/gadgetgen.jag) > at org.wso2.carbon.rhino.c4.exec(/gadgetgen/gadgetgen.jag) > at > org.wso2.carbon.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:472) > ... 23 more > Caused by: org.wso2.carbon.scriptengine.exceptions.ScriptException: Error > connecting to the database : jdbc:mysql://localhost:3306/gadgetgen > at > org.wso2.carbon.hostobjects.db.DatabaseHostObject.jsConstructor(DatabaseHostObject.java:112) > 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:597) > at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:160) > ... 33 more > Caused by: java.sql.SQLException: No suitable driver found for > jdbc:mysql://localhost:3306/gadgetgen > at java.sql.DriverManager.getConnection(DriverManager.java:602) > at java.sql.DriverManager.getConnection(DriverManager.java:185) > at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181) > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) > at > org.wso2.carbon.hostobjects.db.DatabaseHostObject.jsConstructor(DatabaseHostObject.java:106) > ... 38 more > > -- > Regards, > > Tharindu > > blog: http://mackiemathew.com/ > M: +94777759908 > > -- Regards, Tharindu blog: http://mackiemathew.com/ M: +94777759908
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
