SQLContainer Oracle

General
1

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.
Environent:
eclipse kepler, vaadin 7, tomcat 7

try {
pool = new SimpleJDBCConnectionPool(
“oracle.jdbc.OracleDriver”,
“jdbc:oracle:thin:@127.0.0.1:1521:XE”, “HR”, “xxxx”
);

                tq=new TableQuery("JOBS",pool);
                tq.setVersionColumn("JOB_ID");
    [size=4]
         [b]

container = new SQLContainer(tq);
[/b]
[/size]
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

2

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

3

Thank you Henri!

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