Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-7384

When a datasource has no connection-properties and its driver has defined datasource-class a warning should be issued

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Rejected
    • 7.0.3.GA
    • None
    • JCA
    • None
    • Hide

      1. Prepare JBoss EAP 7.0.3
      2. Edit standalone.xml and MySQL datasource like below:

      <subsystem xmlns="urn:jboss:domain:datasources:4.0">
          <datasources>
              <datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS">
                  <connection-url>jdbc:mysql://localhost:3306/mydb</connection-url>
                  <driver>com.mysql</driver>
                  <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                  <pool>
                      <min-pool-size>10</min-pool-size>
                      <max-pool-size>100</max-pool-size>
                      <prefill>true</prefill>
                  </pool>
                  <security>
                      <user-name>root</user-name>
                      <password></password>
                  </security>
                  <statement>
                      <prepared-statement-cache-size>32</prepared-statement-cache-size>
                      <share-prepared-statements/>
                  </statement>
              </datasource>
              <drivers>
                  <driver name="com.mysql" module="com.mysql">
                      <datasource-class&gt;com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource</datasource-class&gt;
                  </driver>
              </drivers>
          </datasources>
      </subsystem>
      

      3. Run JBoss EAP 7.0.3 bin/standalone.sh
      4. Failed to start service org.wildfly.data-source.MySqlDS
      javax.resource.ResourceException: IJ031103: At least one connection property must be defined for datasource-class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

      javax.resource.ResourceException: IJ031103: At least one connection property must be defined for datasource-class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
      

      5. Actual expected:
      1. It should show the Bound data source [java:jboss/datasources/MySqlDS] message in logs while server starting
      2. Go to JBoss EAP 7.0.0 Management Console
      Go to http://localhost:9990/console/App.html#profile/datasources;name=MySqlDS
      Run 'Test Connection' and return 'Successfully connected to database MySqlDS.'

      Show
      1. Prepare JBoss EAP 7.0.3 2. Edit standalone.xml and MySQL datasource like below: <subsystem xmlns= "urn:jboss:domain:datasources:4.0" > <datasources> <datasource jndi-name= "java:jboss/datasources/MySqlDS" pool-name= "MySqlDS" > <connection-url>jdbc:mysql: //localhost:3306/mydb</connection-url> <driver>com.mysql</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>10</min-pool-size> <max-pool-size>100</max-pool-size> <prefill> true </prefill> </pool> <security> <user-name>root</user-name> <password></password> </security> <statement> <prepared-statement-cache-size>32</prepared-statement-cache-size> <share-prepared-statements/> </statement> </datasource> <drivers> <driver name= "com.mysql" module= "com.mysql" > <datasource- class& gt;com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource</datasource- class& gt; </driver> </drivers> </datasources> </subsystem> 3. Run JBoss EAP 7.0.3 bin/standalone.sh 4. Failed to start service org.wildfly.data-source.MySqlDS javax.resource.ResourceException: IJ031103: At least one connection property must be defined for datasource-class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource javax.resource.ResourceException: IJ031103: At least one connection property must be defined for datasource-class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource 5. Actual expected: 1. It should show the Bound data source [java:jboss/datasources/MySqlDS] message in logs while server starting 2. Go to JBoss EAP 7.0.0 Management Console Go to http://localhost:9990/console/App.html#profile/datasources;name=MySqlDS Run 'Test Connection' and return 'Successfully connected to database MySqlDS.'
    • Workaround Exists
    • Hide

      It's working either changing <datasource> with <xa-datasource> element in the datasources subsystem or By adding <connection-property name="url"> element in datasource

      Show
      It's working either changing <datasource> with <xa-datasource> element in the datasources subsystem or By adding <connection-property name="url"> element in datasource

    Description

      If a datasource-class is defined with non XA data source .It is failing with error "IJ031103: At least one connection property must be defined for datasource-class". The same behaviour is working fine with EAP 6. It should also work in JBoss EAP 7.

      Attachments

        Issue Links

          Activity

            People

              smaestri@redhat.com Stefano Maestri
              rhn-support-cagarwal Chhaya Agarwal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: