2019-05-22 12:05:00
Topic starter
Notifications
Clear all
Developer Network Q&A
2
Posts
2
Users
1
Reactions
2,623
Views
1
Using the SQL Explorer plugin of the ONE SDK, a developer gets the following error message when running a select * query on a database table:
Invalid column type: getString not
implemented for class
"oracle.jdbc.driver.T4CBlobAssessor"
The developer did follow these steps to connect the SQL Explorer plugin to the proper JDBC jar file:
Window -> Preferences -> SQL Explorer
-> JDBC Drivers -> Oracle Thin Driver -> Edit -> Extra Class Path -> Add
C:oraclexeapporacleproduct11.2.0serverjdbclibojdbc6.jarClick OK.
What else should be done to resolve the "Invalid column type" error message?
Thank you!
1 Answer
0
2019-05-22 12:05:00
Looks like that particular table may have blobs on it, and that particular version of the driver can't generically convert that to string.
They should select specific columns instead.
Matt Nutsch Topic starter
2019-05-22 12:05:00
This was the problem. Querying specific columns (which were not blob formatted) runs OK.
Running the original query through a stand alone database tool like DBeaver also worked as an alternative.
