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.
- create a new smart client solution with a form.
- 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