SQL Trace?

Classic Servoy
1

Hi Folks:

I had some problems with the SQL being generated by Servoy a few versions ago, and someone (maybe Jan) had given me instructions on how to see the SQL going to the server from Servoy.

Can someone tell me how to do that again?

I’m having a problem with Servoy creating Users in my Oracle based repository. I would like to verify that Servoy is actually sending the correct data.

Thanks,
Lee

2

You can see the SQL that servoy generates by starting with the option -DSTACKTRACE=true, however that will not help in this case as repository sql is never displayed. Did you check that your schemaname is filled in in your connection settings?

3

jaleman:
You can see the SQL that servoy generates by starting with the option -DSTACKTRACE=true, however that will not help in this case as repository sql is never displayed. Did you check that your schemaname is filled in in your connection settings?

Yes Jan, I did.

The Schema is fine, and based on the error, I don’t believe that’s where the problem is as it is obviously hitting the right table and schema. It’s missing data in the Insert/Update command.

Regards,
Lee