createDataSourceByQuery in WAR deployment

Classic Servoy
1

We are using databaseManager.createDataSourceByQuery() to create an in-memory table for use on a table view form made with solutionModel. This way we can generate a list of records with prefilled checkboxes etc.

This works great in smart client and web client, except when the solution is deployed on a WAR server, then it seems it cannot find the in-memory datasource. Is there any logical explanation for this? Should this be approached differently? Or is it a bug?

var vUri = databaseManager.createDataSourceByQuery('select_members', 'app', vSql, vArgs, -1);

vForm = solutionModel.newForm(vFormName, vUri, null, false, 390, 30);
// *snap create rest of the form

// attach the new foundset to the form
/** @type {JSFoundSet} */
var vSet = databaseManager.getFoundSet(vUri);
vSet.loadAllRecords();
vSet.sort("name asc");

forms[vFormName].foundset.loadRecords(vSet);

See attached JBOSS log. Using Tomcat 7 gives the same problem. Any help would be greatly appreciated :)

jboss_error.txt (6.57 KB)

2

Ruben,

Is the hsqldb.jar jar included in the drivers dir?

Rob

3

Hi Rob,

Sorry it took so long to try this stuff out, but that was the solution indeed! Working like a charm now.

Thanks a lot!