java.sql.SQLException: Invalid Oracle URL specified for Java8 using oracle driver

Question

i want to run sql queries on Microsoft excel, so that i can fetch any row or any column based on the sql query. Below is the code which i have written

Connection con = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:Driver={Microsoft Excel Driver(*.xls)};DBQ="+path+"; ReadOnly=0");`

// Here path is the path to the excel file in my local.

When i run this i am getting invalid oracle URL specified error. I have a doubt on the URL format that i need to specify for querying excel sheets. Is there any other way to read excel sheet using sql queries without using DSN.

java.sql.SQLException: Invalid Oracle URL specified
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:191)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:287)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:550)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)

As per my knowledge JDBC driver is not supported by Java8. Hence i am using oracle driver. By using this simply i can query the excel and get the specific cell value. — user3654024
– user3654024, Commented Aug 17, 2016 at 11:41
The Oracle driver can only connect to the Oracle database. Why do you even think this would work? — Mark Rotteveel
– Mark Rotteveel, Commented Aug 18, 2016 at 10:12

Community · Accepted Answer · 2017-05-23 10:28:39Z

2

See Connecting to excel sheet using jdbc without specifying DSN to Excel sheet

You certainly don't want to use the Oracle driver for this.

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered Aug 17, 2016 at 11:12

Piotr Wilkin

3,52112 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java.sql.SQLException: Invalid Oracle URL specified for Java8 using oracle driver

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related