SQLContainer Oracle

Tried a few days without luck. Debug to see the problem is in statement “container = new SQLContainer(tq);” in the following code. F5 step into and noticed “ClassNotFoundException” (without source). I’ve imported jodbc6.jar in web-inf and also added it to the list in Properties->Java Build Path. Really don’t know what class is missing.
eclipse kepler, vaadin 7, tomcat 7

try {
pool = new SimpleJDBCConnectionPool(
“jdbc:oracle:thin:@”, “HR”, “xxxx”

                tq=new TableQuery("JOBS",pool);

container = new SQLContainer(tq);
} catch (Exception e) {
// TODO Auto-generated catch block

You need to use an OracleGenerator (an extra parameter to the constructor of TableQuery).

Thank you Henri!

I’ve used freeformquery instead and it’s working like a charm.