Author: gbadner Date: 2009-02-12 03:36:09 -0500 (Thu, 12 Feb 2009) New Revision: 15964 Modified: core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/AbstractTransactSQLDialect.java core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java Log: JBPAPP-1563 HHH-3640 - Some standard SQL functions are not implemented in Sybase (correction) Modified: core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/AbstractTransactSQLDialect.java =================================================================== --- core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/AbstractTransactSQLDialect.java 2009-02-12 08:32:17 UTC (rev 15963) +++ core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/AbstractTransactSQLDialect.java 2009-02-12 08:36:09 UTC (rev 15964) @@ -100,9 +100,6 @@ registerFunction( "trim", new SQLFunctionTemplate( Hibernate.STRING, "ltrim(rtrim(?1))") ); registerFunction( "locate", new CharIndexFunction() ); - registerFunction( "mod", new SQLFunctionTemplate( Hibernate.INTEGER, "?1 % ?2" ) ); - registerFunction( "bit_length", new SQLFunctionTemplate( Hibernate.INTEGER, "datalength(?1) * 8" ) ); - getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, NO_BATCH); } Modified: core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java =================================================================== --- core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java 2009-02-12 08:32:17 UTC (rev 15963) +++ core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java 2009-02-12 08:36:09 UTC (rev 15964) @@ -26,6 +26,9 @@ registerFunction( "locate", new StandardSQLFunction("charindex", Hibernate.INTEGER) ); registerFunction( "extract", new SQLFunctionTemplate( Hibernate.INTEGER, "datepart(?1, ?3)" ) ); + registerFunction( "mod", new SQLFunctionTemplate( Hibernate.INTEGER, "?1 % ?2" ) ); + registerFunction( "bit_length", new SQLFunctionTemplate( Hibernate.INTEGER, "datalength(?1) * 8" ) ); + registerFunction( "trim", new AnsiTrimEmulationFunction() ); registerKeyword("top");