Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Message-ID: <1933365901.1204580810431.JavaMail.jira@brutus>
Date: Mon, 3 Mar 2008 13:46:50 -0800 (PST)
From: "David Jencks (JIRA)" <jira@apache.org>
To: dev@geronimo.apache.org
Subject: [jira] Commented: (GERONIMO-3878) Unable to deploy Postgres
 Datasource from console dialog "Database Pools" because of missing jar
 files in jar selection listbox.
In-Reply-To: <110889957.1204107831223.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

David Jencks commented on GERONIMO-3878:
----------------------------------------

bq.Yes, that's right. It works if you donwload the driver directly. The dialog first does not work, if you try a test, it fails. But after this first failure, the dialog is ok. It always comes up with the corret postgres specific settings, and more over, the datasource is ok. The application works. But i'am still confused because of the following:

bq.    * Why this strange behaviour - only for Postgres? With geronimo 2.0.2 you could download the driver separately, and then use the common libs dialog (now called repository) to deploy it. Then you will see it in the jars listbox. This still works - if you use another database type (like DB2).

I installed postgresql/postgresql/8.2-504.jdbc3/jar using the "repository" page and saw it in the wizard.  I think I've been getting confused between "postgres" and "postgresql".  I notice that my previous post embodied this confusion :-)

I think two things might help...
# a checkbox to show all jars 
# a page or change to the repository page to copy a jar from a maven repo to the geronimo repo.  (part of GERONIMO-3884)

 bq.   * This workaround is not suitable for a production system. In production we "NEVER" have a internet connection. People in the production system are used to get a jar, and then they deploy it using the dialoge. So, i could use the dialog of an other system with internet connection to create a plan and advice production to deploy the plan. But this will probably result in editing and changing the plan to the preferences of production systems. And this will result in errors.

I'm not sure what you mean by a production system.  In an even slightly controlled environment I'd expect that you would not use the admin console for anything, and instead would have a project-wide controlled maven repository for approved artifacts and build plugins and assemblies for your apps as described  here:
http://cwiki.apache.org/confluence/display/GMOxDOC21/Constructing+a+special-purpose+server+using+maven


> Unable to deploy Postgres Datasource from console dialog "Database Pools" because of missing jar files in jar selection listbox.
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: GERONIMO-3878
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-3878
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: console
>    Affects Versions: 2.1
>         Environment:  Windows XP Professional and Ubuntu
>            Reporter: Ralf Baumhof
>   Original Estimate: 120h
>  Remaining Estimate: 120h
>
> Trying to deploy a datasource with console dialog "Database Pools". 
>  - Select link "Console Navigation/Services/Database Pools".
>  - Select link "Using the geronimo database pool wizard".
>  - Enter some database name like for instance "vesuv" and select as Database Type: "PostgreSQL XA" or "PostgreSQL local".
>  - Click the Next button.
>  - Now, on the page where you specify the properties of the database pool, the listbox where you can select the driver jar  is empty. If you choose another database type (on the previous dialog page), the list is filled with all entries from repository. The same steps have been made with Geronimo 2.02. There the database could be deployed. 

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