search

rondunn / JDBCExcel

Read-only JDBC driver for Microsoft Excel .xlsx files
16 stars 5 forks source link

Using the JAR in DBeaver #1

Open pbel78 opened 5 years ago

pbel78 commented 5 years ago

Hi. We have compiled the JAR and configure in DBeaver using jdbc conncection string: JDBCExcel://server={SERVER};database={DATABASE} where I used C:\ as path and test.xlsx as Excel file. Also we configured the class as JDBCExcel.Driver (but tried with same behaviour the JDBCExcel.BaseDriver). DBeaver connects now to the file and shows as well the 2 tabs which are in file correctly. But reading columns already fails (but as I understand is not supported). Problem is now if doing SELECT "A" from blatt (where blatt is the name of my tab) or SELECT a from blatt I get the error: SQL error: method execute not supported. Test file is attached. Is DBeaver calling some not implemented function? Regards Petr test.xlsx

rondunn commented 3 years ago

You shouldn't be calling any of the "Base" classes, the implementation methods are in the classes without the "Base" prefix.

I think I understand the error, but can you explain more about your intentions? This driver is intended to be read-only, and since you're using DBeaver I want to make sure you are not intending to modify the file once loaded.