Results 1 to 5 of 5
  1. #1
    samatha is offline Member
    Join Date
    Oct 2008
    Posts
    4
    Rep Power
    0

    Default Getting JBossResourceException: Could not create connection;

    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

  2. #2
    serjant's Avatar
    serjant is offline Senior Member
    Join Date
    Jun 2008
    Location
    Ukraine,Zaporozhye
    Posts
    487
    Rep Power
    7

    Default

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

  3. #3
    samatha is offline Member
    Join Date
    Oct 2008
    Posts
    4
    Rep Power
    0

    Default

    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.

  4. #4
    serjant's Avatar
    serjant is offline Senior Member
    Join Date
    Jun 2008
    Location
    Ukraine,Zaporozhye
    Posts
    487
    Rep Power
    7

    Default

    Is MySQL server running?

  5. #5
    samatha is offline Member
    Join Date
    Oct 2008
    Posts
    4
    Rep Power
    0

Similar Threads

  1. Unable to get connection
    By chennee72 in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 09-24-2008, 03:33 AM
  2. connection problem
    By subash in forum JDBC
    Replies: 5
    Last Post: 04-22-2008, 10:17 AM
  3. no connection
    By even in forum JDBC
    Replies: 15
    Last Post: 01-02-2008, 02:50 PM
  4. connection pool for db2
    By paty in forum JDBC
    Replies: 1
    Last Post: 08-06-2007, 03:43 AM
  5. error I/O connection
    By bbq in forum JDBC
    Replies: 1
    Last Post: 07-05-2007, 02:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •