I'm searching an easy way to query a given datasource (defined in) from within a flow (javascript). Not using an ORM framework but even plain JDBC.

Have tried to use org.apache.cocoon.components.flow.javascript.ScriptableConnection:

importPackage(Packages.org.apache.cocoon.components.flow.javascript.ScriptableConnection); var db = Database.getConnection("mydatasource");
   var queryVal = cocoon.parameters["rid"];
   var startRow = 0;
   var maxRows = 100;

row = db.query("select * from report_parameter_map where report_id = ?", queryVal, startRow, maxRows);
    print (row.rowCount);

but get : "'Database' is not defined" ?

Is there a simpler way to query a given datasource from within a flow (javascript)?


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to