com.groiss.store

Class StoreUtil

java.lang.Object

com.groiss.store.StoreUtil

public class StoreUtil
extends java.lang.Object

Utilities for store

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	MISSING_VALUE

Method Summary

Methods

Modifier and Type	Method and Description
static void	addEventHandler(PersistentEventHandler<? extends Persistent> h, java.lang.Class<?>... classes) Add an event handler for the passed persistent classes.
static Persistent	base(Persistent o) Return the base object of a Persistent o.
static void	cleanDbFieldV()
static int	dbAttrPos(Persistent o, java.lang.String fieldname)
static java.lang.String	dbAttrs(Persistent o)
static java.lang.String	dbAttrs(Persistent o, java.lang.String prefix)
static int	dbAttrsCount(Persistent o)
static java.util.List<java.lang.reflect.Field>	dbFields(Persistent o) Returns the fields of the object which have corresponding fields in the database.
static java.util.List<java.lang.reflect.Field>	dbMultiValuedFields(Persistent o) Returns the multivalued fields (Lists, Maps, Sets) of the object which have corresponding fields in the database.
static void	executeScript(java.lang.String content, java.io.PrintWriter res)
static void	executeScript(java.lang.String content, java.io.PrintWriter res, boolean tryAvoid)
static void	executeSQLFile(java.lang.String commands, java.io.PrintWriter res)
static int	executeSQLFile(java.lang.String commands, java.io.PrintWriter res, boolean tryAvoid)
static boolean	existsColumn(java.lang.String tablename, java.lang.String columnname) Returns true if the passed table/view exists in the current db-schema and the passed column exists in this table/view.
static boolean	existsIndex(java.lang.String tablename, java.lang.String indexname) Returns true if the passed index exists in the current db-schema for the passed table.
static boolean	existsObject(java.util.Set<java.lang.String> objectNameSet, java.lang.String name)
static boolean	existsTable(java.lang.String tablename) Returns true if the passed table exists in the current db-schema.
static boolean	existsView(java.lang.String viewname) Returns true if the passed view exists in the current db-schema.
static java.math.BigDecimal	getBigDecimal(java.sql.ResultSet rs, int columnIndex) Get a BigDecimal from a column of the current row of a ResultSet.
static java.math.BigDecimal	getBigDecimal(java.sql.ResultSet rs, java.lang.String columnName) Get a BigDecimal from a column of the current row of a ResultSet.
static byte[]	getBlob(java.sql.ResultSet rs, int columnIndex) Get a byte array from a Blob column of the current row of a ResultSet.
static java.io.InputStream	getBlobStream(java.sql.ResultSet rs, int columnIndex) Get a String from a Blob column of the current row of a ResultSet.
static java.lang.String	getBlobString(java.sql.ResultSet rs, int columnIndex) Get a String from a Blob column of the current row of a ResultSet.
static java.lang.String	getClob(java.sql.ResultSet rs, int columnIndex) Get a String from a Clob column of the current row of a ResultSet.
static byte[]	getClobBytes(java.sql.ResultSet rs, int columnIndex) Get a byte array from a Clob column of the current row of a ResultSet.
static java.util.Date	getDate(java.sql.ResultSet rs, int columnIndex) Get a Date from a column of the current row of a ResultSet.
static java.util.Date	getDate(java.sql.ResultSet rs, java.lang.String columnName) Get a Date from a column of the current row of a ResultSet.
static Store	getDefaultStore()
static <T extends Persistent> java.util.List<PersistentEventHandler<T>>	getEventHandlers(java.lang.Class<T> c) Get a List of PersistentEventHandler for a specified class c.
static java.util.List<java.util.List<java.lang.Object>>	getExportedKeys(java.lang.String tablename) Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
static int	getFetchSize()
static java.lang.reflect.Field	getField(Persistent o, java.lang.String fieldname)
static java.lang.Object	getFromRS(java.sql.ResultSet rs, int sqlType, int i)
static java.lang.Object	getFromRS(java.sql.ResultSet rs, java.sql.ResultSetMetaData metaData, int i)
static java.util.List<java.util.List<java.lang.Object>>	getImportedKeys(java.lang.String tablename) Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).
static java.util.Map<java.lang.String,java.lang.String>	getIndexInfo(java.lang.String tablename)
static int	getMaxConstraintIndexNameLength()
static int	getMaxTableNameLength()
static Persistent	getNewInstance(java.lang.Class<?> c) Create a new instance of c. c can be an interface, then mapInterface(Class) is used to determine the appropriate implementation class.
static Persistent	getNewInstance(java.lang.String className) Create a new instance of a class c specified via the className .
static <T extends Persistent> T	getObject(java.lang.Object obj) Returns the Persistent, if obj is a string like: <classname>:<oid>
static java.sql.ResultSetMetaData	getTableDefinition(java.lang.Class<? extends Persistent> c)
static java.util.Set<java.lang.String>	getTableNames(java.lang.String tableNamePattern) Returns a set of names of tables conforming to the name pattern in the current db-schema.
static java.util.Set<java.lang.String>	getViewNames(java.lang.String viewNamePattern) Returns a set of names of views conforming to the name pattern in the current db-schema.
static boolean	hasClassAttribute(java.lang.Class<?> c)
static boolean	hasDbField(java.lang.Class<?> c, java.lang.String fieldName) Returns true, if the Class has a field with the given name which corresponds to a column in the database.
static boolean	isSingleInterface(java.lang.Class<?> c) Determines if an interface c hides a single implementation (e.g. com.groiss.org.User covers com.dec.avw.core.User)
static boolean	isSystemOid(long oid) Returns true if the given oid is the oid of a system object (>0, <1000).
static <P> java.lang.Class<Persistent>	mapInterface(java.lang.Class<P> c) Get the Persistent class which is implemented by the a Class c.
static java.lang.Class<Persistent>	mapInterface(java.lang.String className) Get the Persistent class which is implemented by a class with the given classname.
static java.lang.String	mapInterfaceToClassName(java.lang.String className) Get the name of the Persistent class which is implemented by a class with the given classname.
static double	noNaN(double d)
static float	noNaN(float f)
static java.util.List<java.lang.String>	oidList(java.util.List<?> l, int splitsize) Creates a list of strings of oids from a list of objects.
static void	removeEventHandler(PersistentEventHandler<?> peh) Remove a PersistentEventHandler.
static void	setBigDecimal(java.sql.PreparedStatement stmt, int pos, java.math.BigDecimal value) Get a parameter in a PreparedStatement from a BigDecimal.
static void	setBindVars(java.sql.PreparedStatement stmt, java.lang.Object[] bindVars) Set the bind variables of a prepared statement based on an object array.
static void	setFetchsize(int rows)
static void	setFieldToValue(Persistent o, java.lang.reflect.Field ff, java.lang.Object val, java.util.Map<java.lang.String,? extends java.lang.Object> req) Set a field of an object
static boolean	setFieldToValue(Persistent o, java.lang.reflect.Field ff, java.lang.Object value, java.util.Map<java.lang.String,? extends java.lang.Object> req, boolean dontLocalizeNumbers) Set a field of an object
static void	setFromRS(Persistent o, java.sql.ResultSet rs) Set the members of the persistent object to the corresponding values of the current row of the result set.
static void	setFromRS(Persistent o, java.sql.ResultSet rs, boolean addToCache) Set the members of the persistent object to the corresponding values of the current row of the result set.
static void	setFromRSByName(Persistent o, java.sql.ResultSet rs) Set the members of the persistent object to the corresponding values of the current row of the result set.
static void	setFromRSByName(Persistent o, java.sql.ResultSet rs, boolean addToCache) Set the members of the persistent object to the corresponding values of the current row of the result set.
static boolean	setNumber(Persistent o, java.lang.reflect.Field ff, java.lang.String val, boolean dontLocalizeNumbers) Set a field to a numeric value, the value is given as String.
static void	setValues(Persistent o, java.util.Map<java.lang.String,? extends java.lang.Object> req)
static void	setValues(Persistent o, java.util.Map<java.lang.String,? extends java.lang.Object> req, java.util.Map<java.lang.String,java.lang.Short> fieldmodes)
static boolean	setValues2(Persistent o, java.util.Map<java.lang.String,? extends java.lang.Object> req, java.util.Map<java.lang.String,java.lang.Short> fieldmodes, boolean dontLocalizeNumbers)
static <T extends java.lang.Enum<T>> T	toEnum(java.lang.Class<T> clazz, java.lang.Object value) Maps a value to an instance of an Enum class
static org.json.JSONObject	toJson(Persistent pers) Convert a persistent to JSON
static org.json.JSONObject	toJsonAsReference(Persistent pers)
static java.util.Map<java.lang.String,java.lang.Object>	toMap(Persistent pers) Convert a persistent to a Map
static java.util.Map<java.lang.String,java.lang.Object>	toMapAsReference(Persistent pers)
static java.lang.String	toNative(java.lang.String arg)
static java.lang.String	toNativeScript(java.lang.String arg)
static java.lang.String	toString(Persistent obj) Generates a String representation to identify a persistent object.
static java.lang.String	transformCase(java.sql.DatabaseMetaData dbmd, java.lang.String id)
static java.lang.String	transformCase(java.lang.String id)
static ApplicationException	wrapSQLException(int errNum, java.lang.Throwable e) Wraps an exception ; tries to discriminate between sql constraint violations and other exceptions when sqlexception && sqlstate=23* ==> integrity coinstraint, (appex 478,e) when sqlexception && sqlstate!

Methods inherited from class java.lang.Object

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

Field Detail

MISSING_VALUE

public static final java.lang.String MISSING_VALUE

See Also:

Constant Field Values

Method Detail

getNewInstance

public static Persistent getNewInstance(java.lang.Class<?> c)
                                 throws java.lang.Exception

Create a new instance of c. c can be an interface, then mapInterface(Class) is used to determine the appropriate implementation class.

Parameters:

c - the class or interface

Returns:

an instance of c

Throws:

java.lang.Exception

getNewInstance

public static Persistent getNewInstance(java.lang.String className)
                                 throws java.lang.Exception

Create a new instance of a class c specified via the className . c can be an interface, then mapInterface(String) is used to determine the appropriate implementation class.

Parameters:

className - the name of the class or interface

Returns:

an instance of c

Throws:

java.lang.Exception

base

public static Persistent base(Persistent o)

Return the base object of a Persistent o. If o ist an instance of View, its base object is returned, otherwise, o is returned.

Parameters:

o - the View Object

Returns:

the base object of o.

dbFields

public static java.util.List<java.lang.reflect.Field> dbFields(Persistent o)

Returns the fields of the object which have corresponding fields in the database.

Returns:

a List containing the persistent fields of the class.

hasDbField

public static boolean hasDbField(java.lang.Class<?> c,
                 java.lang.String fieldName)

Returns true, if the Class has a field with the given name which corresponds to a column in the database.

Returns:

true, if there is such a field

dbMultiValuedFields

public static java.util.List<java.lang.reflect.Field> dbMultiValuedFields(Persistent o)

Returns the multivalued fields (Lists, Maps, Sets) of the object which have corresponding fields in the database.

Returns:

a List containing the persistent multivalued fields of the class.

cleanDbFieldV

public static void cleanDbFieldV()

dbAttrs

public static java.lang.String dbAttrs(Persistent o,
                       java.lang.String prefix)

dbAttrsCount

public static int dbAttrsCount(Persistent o)

dbAttrs

public static java.lang.String dbAttrs(Persistent o)

hasClassAttribute

public static boolean hasClassAttribute(java.lang.Class<?> c)

dbAttrPos

public static int dbAttrPos(Persistent o,
            java.lang.String fieldname)

setValues

public static void setValues(Persistent o,
             java.util.Map<java.lang.String,? extends java.lang.Object> req)

setValues

public static void setValues(Persistent o,
             java.util.Map<java.lang.String,? extends java.lang.Object> req,
             java.util.Map<java.lang.String,java.lang.Short> fieldmodes)

setValues2

public static boolean setValues2(Persistent o,
                 java.util.Map<java.lang.String,? extends java.lang.Object> req,
                 java.util.Map<java.lang.String,java.lang.Short> fieldmodes,
                 boolean dontLocalizeNumbers)

setNumber

public static boolean setNumber(Persistent o,
                java.lang.reflect.Field ff,
                java.lang.String val,
                boolean dontLocalizeNumbers)
                         throws java.lang.Exception

Set a field to a numeric value, the value is given as String.

Parameters:

o - the target object

ff - the field which reveices the value

val - the value

dontLocalizeNumbers - if true, don't use the localized number formatter

Returns:

true if the field is numeric

Throws:

java.lang.Exception

setFieldToValue

public static void setFieldToValue(Persistent o,
                   java.lang.reflect.Field ff,
                   java.lang.Object val,
                   java.util.Map<java.lang.String,? extends java.lang.Object> req)
                            throws java.lang.Exception

Set a field of an object

Parameters:

o -

ff -

val -

req -

Throws:

java.lang.Exception

setFieldToValue

public static boolean setFieldToValue(Persistent o,
                      java.lang.reflect.Field ff,
                      java.lang.Object value,
                      java.util.Map<java.lang.String,? extends java.lang.Object> req,
                      boolean dontLocalizeNumbers)
                               throws java.lang.Exception

Set a field of an object

Parameters:

o - the object to fill

ff - the object's field

value - the value to assign

req - all other values

dontLocalizeNumbers - false if value may be in a locale-dependent format

Throws:

java.lang.Exception

setFromRSByName

public static void setFromRSByName(Persistent o,
                   java.sql.ResultSet rs)
                            throws java.lang.Exception

Set the members of the persistent object to the corresponding values of the current row of the result set. The object is added to the Thread-Cache. The method uses a conventional metadata based approach to determine the position and data types of the fields of the ResultSet and is somewhat slower than setFromRS.

Parameters:

o - The persistent object

rs - the ResultSet

Throws:

java.lang.Exception

setFromRSByName

public static void setFromRSByName(Persistent o,
                   java.sql.ResultSet rs,
                   boolean addToCache)
                            throws java.lang.Exception

Set the members of the persistent object to the corresponding values of the current row of the result set. The method uses a conventional metadata based approach to determine the position and data types of the fields of the ResultSet and is somewhat slower than setFromRS.

Parameters:

o - The persistent object

rs - the ResultSet

addToCache - if true, the object is added to the Thread-Cache.

Throws:

java.lang.Exception

setFromRS

public static void setFromRS(Persistent o,
             java.sql.ResultSet rs)
                      throws java.lang.Exception

Set the members of the persistent object to the corresponding values of the current row of the result set. The object is added to the Thread-Cache. The method uses a fast approach to determine the position and data types of the fields of the ResultSet.

Parameters:

o - The persistent object

rs - the ResultSet

Throws:

java.lang.Exception

setFromRS

public static void setFromRS(Persistent o,
             java.sql.ResultSet rs,
             boolean addToCache)
                      throws java.lang.Exception

Set the members of the persistent object to the corresponding values of the current row of the result set. The method uses a fast approach to determine the position and data types of the fields of the ResultSet.

Parameters:

o - The persistent object

rs - the ResultSet

addToCache - if true, the object is added to the Thread-Cache.

Throws:

java.lang.Exception

getFromRS

public static java.lang.Object getFromRS(java.sql.ResultSet rs,
                         java.sql.ResultSetMetaData metaData,
                         int i)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

getFromRS

public static java.lang.Object getFromRS(java.sql.ResultSet rs,
                         int sqlType,
                         int i)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

getField

public static java.lang.reflect.Field getField(Persistent o,
                               java.lang.String fieldname)

toNativeScript

public static java.lang.String toNativeScript(java.lang.String arg)

toNative

public static java.lang.String toNative(java.lang.String arg)

addEventHandler

public static void addEventHandler(PersistentEventHandler<? extends Persistent> h,
                   java.lang.Class<?>... classes)

Add an event handler for the passed persistent classes. Each class must implement Persistent otherwise no registration for that class will be performed and an error will be logged.

Parameters:

h - the PersistentEventHandler to be called when instances of the classes are manipulated via the store.

classes - the classes for which the handler will be invoked.

removeEventHandler

public static void removeEventHandler(PersistentEventHandler<?> peh)

Remove a PersistentEventHandler. All handlers with the same class as peh get removed.

Parameters:

peh - an instance of the handler to be removed

getEventHandlers

public static <T extends Persistent> java.util.List<PersistentEventHandler<T>> getEventHandlers(java.lang.Class<T> c)

Get a List of PersistentEventHandler for a specified class c.

Parameters:

c - the class

Returns:

a list of PersistentEventHandlers for c

getDate

public static java.util.Date getDate(java.sql.ResultSet rs,
                     java.lang.String columnName)
                              throws java.sql.SQLException

Get a Date from a column of the current row of a ResultSet. Deals with DATE and TIMESTAMP SQL datatypes.

Parameters:

rs - the ResultSet

columnName - the name of the column

Returns:

the date

Throws:

java.sql.SQLException

getDate

public static java.util.Date getDate(java.sql.ResultSet rs,
                     int columnIndex)
                              throws java.sql.SQLException

Get a Date from a column of the current row of a ResultSet. Deals with DATE and TIMESTAMP SQL datatypes.

Parameters:

rs - the ResultSet

columnIndex - the index of the column

Returns:

the date

Throws:

java.sql.SQLException

getBigDecimal

public static java.math.BigDecimal getBigDecimal(java.sql.ResultSet rs,
                                 java.lang.String columnName)
                                          throws java.sql.SQLException

Get a BigDecimal from a column of the current row of a ResultSet. Masks differences in RDBMS implementations.

Parameters:

rs - the ResultSet

columnName - the name of the column

Returns:

the BigDecimal

Throws:

java.sql.SQLException

getBigDecimal

public static java.math.BigDecimal getBigDecimal(java.sql.ResultSet rs,
                                 int columnIndex)
                                          throws java.sql.SQLException

Get a BigDecimal from a column of the current row of a ResultSet. Masks differences in RDBMS implementations.

Parameters:

rs - the ResultSet

columnIndex - the index of the column

Returns:

the BigDecimal

Throws:

java.sql.SQLException

setBigDecimal

public static void setBigDecimal(java.sql.PreparedStatement stmt,
                 int pos,
                 java.math.BigDecimal value)
                          throws java.sql.SQLException

Get a parameter in a PreparedStatement from a BigDecimal. Masks differences in RDBMS implementations.

Parameters:

stmt - the PreparedStatement

pos - the number of the parameter in the stmt

value - the BigDecimal

Throws:

java.sql.SQLException

getClobBytes

public static byte[] getClobBytes(java.sql.ResultSet rs,
                  int columnIndex)
                           throws java.lang.Exception

Get a byte array from a Clob column of the current row of a ResultSet. Masks differences in RDBMS implementations.

Parameters:

rs - the ResultSet

columnIndex - the index of the column

Returns:

the byte[]

Throws:

java.sql.SQLException

java.lang.Exception

getBlob

public static byte[] getBlob(java.sql.ResultSet rs,
             int columnIndex)
                      throws java.lang.Exception

Get a byte array from a Blob column of the current row of a ResultSet. Masks differences in RDBMS implementations.

Parameters:

rs - the ResultSet

columnIndex - the index of the column

Returns:

the byte[]

Throws:

java.sql.SQLException

java.lang.Exception

getClob

public static java.lang.String getClob(java.sql.ResultSet rs,
                       int columnIndex)
                                throws java.lang.Exception

Get a String from a Clob column of the current row of a ResultSet. Masks differences in RDBMS implementations.

Parameters:

rs - the ResultSet

columnIndex - the index of the column

Returns:

the String

Throws:

java.sql.SQLException

java.lang.Exception

getBlobString

public static java.lang.String getBlobString(java.sql.ResultSet rs,
                             int columnIndex)
                                      throws java.lang.Exception

Get a String from a Blob column of the current row of a ResultSet. Masks differences in RDBMS implementations.

Parameters:

rs - the ResultSet

columnIndex - the index of the column

Returns:

the String

Throws:

java.sql.SQLException

java.lang.Exception

getBlobStream

public static java.io.InputStream getBlobStream(java.sql.ResultSet rs,
                                int columnIndex)
                                         throws java.lang.Exception

Get a String from a Blob column of the current row of a ResultSet. Masks differences in RDBMS implementations.

Parameters:

rs - the ResultSet

columnIndex - the index of the column

Returns:

the String

Throws:

java.sql.SQLException

java.lang.Exception

setBindVars

public static void setBindVars(java.sql.PreparedStatement stmt,
               java.lang.Object[] bindVars)

Set the bind variables of a prepared statement based on an object array.

Parameters:

stmt - the prepared statement

bindVars - the array of bind variables, may contain Nil NullExpression and wrappers.

existsTable

public static boolean existsTable(java.lang.String tablename)
                           throws java.lang.Exception

Returns true if the passed table exists in the current db-schema. The table name will be transformed into proper case for the check (can be avoided by enclosing it in double quotes).

Parameters:

tablename - the name of the table to be checked.

Returns:

true if a table with the given name exists, else false

Throws:

java.lang.Exception

existsView

public static boolean existsView(java.lang.String viewname)
                          throws java.lang.Exception

Returns true if the passed view exists in the current db-schema. The view name will be transformed into proper case for the check (can be avoided by enclosing it in double quotes).

Parameters:

viewname - the name of the view to be checked.

Returns:

true if a view with the given name exists, else false

Throws:

java.lang.Exception

existsColumn

public static boolean existsColumn(java.lang.String tablename,
                   java.lang.String columnname)
                            throws java.lang.Exception

Returns true if the passed table/view exists in the current db-schema and the passed column exists in this table/view. The names will be transformed into proper case for the check (can be avoided by enclosing them in double quotes).

Parameters:

tablename - the name of the table/view to be checked.

columnname - the name of the column to be checked.

Returns:

true if a the specified column exists in the specified table, else false

Throws:

java.lang.Exception

getTableNames

public static java.util.Set<java.lang.String> getTableNames(java.lang.String tableNamePattern)
                                                     throws java.lang.Exception

Returns a set of names of tables conforming to the name pattern in the current db-schema. The table name pattern will be transformed into proper case for the check (can be avoided by enclosing it in double quotes).

Parameters:

tableNamePattern - the pattern for the table names to match against.

Returns:

a set of names of tables

Throws:

java.lang.Exception

getViewNames

public static java.util.Set<java.lang.String> getViewNames(java.lang.String viewNamePattern)
                                                    throws java.lang.Exception

Returns a set of names of views conforming to the name pattern in the current db-schema. The view name pattern will be transformed into proper case for the check (can be avoided by enclosing it in double quotes).

Parameters:

viewNamePattern - the pattern for the view names to match against.

Returns:

a set of names of views

Throws:

java.lang.Exception

existsObject

public static boolean existsObject(java.util.Set<java.lang.String> objectNameSet,
                   java.lang.String name)

getExportedKeys

public static java.util.List<java.util.List<java.lang.Object>> getExportedKeys(java.lang.String tablename)
                                                                        throws java.lang.Exception

Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).

Parameters:

tablename - the name of the table

Returns:

a list of rows. each row is a list of FK_NAME, FK_TABLENAME and FKCOLUMN_NAME

Throws:

java.lang.Exception

getImportedKeys

public static java.util.List<java.util.List<java.lang.Object>> getImportedKeys(java.lang.String tablename)
                                                                        throws java.lang.Exception

Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).

Parameters:

tablename - the name of the table

Returns:

a list of rows. each row is a list of FK_NAME, FKCOLUMN_NAME, PKTABLE_NAME and PKCOLUMN_NAME

Throws:

java.lang.Exception

existsIndex

public static boolean existsIndex(java.lang.String tablename,
                  java.lang.String indexname)
                           throws java.lang.Exception

Returns true if the passed index exists in the current db-schema for the passed table. The names will be transformed into proper case for the check (can be avoided by enclosing them in double quotes).

Parameters:

indexname - the name of the index to be checked.

tablename - the name of the table to be checked.

Returns:

true if a the specified index exists in the specified table, else false

Throws:

java.lang.Exception

getIndexInfo

public static java.util.Map<java.lang.String,java.lang.String> getIndexInfo(java.lang.String tablename)
                                                                     throws java.lang.Exception

Throws:

java.lang.Exception

transformCase

public static java.lang.String transformCase(java.sql.DatabaseMetaData dbmd,
                             java.lang.String id)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

transformCase

public static java.lang.String transformCase(java.lang.String id)

getMaxTableNameLength

public static int getMaxTableNameLength()

getMaxConstraintIndexNameLength

public static int getMaxConstraintIndexNameLength()

mapInterface

public static <P> java.lang.Class<Persistent> mapInterface(java.lang.Class<P> c)

Get the Persistent class which is implemented by the a Class c. e.g. maps com.groiss.org.User interface to the com.dec.avw.core.User class. If c is no such mappable interface, then c is returned (cast to a Persistent)

Type Parameters:

P -

Parameters:

c - interface to determine the underlying class for

Returns:

the mapped Persistent class

mapInterface

public static java.lang.Class<Persistent> mapInterface(java.lang.String className)
                                                throws java.lang.ClassNotFoundException

Get the Persistent class which is implemented by a class with the given classname. e.g. maps User interface to the com.dec.avw.core.User class. If c is no such mappable interface, then an instance of the class named className is returned (cast to a Persistent)

Parameters:

className - the name of the interface to determine the underlying class for

Returns:

the mapped Persistent class

Throws:

java.lang.ClassNotFoundException

mapInterfaceToClassName

public static java.lang.String mapInterfaceToClassName(java.lang.String className)

Get the name of the Persistent class which is implemented by a class with the given classname. e.g. maps User interface to the com.dec.avw.core.User class. If c is no such mappable interface, then className is returned.

Parameters:

className - the name of the interface to determine the underlying className for

Returns:

the mapped class name

isSingleInterface

public static boolean isSingleInterface(java.lang.Class<?> c)

Determines if an interface c hides a single implementation (e.g. com.groiss.org.User covers com.dec.avw.core.User)

Parameters:

c - the interface to check

Returns:

true, if the is a single known implementation of c

executeScript

public static void executeScript(java.lang.String content,
                 java.io.PrintWriter res)
                          throws java.lang.Exception

Throws:

java.lang.Exception

executeScript

public static void executeScript(java.lang.String content,
                 java.io.PrintWriter res,
                 boolean tryAvoid)
                          throws java.lang.Exception

Throws:

java.lang.Exception

executeSQLFile

public static void executeSQLFile(java.lang.String commands,
                  java.io.PrintWriter res)
                           throws java.lang.Exception

Throws:

java.lang.Exception

executeSQLFile

public static int executeSQLFile(java.lang.String commands,
                 java.io.PrintWriter res,
                 boolean tryAvoid)
                          throws java.lang.Exception

Throws:

java.lang.Exception

getObject

public static <T extends Persistent> T getObject(java.lang.Object obj)

Returns the Persistent, if obj is a string like: <classname>:<oid>

Parameters:

obj - A string like <classname>:<oid>.

Returns:

The matching Persistent

toString

public static java.lang.String toString(Persistent obj)

Generates a String representation to identify a persistent object.

Parameters:

obj - the persistent object

Returns:

a String containing the class name of obj and its oid, separated by a colon

isSystemOid

public static boolean isSystemOid(long oid)

Returns true if the given oid is the oid of a system object (>0, <1000).

Parameters:

oid -

noNaN

public static double noNaN(double d)

noNaN

public static float noNaN(float f)

toEnum

public static <T extends java.lang.Enum<T>> T toEnum(java.lang.Class<T> clazz,
                                     java.lang.Object value)

Maps a value to an instance of an Enum class

Type Parameters:

T - The resulting Enum Type

Parameters:

clazz - the enum Class

value - the value to Map

Returns:

en Enum of the specified type with the corresponding value, or null When T extends DefinedEnum, the definedValue() is matched against, if not, Enum.name() is matched against (so then it is basically the same as Enum.valueOf(Class, String).

setFetchsize

public static void setFetchsize(int rows)

getFetchSize

public static int getFetchSize()

getDefaultStore

public static Store getDefaultStore()

getTableDefinition

public static java.sql.ResultSetMetaData getTableDefinition(java.lang.Class<? extends Persistent> c)

Returns:

the table definition as ResultSetMetaData

toJson

public static org.json.JSONObject toJson(Persistent pers)
                                  throws java.lang.Exception

Convert a persistent to JSON. - Null values are written (JSONObect.NULL), - persistents are written as [toString(), classname:oid] - dates are written using getTime() as long

Throws:

java.lang.Exception

toMap

public static java.util.Map<java.lang.String,java.lang.Object> toMap(Persistent pers)
                                                              throws java.lang.Exception

Convert a persistent to a Map. - Null values are written (JSONObect.NULL), - persistents are written as JSONObject [toString(), classname:oid] - dates are written using getTime() as long

Throws:

java.lang.Exception

toJsonAsReference

public static org.json.JSONObject toJsonAsReference(Persistent pers)

toMapAsReference

public static java.util.Map<java.lang.String,java.lang.Object> toMapAsReference(Persistent pers)

wrapSQLException

public static ApplicationException wrapSQLException(int errNum,
                                    java.lang.Throwable e)

Wraps an exception ; tries to discriminate between sql constraint violations and other exceptions

when sqlexception && sqlstate=23* ==> integrity coinstraint, (appex 478,e)

when sqlexception && sqlstate!=23* ==> appex(errNum,e)

when appex ==> appex

otherwise: ==> new Appex(errNum,e)

Parameters:

errNum -

e -

Returns:

oidList

public static java.util.List<java.lang.String> oidList(java.util.List<?> l,
                                       int splitsize)

Creates a list of strings of oids from a list of objects. If the objects are of type Persistent, indeed the oid will be used (as string) for the result, otherwise the toString() method will be used.

Parameters:

l - the list of objects

splitsize - the maximum number of entries per list element (chunk size). If 0 is used, a suitable predefined size is being used.

Returns:

a list of Strings, each element of the list consists of maximal splitsize elements, separated by a comma