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

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 7.0.3.GA
    • JCA
    • None
    • 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
    • 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.'

      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.

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

                Created:
                Updated:
                Resolved: