Databases
StackOverflow2013
Postsdbo
POInvalid Jboss Datasources after redeploy
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInvalid Jboss Datasources after redeploy
    primarykey
    data
    text
    <p>I'm developing an application tha uses seven datasources (ds) for MySql databases. I'm pretty satisfied with the result when it is working. However i'm getting are datasource related problems when I redeploy my aplication.</p> <p>Here is one of the seven ds I've configured in my my-application-ds.xml:</p> <pre><code>&lt;xa-datasource&gt; &lt;jndi-name&gt;jdbc/my_db_name&lt;/jndi-name&gt; &lt;xa-datasource-class&gt;com.mysql.jdbc.jdbc2.optional.MysqlXADataSource&lt;/xa-datasource-class&gt; &lt;xa-datasource-property name="URL"&gt;jdbc:mysql://192.168.26.2:3306/my_db_name&lt;/xa-datasource-property&gt; &lt;xa-datasource-property name="User"&gt;user&lt;/xa-datasource-property&gt; &lt;xa-datasource-property name="Password"&gt;password&lt;/xa-datasource-property&gt; &lt;min-pool-size&gt;0&lt;/min-pool-size&gt; &lt;max-pool-size&gt;5&lt;/max-pool-size&gt; &lt;idle-timeout-minutes&gt;5&lt;/idle-timeout-minutes&gt; &lt;exception-sorter-class-name&gt; com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter &lt;/exception-sorter-class-name&gt; &lt;valid-connection-checker-class-name&gt; com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker &lt;/valid-connection-checker-class-name&gt; &lt;track-connection-by-tx/&gt; &lt;/xa-datasource&gt; </code></pre> <p>I think I've configured properly according with all i've found on the web about this.</p> <p><strong>1 . Deployed the application run a test OK</strong></p> <p><strong>2 . Redeployed the application, run a test NOK</strong></p> <p>10:07:23,865 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null</p> <pre><code>org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.NullPointerException) at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:144) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) at net.saphety.billing_core.dblayer.datasource.HibernateSession.configure(HibernateSession.java:58) at net.saphety.billing_core.dblayer.datasource.HibernateSessionFactory.getHibernateSession(HibernateSessionFactory.java:25) at net.saphety.billing_core.dblayer.datasource.HibDaoCRUD.&lt;init&gt;(HibDaoCRUD.java:35) at net.saphety.billingcorewebapp.web.FilterHibernateControlSession.doFilter(FilterHibernateControlSession.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(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.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.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: java.lang.NullPointerException at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:426) at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:137) at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:107) at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:47) at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:136) ... 34 more </code></pre> <p>After that hibernate complains about dialect...</p> <pre><code>org.hibernate.HibernateException: Hibernate Dialect must be explicitly set at net.saphety.billing_core.dblayer.datasource.HibernateSession.configure(HibernateSession.java:62) at net.saphety.billing_core.dblayer.datasource.HibernateSessionFactory.getHibernateSession(HibernateSessionFactory.java:25) at net.saphety.billing_core.dblayer.datasource.HibDaoCRUD.&lt;init&gt;(HibDaoCRUD.java:35) at net.saphety.billingcorewebapp.web.FilterHibernateControlSession.doFilter(FilterHibernateControlSession.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(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.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619) </code></pre> <p><strong>3 . Redeploy the *-ds.xml file and run a test NOK, nothing happens... In my browser I receive a blank response.</strong></p> <p><strong>4 . Redeploy the application, all works fine again. :S</strong></p> <p>MySql server have enough connections available. </p> <p>I have other project with data sources but with an oracle server and no problem there. So it has something to do with MySql but I can't figure out what.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USrsilva4
    1. USrsilva4
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInvalid Jboss Datasources after redeploy
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POInvalid Jboss Datasources after redeploy
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POInvalid Jboss Datasources after redeploy
      1. USrsilva4
      1. VTBountyStart
    1. COSo let me see if I get this correctly? You are NOK until you redeploy your *-ds.xml file AND THEN redeploy your app, but not the other way around?
      singulars
      1. POInvalid Jboss Datasources after redeploy
      1. USAdam
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload