#pickerFieldCustom Has anyone run into a problem executing a query rule as

Jin Pheh

Certified Associate Developer

over 9 years ago

#pickerFieldCustom
Has anyone run into a problem executing a query rule as part of the saveInto of a custom picker? I'm receiving an error (pasted below) whenever I try to query for an object as part as part of the saveInto of a picker even when the query rule is static (eg: rule!getSomeObjectByID(2). I have verified that the query works on the same form and that the ID passed from the picker is valid. Note: This error occurs in the interface editor and there are no bind variables in use - ie: there are no database writes taking place at the same time.

18:35:10,438 INFO [stdout] (ajp-/0.0.0.0:8009-12) 2016-03-07 18:35:10,435 [ajp-/0.0.0.0:8009-12] ERROR org.hibernate.transaction.JDBCTransaction - JDBC commit failed
18:35:10,438 INFO [stdout] (ajp-/0.0.0.0:8009-12) java.sql.SQLException: Commit can not be set while enrolled in a transaction

Discussion posts and replies are publicly visible

Parents

0 shailendras593 over 9 years ago

Hi jpheh,

Can you please elaborate what values your custom picker exactly shows? Your query rule must be returning a CDT structure whereas the custom picker only shows single values rather than a dictionary structure. Probably that's the reason, you are running in this issue. You can try saving a particular field of query rule outcome into the custom picker variable. Like a!save(local!customPick,rule!getSomeObjectByID(2).ABC)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 shailendras593 over 9 years ago

Hi jpheh,

Can you please elaborate what values your custom picker exactly shows? Your query rule must be returning a CDT structure whereas the custom picker only shows single values rather than a dictionary structure. Probably that's the reason, you are running in this issue. You can try saving a particular field of query rule outcome into the custom picker variable. Like a!save(local!customPick,rule!getSomeObjectByID(2).ABC)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data