databaseManager.createDataSourceByQuery issue

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using

databaseManager.createDataSourceByQuery issue

Postby simone.gianti » Wed Aug 21, 2019 3:19 pm

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
simone.gianti
 
Posts: 2
Joined: Wed May 31, 2017 11:41 am

Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: No registered users and 3 guests

cron