glassfish
  1. glassfish
  2. GLASSFISH-12221

connection pool cannot connect to MySQL database server

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: v3.0.1
    • Fix Version/s: not determined
    • Component/s: jdbc
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: Macintosh

    • Issuezilla Id:
      12,221

      Description

      Using the following connection pool properties, you can successfully create a
      working connection to a default installation ('root'/[empty password]) of MySQL
      server 5.1. This applies to GF 3.0 (final release) through to 3.0.1 (b-16).
      This no longer works in promoted builds (b-19 - b-22).

      datasource classname: com.mysql.jdbc.jdbc2.optional.MysqlDataSource
      resource type: javax.sql.DataSource (or) javax.sql.ConnectionPoolDataSource

      For an example NetBeans project, see:
      http://netbeans.org/projects/samples/downloads/download/Samples%252FJava%2520Web%252FIFPWAFCAD.zip

      In sun-resources.xml, replace:

      <property name="Password" value="nbuser"/>

      with:

      <property name="Password" value=""/>

      SQL script to generate database:
      http://netbeans.org/projects/samples/downloads/download/Samples%252FJava%2520Web%252Fifpwafcad.sql

        Activity

        Hide
        dochez added a comment -

        Reassigning to Jagadish for further evaluations.

        Show
        dochez added a comment - Reassigning to Jagadish for further evaluations.
        Hide
        Jagadish added a comment -

        Transferring to Shalini for investigation.

        Show
        Jagadish added a comment - Transferring to Shalini for investigation.
        Hide
        Shalini added a comment -

        There is a related issue : Issue 12188 that was fixed in 3.1. Could you try the
        same in GF v3.1 latest promoted build? The fix was not put in b22 of 3.0.1.

        Please let us know if you still see the issue with GF V3.1.

        Show
        Shalini added a comment - There is a related issue : Issue 12188 that was fixed in 3.1. Could you try the same in GF v3.1 latest promoted build? The fix was not put in b22 of 3.0.1. Please let us know if you still see the issue with GF V3.1.
        Hide
        Shalini added a comment -

        Reducing the priority as a similar issue was fixed in v3.1. Requesting the
        submitter to evaluate this issue in the latest v3.1 builds and report back.

        Show
        Shalini added a comment - Reducing the priority as a similar issue was fixed in v3.1. Requesting the submitter to evaluate this issue in the latest v3.1 builds and report back.
        Hide
        Tom Mueller added a comment -

        Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.

        Show
        Tom Mueller added a comment - Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.

          People

          • Assignee:
            sfelts
            Reporter:
            tgiunipero
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: