#556 Cannot omit username

[Anonymous]

Derby databases can be created without a username and password.

However it does not appear to be possible to login without a username and password; one is forced to enter at least one character for each.

If the user does not provide a user/password, then the program should call the connect method without user/password parameters

[Bhala Ghatate]

HI all, was trying to find any more discussions on this.
The latest version of duckdb can't be connectetd to either.
https://github.com/duckdb/duckdb/issues/5498#issuecomment-1327980651

[Gerd Wagner]

Sorry I can't reproduce your problem. Here's a simple example to verify that SQuirreL can handle empty user/password:

Download the latest SQLite JDBC driver here:
https://github.com/xerial/sqlite-jdbc/releases/download/3.40.0.0/sqlite-jdbc-3.40.0.0.jar
The driver is standalone and doesn't require any database engine.

Create an Alias for the driver using the JDBC-URL

jdbc:sqlite:<somePathOnOurSystem>sampleDB2

Connect to the Alias with empty user and password