Why am I unable to retrieve any rows when using the 64-bit Oracle JDBC driver in the Database Toolbox 3.7 (R2010a)?

I am connecting to an Oracle database using a 64-bit Oracle JDBC driver. I am able to establish the connection successfully but do not see any rows returned from the table when I execute a select query.

Answer 1

[Murugavel Sivagnanam]

There is an issue with 64-bit Oracle drivers in that they are case-sensitive. When executing your query, make sure the case of the table name and the attributes is correct.