db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4383) Cannot connect to Network Server to create a database from a Query Analyzer
Date Mon, 21 Sep 2009 06:52:16 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4383?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12757831#action_12757831
] 

Knut Anders Hatlen commented on DERBY-4383:
-------------------------------------------

If I understand this report correctly, you want to be able to use java.sql.DriverManager.getConnection()
to connect to a network server with no database, and use that connection to create a new database.
Could you add some more details about how such a connection is supposed to work? Derby doesn't
currently have any other way of creating a database than connecting to an URL with a database
name and the connection attribute create=true, so even if you could obtain a Connection object
not associated with a particular database, it wouldn't help you create a new database.

Could you work around this problem by specifying a URL with a database name and create=true
in the query analyzer? For example: jdbc:derby://192.168.0.206:1400/mydb;create=true

> Cannot connect to Network Server to create a database from a Query Analyzer
> ---------------------------------------------------------------------------
>
>                 Key: DERBY-4383
>                 URL: https://issues.apache.org/jira/browse/DERBY-4383
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server
>         Environment: Windows 7, Aqua Data Studio 7.0.36, Java 1.6.0_13
>            Reporter: Shazin Sadakath
>            Priority: Minor
>
> After starting the Network Server trying to connect results in an exception.
> Connection failed: The URL 'jdbc:derby://192.168.0.206:1400/' is not properly formed.
> This is when there is no database created. But if I create a database using ij and then
try to connect using the query analyzer
> then it works fine. But I think we should be able to connect to the Network Server via
any query analyzer even without a database already created (thus we can use the query analyzer
to create databases, tables etc). 

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


Mime
View raw message