Apache Doris Web UI error : Unknown database 'undefined'

[DarkCoffeeLake]

Hey eveyone,

Im new to apache Doris and im encountering some problems in the Web UI.
for some reason i cannot use the editor to execute command lines and make queries because it always gives me the same error that an unknown database is undefined.
i searched everyone for a way to even select an already created database/table with mysql in the terminal but still it doesnt work in the web version.

im always getting this error :
Execution failed: Error Failed to execute sql: java.sql.SQLSyntaxErrorException: (conn=27) errCode = 2, detailMessage = Unknown database 'undefined'

any help is appreciated

[DarkCoffeeLake]

the log :

Caused by: java.sql.SQLSyntaxErrorException: (conn=3) errCode = 2, detailMessage = Unknown database 'undefined'
at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:282) ~[mariadb-java-client-3.0.9.jar:?]
at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:370) ~[mariadb-java-client-3.0.9.jar:?]
at org.mariadb.jdbc.client.impl.ConnectionHelper.authenticationHandler(ConnectionHelper.java:309) ~[mariadb-java-client-3.0.9.jar:?]
at org.mariadb.jdbc.client.impl.StandardClient.(StandardClient.java:189) ~[mariadb-java-client-3.0.9.jar:?]
at org.mariadb.jdbc.Driver.connect(Driver.java:70) ~[mariadb-java-client-3.0.9.jar:?]
at org.mariadb.jdbc.Driver.connect(Driver.java:101) ~[mariadb-java-client-3.0.9.jar:?]
at org.mariadb.jdbc.Driver.connect(Driver.java:27) ~[mariadb-java-client-3.0.9.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:683) ~[java.sql:?]
at java.sql.DriverManager.getConnection(DriverManager.java:230) ~[java.sql:?]
at org.apache.doris.httpv2.util.StatementSubmitter$Worker.call(StatementSubmitter.java:102) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.httpv2.util.StatementSubmitter$Worker.call(StatementSubmitter.java:84) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]

[zzchiyu]

#32157

[zzchiyu]

This is a bug. to execute sql, u can change the jdbc connection.

[xumingming]

u can change the jdbc connection

Any workaround for the Web UI?

[Sanchez023]

ha,this is beacuse the doris can not recognize the default database, you should click the database name on database lists firstly. and you can set the database name in your jdbcUrl