Hi everyone,
I am dealing with a really, really annoying problem that's been bugging me for quite some time now.
My goal is to create a desktop application using
Java's EmbeddedDriver (not the ClientDriver).
Problem
Whenever I try to retrieve some records using a SELECT-statement, I get the following error (right click -> Open image in new tab to maximize):
Exception:
DBConnect.java
Database.java
Pet.java
Some things that I have already tried doing
I know that whenever I do not provide a user and password, NetBeans defaults the SCHEMA to "APP".
I have tried not providing a user and password, and it game the exact Exception.I have tried creating the SQL tables manually and programmatically, both have yielded the same Exception.
Some things that DO work
Strange enough, I am able to retrieve data from the SCHEMA "SYS" (so table " SYS.SYSALIASES") with success, but any other SCHEMA does not work and gives the same Exception.