[jira] Updated: (DERBY-648) ij 'show connections' statement does not work in JSR169

["Deepa Remesh (JIRA)" <de...@db.apache.org>]

     [ http://issues.apache.org/jira/browse/DERBY-648?page=all ]

Deepa Remesh updated DERBY-648:
-------------------------------

    Attachment: derby-648.diff
                derby-648.status

Attaching a patch 'derby-648.diff' for this. The patch does the following:

1. Checks if ij.dataSource property is set in 'showConnectionsMethod' in ij. If it is set, URLs are not displayed. Only connection names are displayed. When DataSource is used to get a connection, there will not be an associated URL.
2. Enables 2 tests in J2ME which pass with this change. Creates new master files for these tests.

Ran derbyall on Windows XP with Sun JDK 1.4.2 and IBM WCTME5.7 j9_foundation VM. No new failures.

"Show Connections" command is documented in Derby Tools and Utilities Guide. However, ij.dataSource property is not yet documented. DERBY-391 is open for this. I will add doc information for this change to DERBY-391.


> ij 'show connections' statement does not work in JSR169
> -------------------------------------------------------
>
>          Key: DERBY-648
>          URL: http://issues.apache.org/jira/browse/DERBY-648
>      Project: Derby
>         Type: Improvement
>   Components: Tools
>     Versions: 10.2.0.0
>  Environment: J2ME/CDC/Foundation Profile with JSR169
>     Reporter: Deepa Remesh
>     Assignee: Deepa Remesh
>     Priority: Minor
>  Attachments: derby-648.diff, derby-648.status
>
> 'show connections' statement throws the following exception when run in CDC/FP with JSR169: "JAVA ERROR: java.lang.NoSuchMethodError: java/sql/DatabaseMetaData.getURL()Ljava/lang/String;"
> This is because java/sql/DatabaseMetaData.getURL() method is not available in JSR169. In JSR169, DataSource has to be used to get a connection and this does not use a URL. So this method is not available.
> Currently, 'show connections' displays connection names along with the URLs used to get the connections. When DataSource is used to get connection (ij.dataSource property is set), I plan to change this to display only connection names. With this change, around 7 tests can be enabled to run in CDC/FP.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira