You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Deepa Remesh (JIRA)" <de...@db.apache.org> on 2005/10/26 01:51:55 UTC
[jira] Created: (DERBY-648) ij 'show connections' statement does not work in JSR169
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
Assigned to: Deepa Remesh
Priority: Minor
'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
[jira] Commented: (DERBY-648) ij 'show connections' statement does not work in JSR169
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-648?page=comments#action_12356638 ]
Kathey Marsden commented on DERBY-648:
--------------------------------------
Deepa, I am sorry I didn't get this in before the eol changes and now there are conflicts. Can I bother you for one more patch?
Thanks
Kathey
> 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-v2.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
[jira] Updated: (DERBY-648) ij 'show connections' statement does not work in JSR169
Posted by "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-v2.diff
Thanks Kathey for looking into this. I am attaching 'derby-648-v2.diff' after formatting showConnections method in ij.jj.
> 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-v2.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
[jira] Updated: (DERBY-648) ij 'show connections' statement does not work in JSR169
Posted by "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
[jira] Commented: (DERBY-648) ij 'show connections' statement does not work in JSR169
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-648?page=comments#action_12356031 ]
Kathey Marsden commented on DERBY-648:
--------------------------------------
This change looks good except that there seems to be a formatting issue with the new code in the ij.jj file. Could you fix that up and I'll commit.
row.append('*');
haveCurrent=true;
}
- row.append(" - ");
- row.append(s.getConnection().getMetaData().getURL());
+
+ //If ij.dataSource property is set, show only connection names.
+ //In this case, URL is not used to get connection, so do not append URL
+ String dsName = util.getSystemProperty("ij.dataSource");
+ if(dsName == null){
+ row.append(" - ");
+ row.append(s.getConnection().getMetaData().getURL());
+ }
// save the warnings from these connections
w = appendWarnings(w,s.getConnection().getWarnings());
s.getConnection().clearWarnings();
> 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
[jira] Updated: (DERBY-648) ij 'show connections' statement does not work in JSR169
Posted by "Deepa Remesh (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-648?page=all ]
Deepa Remesh updated DERBY-648:
-------------------------------
Attachment: (was: derby-648.diff)
> 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.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
[jira] Closed: (DERBY-648) ij 'show connections' statement does not work in JSR169
Posted by "Deepa Remesh (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-648?page=all ]
Deepa Remesh closed DERBY-648:
------------------------------
> 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
> Fix For: 10.2.0.0
> Attachments: derby-648-v2.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
[jira] Resolved: (DERBY-648) ij 'show connections' statement does not work in JSR169
Posted by "Deepa Remesh (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-648?page=all ]
Deepa Remesh resolved DERBY-648:
--------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
Verified by running tests jdbcapi/users2.sql and jdbcapi/secureUsers.sql. Fixed by svn revisions 330547 and 331885.
> 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
> Fix For: 10.2.0.0
> Attachments: derby-648-v2.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