[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-dev] Support MySQL51 User Functions
|
Some comments:
- We should run all the available MySQL compatible testing
- Do we know if MySQL 5 is closer to MySQL 5.1 or MySQL 4?
- Have you done a complete analysis of the platform and the available
functionality, or is this a fix for just one issue you happen to have noticed?
Mike Norman wrote:
I have created a new database platform in order to support User
Functions for MySQL 5.1.
All that was required was surrounding '{ }' brackets and a slightly
different order for the CALL clause:
public class MySQL51Platform extends MySQL4Platform {
@Override
public boolean supportsStoredFunctions() {
return true;
}
@Override
public String buildProcedureCallString(StoredProcedureCall call,
AbstractSession session) {
return "{ " + super.buildProcedureCallString(call, session);
}
@Override
public String getFunctionCallHeader() {
return "? " + getAssignmentString() + getProcedureCallHeader();
// different order - CALL clause ^^^ comes AFTER assignment
operator
}
@Override
public String getProcedureCallTail() {
return " }"; // case-sensitive
}
}
I have a DBWS test case working, but some more extensive testing is
likely required. Any problem checking
this in for M8?
--
Oracle Email Signature Logo
Mike Norman | Principal Software Designer | 613.288.4638
Oracle Server Technologies | TopLink Product
45 O'Connor Street, Suite 400 | Ottawa, ON K1P 1A4 | (fax) 613.238.2818
------------------------------------------------------------------------
_______________________________________________
eclipselink-dev mailing list
eclipselink-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-dev