Re: [eclipselink-dev] Support MySQL51 User Functions

[Tom Ware <tom.ware@xxxxxxxxxx>]

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