[DERBY-648] ij 'show connections' statement does not work in JSR169

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: Tools
• Environment: J2ME/CDC/Foundation Profile with JSR169
• Assignee: Deepa
• Reporter: Deepa
• Created: 26/Oct/05 08:51
• Updated: 09/Nov/05 06:36
• Resolved: 09/Nov/05 06:36

Description

'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.