[jira] Created: (DERBY-450) dblook should be able to use Network Client driver to connect to Network server

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (DERBY-450) dblook should be able to use Network Client driver to connect to Network server

Apache Derby Developers mailing list
dblook should be able to use Network Client driver to connect to Network server
-------------------------------------------------------------------------------

         Key: DERBY-450
         URL: http://issues.apache.org/jira/browse/DERBY-450
     Project: Derby
        Type: New Feature
  Components: Tools  
    Versions: 10.0.2.1    
    Reporter: simmi iyer


Currently dblook can hook to Network server using IBM DB2 driver.

 It does not support the database URL for Network Client driver whereas ij supports this.
Support for drivers by all tools should be consistent.

--
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

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (DERBY-450) dblook should be able to use Network Client driver to connect to Network server

Apache Derby Developers mailing list
    [ http://issues.apache.org/jira/browse/DERBY-450?page=comments#action_12315322 ]

A B commented on DERBY-450:
---------------------------

Can you give an example of the dblook command that you're using?

I tried using dblook with the following client URLs and it worked as expected:

java org.apache.derby.tools.dblook -d jdbc:derby://localhost:1527/testDB -verbose

java org.apache.derby.tools.dblook -d "jdbc:derby://localhost:1527/testDB;user=someUsr;password=somePwd" -verbose

I also looked at the source code for dblook and the logic is there for the client url/driver, so it seems like everything should be working.  If you can post more details--what the error message is, what your dblook command is, and the output from the "dblook.log" file, that might help us figure out what the problem is.

Thanks.

> dblook should be able to use Network Client driver to connect to Network server
> -------------------------------------------------------------------------------
>
>          Key: DERBY-450
>          URL: http://issues.apache.org/jira/browse/DERBY-450
>      Project: Derby
>         Type: New Feature
>   Components: Tools
>     Versions: 10.0.2.1
>     Reporter: simmi iyer

>
> Currently dblook can hook to Network server using IBM DB2 driver.
>  It does not support the database URL for Network Client driver whereas ij supports this.
> Support for drivers by all tools should be consistent.

--
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

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (DERBY-450) dblook should be able to use Network Client driver to connect to Network server

Apache Derby Developers mailing list
In reply to this post by Apache Derby Developers mailing list
    [ http://issues.apache.org/jira/browse/DERBY-450?page=comments#action_12315461 ]

simmi iyer commented on DERBY-450:
----------------------------------

1. This is the dblook command

java  -Dderby.system.home=/export/home/user/derby/derbySystem org.apache.derby.tools.dblook -d 'jdbc:derby://electra:1527/mydb;user=mydb_owner;password=owner_mydb' -verbose

2. This is derby.properties

derby.connection.requireAuthentication=true
derby.drda.logConnections=true
derby.drda.traceAll=true
derby.infolog.append=true
derby.authentication.provider=BUILTIN

3. CLASSPATH
/usr/local/derby_10/lib/derby.jar:/usr/local/derby_10/lib/derbytools.jar:/usr/local/derby_10/lib/derbynet.jar:/usr/local/derby_10/lib/derbyclient.jar:./


4. dblook output

java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:545)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at org.apache.derby.tools.dblook.go(dblook.java)
        at org.apache.derby.tools.dblook.main(dblook.java)
-- **--> DEBUG: No suitable driver

5. I am able to use client driver in java code with same derby.properties and CLASSPATH.

thanks


> dblook should be able to use Network Client driver to connect to Network server
> -------------------------------------------------------------------------------
>
>          Key: DERBY-450
>          URL: http://issues.apache.org/jira/browse/DERBY-450
>      Project: Derby
>         Type: New Feature
>   Components: Tools
>     Versions: 10.0.2.1
>     Reporter: simmi iyer

>
> Currently dblook can hook to Network server using IBM DB2 driver.
>  It does not support the database URL for Network Client driver whereas ij supports this.
> Support for drivers by all tools should be consistent.

--
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

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (DERBY-450) dblook should be able to use Network Client driver to connect to Network server

Apache Derby Developers mailing list
In reply to this post by Apache Derby Developers mailing list
    [ http://issues.apache.org/jira/browse/DERBY-450?page=comments#action_12315498 ]

A B commented on DERBY-450:
---------------------------

Thanks for the extra info.  After trying unsuccessfully to reproduce this with my local codeline, I then realized that you filed this bug against Derby 10.0, not 10.1 (my local codeline is 10.1).  I then tried to use the client URL with Derby 10.0 and saw the same problem that you see.

So far as I know, the Derby client  isn't officially supported until 10.1.  This means that the logic to parse/process a client URL doesn't exist in the 10.0 code for dblook.  If you'd like to use the Derby client for your work, I think you'll have to use the Derby 10.1 set of jars.

> dblook should be able to use Network Client driver to connect to Network server
> -------------------------------------------------------------------------------
>
>          Key: DERBY-450
>          URL: http://issues.apache.org/jira/browse/DERBY-450
>      Project: Derby
>         Type: New Feature
>   Components: Tools
>     Versions: 10.0.2.1
>     Reporter: simmi iyer

>
> Currently dblook can hook to Network server using IBM DB2 driver.
>  It does not support the database URL for Network Client driver whereas ij supports this.
> Support for drivers by all tools should be consistent.

--
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

Reply | Threaded
Open this post in threaded view
|

[jira] Resolved: (DERBY-450) dblook should be able to use Network Client driver to connect to Network server

Apache Derby Developers mailing list
In reply to this post by Apache Derby Developers mailing list
     [ http://issues.apache.org/jira/browse/DERBY-450?page=all ]
     
Andrew McIntyre resolved DERBY-450:
-----------------------------------

    Resolution: Invalid

Derby client not supported by Derby 10.0

> dblook should be able to use Network Client driver to connect to Network server
> -------------------------------------------------------------------------------
>
>          Key: DERBY-450
>          URL: http://issues.apache.org/jira/browse/DERBY-450
>      Project: Derby
>         Type: New Feature
>   Components: Tools
>     Versions: 10.0.2.1
>     Reporter: simmi iyer

>
> Currently dblook can hook to Network server using IBM DB2 driver.
>  It does not support the database URL for Network Client driver whereas ij supports this.
> Support for drivers by all tools should be consistent.

--
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