I capture bulk sql on constructor of org.h2.jdbc.JdbcPreparedStatement
JdbcPreparedStatement(JdbcConnection conn, String sql, int id, int
resultSetType, int resultSetConcurrency, boolean closeWithResultSet) {
On Tuesday, June 12, 2012 9:28:44 AM UTC+2, joseaio wrote:
>
> I need some help to find class/method where capture/modify bulk SQL to
> remove some Sybase custom syntax (based on regexp?):
>
> I would like to remove (index index_name ...) after table from/join
> clauses to force use of that index on sybase.
>
> Example:
>
> select *
> from table1 (index table1_index)
> inner join table2 (index table2_index) on ...
> left join table3 (index table3_index) on ...
> where ...
>
> The complete syntax to force index on sybase is:
>
> http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/4799;pt=4727/*
>
>
> (index <index_name> [parallel [<degree_of_parallelism>]]
> [prefetch <size>] [lru | mru])
>
> please, note mandatory parenthesis.
>
> Thank you for any help
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/hCXg2cFCt8MJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
