JDBC Driver DatabaseMetaData getNumericFunctions() returns POWER instead of POW.
The DatabaseMetaData method should return accurate information, about the extra SQL commands that FileMaker supports.
POWER should actually be POW.
OR, You should change your none standard POW command to POWER.
Query the JDBC DatabaseMetaData function:
-- create your connection
Connection conn = ???
DatabaseMetaData dmd = conn.getMetaData();
String sNumericFunctions = dmd.getNumericFunctions();
String arrParts = sNumericFunctions.split( Comma );
Sorry for the late response!
I was able to confirm the inconsistency between the documentation and the getNumericFuntions result. I've forwarded your post to our Development and Quality Assurance departments for further investigation. Thank you!