[ http://issues.apache.org/jira/browse/DERBY-736?page=all ] Andrew McIntyre reopened DERBY-736: -----------------------------------
> "" 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
