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
    • Resolution: Won't Do
    • 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.'

    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

          duplicates

          Bug - A problem that impairs or prevents the functions of the product. JBEAP-6594 (7.0.z) JBJCA-1331 - Use connection-url to get database connection when connection properties for datasource-class is empty

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified
          is caused by

          Bug - A problem that impairs or prevents the functions of the product. JBJCA-1320 Unable to create JDBC local datasource without properties on JBoss EAP 7

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Closed

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) WFLY-6198 When a datasource has no connection-properties and its driver has defined datasource-class a warning should be issued

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Task - Represents a small unit of work that is not end-user facing. JBJCA-1331 Use connection-url to get database connection when connection properties for datasource-class is empty

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. JBEAP-6133 (7.1.0) Upgrade to IronJacamar 1.4.0 when released

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. JBEAP-6489 (7.0.z) Upgrade to IronJacamar from 1.3.4 to 1.3.5

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified

          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: