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 "Andrew McIntyre (JIRA)" <de...@db.apache.org> on 2006/04/24 22:44:06 UTC

[jira] Closed: (DERBY-736) "" does not work as a userid for Derby client (SqlException: userid length, 0, is not allowed.)

     [ http://issues.apache.org/jira/browse/DERBY-736?page=all ]
     
Andrew McIntyre closed DERBY-736:
---------------------------------

    Resolution: Fixed

> ""  does not work as a userid for Derby client (SqlException: userid length, 0, is not allowed.)
> ------------------------------------------------------------------------------------------------
>
>          Key: DERBY-736
>          URL: http://issues.apache.org/jira/browse/DERBY-736
>      Project: Derby
>         Type: Bug

>   Components: Network Client
>     Versions: 10.1.2.1, 10.2.0.0, 10.1.3.0, 10.1.2.2
>     Reporter: Kathey Marsden
>     Assignee: Kathey Marsden
>      Fix For: 10.2.0.0, 10.1.3.0, 10.1.2.2

>
> $ java TestConnect
> Derby embedded allows "" as a user id.  DerbyClient however, 
> throws  the following exception:
> connected with embedded
> Exception in thread "main" org.apache.derby.client.am.SqlException: userid length, 0, is not allowed.
>         at org.apache.derby.client.net.NetConnection.checkUserLength(NetConnection.java:993)
>         at org.apache.derby.client.net.NetConnection.checkUser(NetConnection.java:1008)
>         at org.apache.derby.client.net.NetConnection.checkUserPassword(NetConnection.java:1012)
>         at org.apache.derby.client.net.NetConnection.flowConnect(NetConnection.java:384)
>         at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:195)
>         at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:125)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at TestConnect.main(TestConnect.java:23)
> $
> Below is the program to reproduce
> import java.sql.DriverManager;
> import java.sql.Connection;
> import java.sql.*;
> public class TestConnect
> {
>     public static void main(String argv[]) 
>        throws Exception
>     {
>         Connection con = null;
>         String user = "";
>         String pwd = "";
>           // Embedded is ok
> 	   Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
> 	   con = DriverManager.getConnection("jdbc:derby:" + "dbemb;create=true", user, pwd);
>             System.out.println("connected with embedded" );
> 	   // Will not connect with zero length user id with client
> 		Class.forName("org.apache.derby.jdbc.ClientDriver");
> 		con = DriverManager.getConnection("jdbc:derby://localhost:1527/" +
> 										  "dbnet;create=true",
> 										   user, pwd);
>        System.out.println("connected with client" );
>         con.close();
>         System.out.println("closed");
> 	}
> }
>  

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