com.goldencode.p2j.persist.dialect

Class SQLServerHelper

java.lang.Object

com.goldencode.p2j.persist.dialect.SQLServerHelper

public final class SQLServerHelper
extends java.lang.Object

Helper class which provides Microsoft SQL Server 2012 - specific services:

• gather HQL/SQL functions
• decorate them to avoid the overloading restriction of the server
• create the udf function/alias that maps to CLR assembly

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	P2J2CLR The name of the assembly that maps SQL functions and datatypes to CLR.

Constructor Summary

Constructors

Modifier	Constructor and Description
private	SQLServerHelper() Private constructor.

Method Summary

Modifier and Type	Method and Description
private static java.util.List<java.lang.String>	getFunctionAliases(Database database, java.util.List<java.lang.reflect.Method> funcs, boolean overload, boolean register) Get function aliases for the given list of static methods, optionally making the alias names unique by appending parameter type decorations.
static java.util.List<java.lang.String>	getPrepareStatements(Database database) Get a list of database prepare DDL statements.
private static char	getSqlDecoration(java.lang.String javaType) Returns the parameter decoration for fixing the function overloading constraint in MS SQL Server.
private static java.lang.String	getSqlType(java.lang.String javaType) Returns the MS SQL Server datatype associated with the java type.
static void	preparePermanentDatabase(Database database) Register the function aliases with the HQL preprocessor, for the permanent database.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

P2J2CLR

private static final java.lang.String P2J2CLR

The name of the assembly that maps SQL functions and datatypes to CLR.

See Also:

Constant Field Values

Constructor Detail

SQLServerHelper

private SQLServerHelper()

Private constructor. All access to this class is via static methods.

Method Detail

preparePermanentDatabase

public static void preparePermanentDatabase(Database database)

Register the function aliases with the HQL preprocessor, for the permanent database.

Parameters:

database - Database to prepare.

getPrepareStatements

public static java.util.List<java.lang.String> getPrepareStatements(Database database)

Get a list of database prepare DDL statements.

Parameters:

database - Database to prepare.

Returns:

the list of DDL statements.

getFunctionAliases

private static java.util.List<java.lang.String> getFunctionAliases(Database database,
                                                                   java.util.List<java.lang.reflect.Method> funcs,
                                                                   boolean overload,
                                                                   boolean register)

Get function aliases for the given list of static methods, optionally making the alias names unique by appending parameter type decorations.

Parameters:

database - Database in which to create aliases.

funcs - List of static methods for which function aliases should be created.

overload - true to create unique function names for each overloaded method.

register - true if the function should be registered with the FQLPreprocessor.

Returns:

the list of function aliases.

getSqlType

private static java.lang.String getSqlType(java.lang.String javaType)

Returns the MS SQL Server datatype associated with the java type.

Parameters:

javaType - The java type (full name).

Returns:

The MS SQL Server datatype mapped by javaType. If javaType is invalid, null is returned.

getSqlDecoration

private static char getSqlDecoration(java.lang.String javaType)

Returns the parameter decoration for fixing the function overloading constraint in MS SQL Server.

Parameters:

javaType - The java type (full name).

Returns:

a character for decorating the SQL function.