Accessing remote Excel data sheets through JDBC connects successfully in case of wrong credential

Asked Sep 06 '17 at 07:43

Active Sep 06 '17 at 13:21

Viewed 110 times

I am connecting to remote excel file using jdbc driver:

Class.forName(JDBC_DRIVER);
        System.out.println("Connecting to database...");
        conn = DriverManager.getConnection("jdbc:excel:smb://username:pass@host/path/Data.xlsx");
        System.out.println("Connected to " + "url" + " successfully");

It works fine, but when I enter wrong username/password it connects successfully too. How should I implement it to get exception when connecting with wrong credentials?

edited Sep 06 '17 at 13:21

Mark Rotteveel

100,966
191
140
197

asked Sep 06 '17 at 07:43

Lusi

1

Which driver are you using, does it even need a username and password? – Mark Rotteveel Sep 06 '17 at 09:18
I am using com.hxtt.sql.excel.ExcelDriver driver and Excel_JDBC30.jar. For smb connection I am using jcifs-1.3.17.jar – Lusi Sep 06 '17 at 13:18

Accessing remote Excel data sheets through JDBC connects successfully in case of wrong credential

0 Answers0