db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shazin Sadakath (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (DERBY-4383) Cannot connect to Network Server to create a database from a Query Analyzer
Date Mon, 21 Sep 2009 10:24:17 GMT

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

Shazin Sadakath edited comment on DERBY-4383 at 9/21/09 3:23 AM:
-----------------------------------------------------------------

I was aware of the fact that, jdbc:derby://IP:PORT/DBNAME;create=true should be used to create
a database in derby. In fact I used the command 

connect 'jdbc:derby://IP:PORT/DBNAME;create=true' 

To actually create the database in ij when it didn't allow me to create using Aqua Data Studio
query analyzer which I use in my developments. Aqua Data Studio is a JDBC based query analyzer
which allows to connect multiple databases (Oracle, Sybase, MySQL etc). Sadly when registering
a server it doesn't allow you to specify a direct URL such as jdbc:derby://IP:PORT/DBNAME;create=true
in turn it prompts for Login Name, Password, IP, Port and Database and it creates the URL
in the back end depending on which database we want to connect. Which is why I couldn't use
the workaround. 

But I tried a cheat by specifying DBNAME;create=true in Database field when registering a
server, then it worked. 



      was (Author: shazin):
    I was aware of the fact that, jdbc:derby://IP:PORT/DBNAME;create=true should be used to
create a database in derby. In fact I used the command 

connect 'jdbc:derby://IP:PORT/DBNAME;create=true' 

To actually create the database when it didn't allow me to create using Aqua Data Studio query
analyzer which I use in my developments. Aqua Data Studio is a JDBC based query analyzer which
allows to connect multiple databases (Oracle, Sybase, MySQL etc). Sadly when registering a
server it doesn't allow you to specify a direct URL such as jdbc:derby://IP:PORT/DBNAME;create=true
in turn it prompts for Login Name, Password, IP, Port and Database and it creates the URL
in the back end depending on which database we want to connect. Which is why I couldn't use
the workaround. 

But I tried a cheat by specifying DBNAME;create=true in Database field when registering a
server, then it worked. 


  
> 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