User bio
404 bio not found
Member since Apr 14, 2022
Posts:
Replies:
If auditing is enabled, you can see the query without the actual parameter values.
To copy the query to the SQL query tool, the query will also have to be cleaned of garbage.
For example, there is the following query
select * from del.a where id<3
From SMP:
Event: DynamicStatementQuery Event Data: SELECT * FROM del . a WHERE id < ?
From DbVisualizer:
Event: XDBCStatementQuery Event Data: SELECT * INTO :i%%col1, :i%%col2, :i%%col3 FROM del . a WHERE id < :%qpar(1)
Since you used the migration wizard, I assume that the problem is due to the primary key ID and the indexes on it.
Can you use the wizard to create a test table with only two fields, ID and row_status, and post the source code of the generated class here?
And more: how many records are there in the table?
Certifications & Credly badges:
Vitaliy has no Certifications & Credly badges yet.
Global Masters badges:
Vitaliy has no Global Masters badges yet.
Followers:
Following:
Vitaliy has not followed anybody yet.
@Evgeny Shvarov
Unfortunately, I have not yet found a documented and [Not Internal] way out of the box to see not only the text of the request, but also the values of its input parameters.
PS: take a look at the methods of the %SYSTEM.SQL.xDBC class.
Here is an example of the log for the query above (from DbVisualizer):
SQL text (raw from client): 1 lines line 1: SELECT * FROM del . a WHERE id < :%qpar(1) Var Types: Parameter 1: Constant of type INTEGER INPUT params: %qpar(1) = 3