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 "Shazin Sadakath (JIRA)" <ji...@apache.org> on 2009/09/21 12:24:17 UTC
[jira] Issue Comment Edited: (DERBY-4383) Cannot connect to Network
Server to create a database from a Query Analyzer
[ 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.