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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2014/09/03 09:27:52 UTC
[jira] [Commented] (DERBY-6725) Add a system function which returns
the name of the database.
[ https://issues.apache.org/jira/browse/DERBY-6725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14119494#comment-14119494 ]
Knut Anders Hatlen commented on DERBY-6725:
-------------------------------------------
A possible workaround is to use the getURL() function provided by the databaseMetaData tool:
{noformat}
ij version 10.12
ij> connect 'jdbc:derby:memory:db;create=true';
ij> call syscs_util.syscs_register_tool('databaseMetaData', true);
0 rows inserted/updated/deleted
ij> values getURL();
1
--------------------------------------------------------------------------------------------------------------------------------
jdbc:derby:memory:db
1 row selected
ij>
{noformat}
> Add a system function which returns the name of the database.
> -------------------------------------------------------------
>
> Key: DERBY-6725
> URL: https://issues.apache.org/jira/browse/DERBY-6725
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.12.0.0
> Reporter: Rick Hillegas
>
> Got this request in private conversation with a user. Other databases provide this functionality. Seems straightforward to add.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)