how to use jdbc driver from birt methods

u16kato

I want to update database from birt methods.
But now , ClassNotFound error have occured at line2
I programmed this way.


initialize()
----
importClass(java.sql.DriverManager);

java.lang.Class.forName("oracle.jdbc.OracleDriver").newInstance();

var conn = java.sql.DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:test","system","manager");

var stmt = conn.createStatement();

stmt.executeUpdate("UPDATE HR.EMPLOYEES SET DEPARTMENT_ID = 1 WHERE MANAGER_ID = " + params["param1"]);

stmt.close();
conn.close();

----

I set classpath, but this error occured.


DB:oracle 11g