You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by "viola.lu (JIRA)" <ji...@apache.org> on 2008/11/11 07:46:44 UTC

[jira] Created: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Postgresql new drives would not be listed in Drive Jars list and download driver list
-------------------------------------------------------------------------------------

                 Key: GERONIMO-4405
                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
             Project: Geronimo
          Issue Type: Bug
      Security Level: public (Regular issues)
          Components: databases
    Affects Versions: 2.1.3
         Environment: Any platform
            Reporter: viola.lu
            Priority: Minor


Steps:
1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.


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


[jira] Commented: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Rex Wang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12648948#action_12648948 ] 

Rex Wang commented on GERONIMO-4405:
------------------------------------

Thanks, Donald.

> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Assignee: Donald Woods
>            Priority: Minor
>             Fix For: 2.1.4, 2.2
>
>         Attachments: GERONIMO-4405.patch
>
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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


[jira] Closed: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods closed GERONIMO-4405.
----------------------------------

    Resolution: Fixed

Rev718305 in branches/2.1 (2.1.4-SNAPSHOT)
Rev718307 in trunk (2.2-SNAPSHOT)
Thanks Rex for the patch.

> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Assignee: Donald Woods
>            Priority: Minor
>             Fix For: 2.1.4, 2.2
>
>         Attachments: GERONIMO-4405.patch
>
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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


[jira] Commented: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Lin Sun (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12646928#action_12646928 ] 

Lin Sun commented on GERONIMO-4405:
-----------------------------------

Just saw the patch.   You might want to check why the versions are listed explicitly before and whether you should just add 8.3 to the list (instead of eliminate the version).   This could be a way to control the jdbc jars that we tested.

> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Priority: Minor
>         Attachments: GERONIMO-4405.patch
>
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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


[jira] Updated: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Rex Wang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rex Wang updated GERONIMO-4405:
-------------------------------

    Attachment: GERONIMO-4405.patch

After discussing with the reporter, the above patch adopts solution  #2, which can meet her need.

#3 could be a new Feature Request,and will be implement in future.

Thanks.

> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Priority: Minor
>         Attachments: GERONIMO-4405.patch
>
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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


[jira] Updated: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods updated GERONIMO-4405:
-----------------------------------

       Patch Info: [Patch Available]
    Fix Version/s: 2.2
                   2.1.4
         Assignee: Donald Woods

> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Assignee: Donald Woods
>            Priority: Minor
>             Fix For: 2.1.4, 2.2
>
>         Attachments: GERONIMO-4405.patch
>
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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


[jira] Commented: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Rex Wang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12647506#action_12647506 ] 

Rex Wang commented on GERONIMO-4405:
------------------------------------

Yes, Lin. I mean the reporter here wanna install a postgreSQL 8.3 jars to geronimo repository, but after that she can't find that in the jars list of the portlet. 
I think it is not reasonable that we don't allow user to try installing a new jdbc jars to our server.
So I changed it from 
 <attribute name="dependencyFilterStrings">postgresql/postgresql//jar,postgresql/postgresql-7.3//jar,postgresql/postgresql-7.4//jar,postgresql/postgresql-8.0//jar,postgresql/postgresql-8.1//jar,postgresql/postgresql-8.2//jar</attribute>
to
<attribute name="dependencyFilterStrings">postgresql///jar</attribute>
This can solve her issue and I think it is not conflict with the way we control the tested jdbc jars. 

> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Priority: Minor
>         Attachments: GERONIMO-4405.patch
>
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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


[jira] Commented: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Lin Sun (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12646926#action_12646926 ] 

Lin Sun commented on GERONIMO-4405:
-----------------------------------

For No. 3, we cannot do anything about it, before the postgresql 8.3 is published at a public repo.   I think i recently added 8.2 there.

For No. 2, you might want to check if the list is cached (could be done on purpose).   For example, does this work if you logout admin console or/and exit your browser?

> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Priority: Minor
>         Attachments: GERONIMO-4405.patch
>
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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


[jira] Commented: (GERONIMO-4405) Postgresql new drives would not be listed in Drive Jars list and download driver list

Posted by "Rex Wang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/GERONIMO-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12646503#action_12646503 ] 

Rex Wang commented on GERONIMO-4405:
------------------------------------

This is because the latest version - 8.3 of postgresql is not list in the "http://geronimo.apache.org/driver-downloads.properties", which the portlet used to generate the drop-down list.

And the incidental issue is that even if you download the 8.3 jars from the other site and copy them to the geronimo repository with the path "postgresql/postgresql-8.3//jar", the portlet won't show it  in the select-list that represents the installed jdbc driver jars. This is because  the plan.xml of sysdb-console-tomcat has the following lines for the <gbean> of postgresql:
<attribute name="dependencyFilterStrings">postgresql/postgresql//jar,postgresql/postgresql-7.3//jar,postgresql/postgresql-7.4//jar,postgresql/postgresql-8.0//jar,postgresql/postgresql-8.1//jar,postgresql/postgresql-8.2//jar</attribute>

There are 3 ways to resolve this problem:
1. remove the above line
such as DB2, and the weak point is that the select-list will list all the jars in repo

2. use the filter pattern "postgresql///jar" instead of "postgresql/postgresql//jar"
has a wider scope

3. change the filter mechanism
allow user to use "*" to represent any character.
we need add a new method to the org.apache.geronimo.kernel.repository.Artifact class

So, any comments?


> Postgresql new drives would not be listed in Drive Jars list and download driver list
> -------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-4405
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4405
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.1.3
>         Environment: Any platform
>            Reporter: viola.lu
>            Priority: Minor
>
> Steps:
> 1.login admin console, go to "repository" porlet, install a postgresql jdbc driver 8.3
> 2.Go to "database pool" porlet->create a datasource type postgresql local or XA, click next.Newly installed driver is not listed in driver jars.
> 3.CLick "download driver" button, just postgresql 8.1.8.2,7.4 is listed, can't choose 8.3.

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