Page 1 of 1

databaseManager.createDataSourceByQuery issue

PostPosted: Wed Aug 21, 2019 3:19 pm
by simone.gianti
Hello,
I've just installed Servoy Developer version 2019.6.2.3504, and now I've a problem with databaseManager.createDataSourceByQuery(...).
Here you are a simple example.
1) create a new smart client solution with a form.
2) create a button that launch this method:

function onAction(event) {

databaseManager.startTransaction()
var uri = databaseManager.createDataSourceByQuery('query_number_one', 'svy_framework', "select 'hello' pippo", null, 999,[JSColumn.TEXT])
databaseManager.commitTransaction()
}


At this point, I get the following error:
ERROR com.servoy.j2db.util.Debug - Error executing sql: insert into "TEMP_1_22679A2E-929C-4A6C-B4D0-E4A608C0EF9A" (pippo) values (?) with params: ['hello' ,type: java.lang.String] org.postgresql.util.PSQLException: ERROR: relation "TEMP_1_22679A2E-929C-4A6C-B4D0-E4A608C0EF9A" does not exist


No problem if I don't use a transaction.

Installation details:
Servoy Developer version 2019.6.2.3504
macOS Mojave Version 10.14
java.runtime.name=OpenJDK Runtime Environment
java.runtime.version=12.0.1+12

Thank you.
Simone