Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Support for literal serialization #552
Support for literal serialization into the final query or statement. This means that literals such as numbers, strings and chars are not handled via prepared statement parameters, but serialized directly into the query or statement.
Supported using SQL 92 standard and JDBC escape syntax (Derby).
We have a customer that requests this feature. It won't be the default, but can be enabled if literal serialization is desired. This feature is also useful for cases where Querydsl acts as the SQL query builder.
The specific reason is that for some databases (e.g. Teradata and Virtuoso) usage of literals helps in the query optimization.
Using literals instead of prepared statement is also useful on Oracle.
One workaround, to still use bind parameter, is to explicitly cast it to the correct datatype.