Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using the JAR in DBeaver #1

Open
pbel78 opened this issue Oct 4, 2018 · 1 comment
Open

Using the JAR in DBeaver #1

pbel78 opened this issue Oct 4, 2018 · 1 comment

Comments

@pbel78
Copy link

pbel78 commented Oct 4, 2018

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
Copy link
Owner

rondunn commented Oct 10, 2020

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants