SQL formatted incorrectly in regards to quoting for Oracle9i
------------------------------------------------------------
Key: OJB-130
URL: https://issues.apache.org/jira/browse/OJB-130
Project: OJB
Issue Type: Bug
Components: RDBMS platform-specific support
Affects Versions: 1.0.5
Environment: OJB 1.0.X_RELEASE, Oracle 10g
Reporter: Donald Lyon
Fix For: 1.0.5
The default beahvior for quoted values for attributes uses double quotes. This
is causing incorrect SQL to be generated for Oracle, which expects single
quotes. For example, we ran into this issue having an order by criteria:
query.addOrderByAscending("dateField","to_char(dateField,'ddd'");
The method, PlatformDefaultImpl.getQuotedName() replaces the single quotes with
double quotes.
I believe the solution to this is to override the method in
PlatformOracle9iImpl to use single quotes:
/**
* @return a quoted name. ie "name" or [name]
*/
protected String getQuotedName(String aString)
{
return '"' + aString + '"';
}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
