Getting JBossResourceException: Could not create connection;

[samatha]

Hi All,

I am getting "JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL".

I have implemented mysql Connection Properties Transform class. I have placed mysql connector jar and my implementation class jar in server/default/deploy/ (myapplication war )/web-inf/lib. I am getting above exception if i am connecting using jndi only once after restarting the server.
If connection is using jdbc, i am not getting any exception at all.

I am using jboss4.0..

Please let me know where i am doing wrong..

Here i am attaching exception...

2008-10-29 13:15:15,093 WARN [org.jboss.resource.connectionmanager.JBossManagedC onnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/es_test?propertiesTransform=com.jdbc.mysql.Connect ionPropertiesTransformImpl)
at org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.createManagedConnection(LocalMan agedConnectionFactory.java:190)
at org.jboss.resource.connectionmanager.InternalManag edConnectionPool.createConnectionEventListener(Int ernalManagedConnectionPool.java:619)
at org.jboss.resource.connectionmanager.InternalManag edConnectionPool.getConnection(InternalManagedConn ectionPool.java:264)
at org.jboss.resource.connectionmanager.JBossManagedC onnectionPool$BasePool.getConnection(JBossManagedC onnectionPool.java:575)
at org.jboss.resource.connectionmanager.BaseConnectio nManager2.getManagedConnection(BaseConnectionManag er2.java:347)
at org.jboss.resource.connectionmanager.TxConnectionM anager.getManagedConnection(TxConnectionManager.ja va:330)
at org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateConnection(BaseConnectionManager 2.java:402)
at org.jboss.resource.connectionmanager.BaseConnectio nManager2$ConnectionManagerProxy.allocateConnectio n(BaseConnectionManager2.java:849)
at org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(WrapperDataSource.java:89)
at org.pentaho.data.connection.sql.SQLConnection.init WithJNDI(SQLConnection.java:165)
at org.pentaho.data.connection.sql.SQLConnection.<ini t>(SQLConnection.java:93)
at org.pentaho.data.PentahoConnectionFactory.getConne ction(PentahoConnectionFactory.java:56)
at org.pentaho.plugin.sql.SQLBaseComponent.getConnect ion(SQLBaseComponent.java:829)
at org.pentaho.plugin.sql.SQLBaseComponent.getConnect ion(SQLBaseComponent.java:795)
at org.pentaho.plugin.sql.SQLBaseComponent.getDatasou rceConnection(SQLBaseComponent.java:746)
at org.pentaho.plugin.sql.SQLBaseComponent.executeAct ion(SQLBaseComponent.java:194)
at org.pentaho.plugin.ComponentBase.execute(Component Base.java:459)
at org.pentaho.core.runtime.RuntimeContext.executeCom ponent(RuntimeContext.java:1142)
at org.pentaho.core.runtime.RuntimeContext.executeAct ion(RuntimeContext.java:1114)
at org.pentaho.core.runtime.RuntimeContext.performAct ions(RuntimeContext.java:1026)
at org.pentaho.core.runtime.RuntimeContext.executeLoo p(RuntimeContext.java:981)
at org.pentaho.core.runtime.RuntimeContext.executeSeq uence(RuntimeContext.java:884)
at org.pentaho.core.runtime.RuntimeContext.executeSeq uence(RuntimeContext.java:780)
at org.pentaho.core.solution.SolutionEngine.executeIn ternal(SolutionEngine.java:333)
at org.pentaho.core.solution.SolutionEngine.execute(S olutionEngine.java:241)
at org.pentaho.core.solution.SolutionEngine.execute(S olutionEngine.java:169)
at org.pentaho.ui.component.charting.AbstractChartCom ponent.getActionData(AbstractChartComponent.java:1 67)
at org.pentaho.ui.component.charting.TimeSeriesCollec tionChartComponent.createChart(TimeSeriesCollectio nChartComponent.java:87)
at org.pentaho.ui.component.charting.TimeSeriesCollec tionChartComponent.getXmlContent(TimeSeriesCollect ionChartComponent.java:155)
at org.pentaho.ui.XmlComponent.getContent(XmlComponen t.java:46)
at org.pentaho.ui.ChartHelper.doChart(ChartHelper.jav a:279)
at org.apache.jsp.jsp.mdCoderOfficePerformanceReportD ashboard_jsp._jspService(mdCoderOfficePerformanceR eportDashboard_jsp.java:89)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:373)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:336)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInte rceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInte rceptor.doFilter(FilterSecurityInterceptor.java:72 )
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.do Filter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.switchuser.SwitchUserProcessi ngFilter.doFilter(SwitchUserProcessingFilter.java: 338)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at com.pentaho.security.SecurityStartupFilter.doFilte r(SecurityStartupFilter.java:76)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousPro cessingFilter.doFilter(AnonymousProcessingFilter.j ava:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessi ngFilter.doFilter(RememberMeProcessingFilter.java: 142)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at com.pentaho.security.RequestParameterAuthenticatio nFilter.doFilter(RequestParameterAuthenticationFil ter.java:164)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilt er.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFi lter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter( LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at com.pentaho.security.HttpSessionReuseDetectionFilt er.doFilter(HttpSessionReuseDetectionFilter.java:1 30)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegr ationFilter.doFilter(HttpSessionContextIntegration Filter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwa reRequestFilter.doFilter(SecurityContextHolderAwar eRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(F ilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter( FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.pentaho.core.system.SystemStatusFilter.doFilte r(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.pentaho.ui.servlet.SetCharacterEncodingFilter. doFilter(SetCharacterEncodingFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doF ilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationV alve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.inv oke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionV alve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run( JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/es_test?propertiesTransform=com.jdbc.mysql.Connect ionPropertiesTransformImpl
at org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.getDriver(LocalManagedConnection Factory.java:301)
at org.jboss.resource.adapter.jdbc.local.LocalManaged ConnectionFactory.createManagedConnection(LocalMan agedConnectionFactory.java:171)
... 93 more

Thanks in advance

[serjant]

Are you sure that com.mysql.jdbc.Driver is your driver?

[samatha]

Yes.. I am very much sure about that.. Same driver class i am using.. I dont know why it is not working after restarting server first time.. Second time onwards, connection is establishing..I dont know why it is not working for first time.

[serjant]

Is MySQL server running?

[samatha]

yes, it is running