[jira] [Created] (ZEPPELIN-5816) [MINOR] [JDBC] JDBCInterpreterTest.testMultiTenant_* improvement

["Guanhua LI (Jira)" <ji...@apache.org>]

Guanhua LI created ZEPPELIN-5816:
------------------------------------

             Summary: [MINOR] [JDBC] JDBCInterpreterTest.testMultiTenant_*  improvement
                 Key: ZEPPELIN-5816
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-5816
             Project: Zeppelin
          Issue Type: Improvement
            Reporter: Guanhua LI
            Assignee: Guanhua LI


Now In test cases `JDBCInterpreterTest.testMultiTenant_1` and `JDBCInterpreterTest.testMultiTenant_1`, the jdbc interpreter would try to connect h2 databases with 3 non-existed user.

It would cost more time to execute these two test case.  
And also the interpreter would log a long message about `JdbcSQLInvalidAuthorizationSpecException` , which may mislead developer who is unfamiliar to JDBC module into thinking there is something wrong with the test case。

```
03:41:28.204 [main] ERROR org.apache.zeppelin.jdbc.JDBCInterpreter - Fail to getConnection
org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-206]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:529) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:496) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.message.DbException.get(DbException.java:227) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.message.DbException.get(DbException.java:203) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.message.DbException.get(DbException.java:192) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.engine.Engine.validateUserAndPassword(Engine.java:393) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.engine.Engine.createSession(Engine.java:206) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:117) ~[h2-2.0.206.jar:2.0.206]
	at org.h2.Driver.connect(Driver.java:59) ~[h2-2.0.206.jar:2.0.206]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_345]
	at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[?:1.8.0_345]
```



--
This message was sent by Atlassian Jira
(v8.20.10#820010)