[jira] Created: (GERONIMO-4725) MySQL jdbc connector/driver jars don't show up in the database pool wizard

MySQL jdbc connector/driver jars don't show up in the database pool wizard
--------------------------------------------------------------------------

                 Key: GERONIMO-4725
                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
             Project: Geronimo
          Issue Type: Bug
      Security Level: public (Regular issues)
    Affects Versions: 2.1.4
         Environment: Geronimo 2.1.4, WindowsXP
            Reporter: Jan Snelders


MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you downoad the 3.x.x driver using the exact same wizard.

Steps to reproduce;
- Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
- login to the web console
- Start adding a connection pool using the 'Geronimo database pool wizard'
- Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
- The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
- When done installing the connector the wizard refuses to show the installed connector/driver

- The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")

This bug is not present in geronimo 2.1.3 (tested on WindowsXP)


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jan Snelders updated GERONIMO-4725:
-----------------------------------

    Description:
MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.

Steps to reproduce;
- Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
- login to the web console
- Start adding a connection pool using the 'Geronimo database pool wizard'
- Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
- The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
- When done installing the connector the wizard refuses to show the installed connector/driver

- The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")

This bug is not present in geronimo 2.1.3 (tested on WindowsXP)


  was:
MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you downoad the 3.x.x driver using the exact same wizard.

Steps to reproduce;
- Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
- login to the web console
- Start adding a connection pool using the 'Geronimo database pool wizard'
- Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
- The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
- When done installing the connector the wizard refuses to show the installed connector/driver

- The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")

This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726348#action_12726348 ]

Rex Wang commented on GERONIMO-4725:
------------------------------------

hi Jan,
Can you try copy & rename your jar to "mysql/mysql-connector-java/3.1.12/mysql-connector-java-3.1.12.jar"?

-Rex

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726358#action_12726358 ]

Rex Wang commented on GERONIMO-4725:
------------------------------------

Well,  tested it in either my G2.1.4 or G2.1.5-snapshot, I can not reproduce this...
Can you re-try?

is the attached screen-shot what you want?

-Rex.

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rex Wang updated GERONIMO-4725:
-------------------------------

    Attachment: screenshot-1.jpg

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>         Attachments: screenshot-1.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rex Wang reassigned GERONIMO-4725:
----------------------------------

    Assignee: Rex Wang

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>         Attachments: screenshot-1.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726546#action_12726546 ]

Jan Snelders commented on GERONIMO-4725:
----------------------------------------

Just re-tried it on a different system and that works just fine.

Must have been a problem not related to Geronimo. I think this bug turns out to be a non-issue and can be closed. Sorry for the confusion.

Jan

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>         Attachments: screenshot-1.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jan Snelders closed GERONIMO-4725.
----------------------------------

    Resolution: Invalid

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>         Attachments: screenshot-1.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jan Snelders updated GERONIMO-4725:
-----------------------------------

    Fix Version/s: 2.1.4

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

     [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jürgen Weber updated GERONIMO-4725:
-----------------------------------

    Attachment: screenshot-2.jpg

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12733228#action_12733228 ]

Jürgen Weber commented on GERONIMO-4725:
----------------------------------------

Got the same problem. Added mysql-connector-java-3.1.14-bin.jar to the repository auf 2.2 07-16 and tried to install a pool. See screenshot.

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12733451#action_12733451 ]

Rex Wang commented on GERONIMO-4725:
------------------------------------

Hi, Jurgen,
try rename your jar as: mysql-connector-java-3.1.14.jar
and then add it to <geronimo_repo>/mysql/mysql-connector-java/3.1.14/mysql-connector-java-3.1.14.jar

-Rex

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12733536#action_12733536 ]

Jürgen Weber commented on GERONIMO-4725:
----------------------------------------

OK, made a fresh install of geronimo-tomcat6-javaee5-2.2-SNAPSHOT 2009.07.16-15:10:04.515-0400

Installed mysql-connector-java-3.1.14.jar as
groupId>com.mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>3.1.14</version>
                <type>jar</type>


tried to add Database Type "MySQL". On the next screen there is again the empty driver list shown in the screen shot.

I think this should be fixed and should work without having to rename driver jars.

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12733959#action_12733959 ]

Rex Wang commented on GERONIMO-4725:
------------------------------------

I'm afraid you have to install it to this groupid "mysql", not "com.mysql".
The difference is if you use "com.mysql", then will result in copy the jar to "<geronimo-repo>/com/mysql/......
But, unfortunately, the mysql db driver gbean has this dependecy filter "mysql/mysql-connector-java//jar"...

-Rex

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12734027#action_12734027 ]

Jürgen Weber commented on GERONIMO-4725:
----------------------------------------

With groupid "mysql" I got the DataSource to work, thanks.

But this should be fixed, how should users know which dependency to use?

And, if there is a fixed dependency for the driver gbean, why should the user  choose a Driver JAR at all? It would be better if selecting a Database Type would show the necessary driver jars:

selecting Database Type "MySQL" would display
"this needs mysql/mysql-connector-java//jar in the repository"

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    [ https://issues.apache.org/jira/browse/GERONIMO-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12734889#action_12734889 ]

Rex Wang commented on GERONIMO-4725:
------------------------------------

Well, that is not a good user experience.
The original intention of the dependency filter is to help user to find the specific jar from a bunch jars in the list. That is, if there is no filter constaint on this gbean, the list box on the portlet will show all the jars(might contain db2, informix... and others jars even not a jdbc driver.), And that is also a bad user experience I think.
let the user choose a Driver JAR is because there might many versions of one type of jdbc driver.

However, I also agree that the filter is too strict when try to find the jars. maybe we can use some sorts of regular expression. I'd like to open an improvement later.

-Rex

> MySQL jdbc connector/driver jars don't show up in the database pool wizard
> --------------------------------------------------------------------------
>
>                 Key: GERONIMO-4725
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4725
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues)
>    Affects Versions: 2.1.4
>         Environment: Geronimo 2.1.4, WindowsXP
>            Reporter: Jan Snelders
>            Assignee: Rex Wang
>             Fix For: 2.1.4
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> MySQL connector/driver jars don't show up in the database pool wizard when added to the repository even if you download the 3.x.x driver using the exact same wizard.
> Steps to reproduce;
> - Start a newly installed geronimo 2.1.4. server (I only tested on WindowsXP)
> - login to the web console
> - Start adding a connection pool using the 'Geronimo database pool wizard'
> - Choose 'MySQL' for 'Database Type' and click on 'Next' to go to the next step
> - The multiple select control labeled; 'Driver JAR' is empty at this time, choose 'Download a driver' and install the  MySQL Connector /J 3.1.12
> - When done installing the connector the wizard refuses to show the installed connector/driver
> - The problem also accures also when mannually adding the latest MySQL connector to the repository (under the group "mysql")
> This bug is not present in geronimo 2.1.3 (tested on WindowsXP)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.