io.odysz.semantic.DA

Class Connects

java.lang.Object

io.odysz.semantic.DA.Connects

public class Connects
extends Object

Author:

odys-z@github.com

Field Summary

Fields

Modifier and Type	Field and Description
static int	flag_disableSql
static int	flag_nothing nothing special for commit
static int	flag_printSql
protected static HashMap<String,HashMap<String,io.odysz.semantics.meta.TableMeta>>	metas

Constructor Summary

Constructors

Constructor and Description
Connects()

Method Summary

Modifier and Type	Method and Description
static void	close()
static int[]	commit(io.odysz.semantics.IUser usr, ArrayList<String> sqls, ArrayList<Clob> lobs, int... flags)
static int[]	commit(io.odysz.semantics.IUser usr, ArrayList<String> sqls, int... flags) Commit to default connection.
static int[]	commit(io.odysz.semantics.IUser usr, String sql)
static int[]	commit(String conn, io.odysz.semantics.IUser usr, ArrayList<String> sqls, int... flags)
static int[]	commit(String conn, io.odysz.semantics.IUser usr, String sql, int... flags)
static Set<String>	connIds()
static String	defltConn()
static io.odysz.common.dbtype	driverType(String conn)
static Set<String>	getAllConnIds()
static boolean	getDebug(String conn)
static HashMap<String,io.odysz.semantics.meta.TableMeta>	getMeta(String connId)
static io.odysz.semantics.meta.TableMeta	getMeta(String connId, String tbl)
static String	getSmtcsPath(String conn) Get the smtcs file path configured in connects.xml.
static void	init(String xmlDir) parse connects.xml, setup connections configured in table "drvmnger", for JDBC DriverManger, and "dbcp", for JDBC connection-pooled connection managed by container.
static HashMap<String,io.odysz.semantics.meta.TableMeta>	loadMeta(String conn) Build database tables' meta.
static String	pagingSql(io.odysz.common.dbtype dt, String sql, int pageIx, int pgSize)
static String	pagingSql(String conn, String sql, int page, int size) compose paged sql, e.g.
static io.odysz.common.dbtype	parseDrvType(String type) Convert names like "sqlit" to dbtype.
static void	printSql(boolean asking, int flag, ArrayList<String> sqls) If printSql is true or if asking enable, then print sqls.
static void	printSql(boolean asking, int flag, String sql)
static void	reinit(String xmlDir)
static AnResultset	select(String sql, int... flags)
static AnResultset	select(String conn, String sql, int... flags)
static void	setMeta(String connId, io.odysz.semantics.meta.TableMeta m) Set table meta (providing a chance of extending table's semantics and keep a single copy for DB's meta).
static String	uri2conn(String uri) Mapping client function id to data connection according to configuration.

Methods inherited from class java.lang.Object

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

Field Detail

flag_nothing

public static final int flag_nothing

nothing special for commit

See Also:

Constant Field Values

flag_printSql

public static final int flag_printSql

See Also:

Constant Field Values

flag_disableSql

public static final int flag_disableSql

See Also:

Constant Field Values

metas

protected static HashMap<String,HashMap<String,io.odysz.semantics.meta.TableMeta>> metas

Constructor Detail

Connects

public Connects()

Method Detail

parseDrvType

public static io.odysz.common.dbtype parseDrvType(String type)
                                           throws SemanticException

Convert names like "sqlit" to dbtype.

Parameters:

type -

Returns:

db type

Throws:

SemanticException

getAllConnIds

public static Set<String> getAllConnIds()

defltConn

public static String defltConn()

reinit

public static void reinit(String xmlDir)

init

public static void init(String xmlDir)

parse connects.xml, setup connections configured in table "drvmnger", for JDBC DriverManger, and "dbcp", for JDBC connection-pooled connection managed by container.

Parameters:

xmlDir -

close

public static void close()

printSql

public static void printSql(boolean asking,
                            int flag,
                            ArrayList<String> sqls)

If printSql is true or if asking enable, then print sqls.

Parameters:

asking -

flag -

sqls -

printSql

public static void printSql(boolean asking,
                            int flag,
                            String sql)

select

public static AnResultset select(String conn,
                                 String sql,
                                 int... flags)
                          throws SQLException

Throws:

SQLException

select

public static AnResultset select(String sql,
                                 int... flags)
                          throws SQLException

Throws:

SQLException

pagingSql

public static String pagingSql(String conn,
                               String sql,
                               int page,
                               int size)
                        throws io.odysz.transact.x.TransException

compose paged sql, e.g. for Oracle:
select * from (sql) t where rownum > 0 and row num < 14

Parameters:

sql -

page -

size -

Returns:

sql

Throws:

io.odysz.transact.x.TransException

pagingSql

public static String pagingSql(io.odysz.common.dbtype dt,
                               String sql,
                               int pageIx,
                               int pgSize)
                        throws io.odysz.transact.x.TransException

Throws:

io.odysz.transact.x.TransException

commit

public static int[] commit(io.odysz.semantics.IUser usr,
                           ArrayList<String> sqls,
                           int... flags)
                    throws SQLException,
                           io.odysz.transact.x.TransException

Commit to default connection.

Parameters:

usr -

sqls -

flags -

Returns:

affected row count

Throws:

SQLException

io.odysz.transact.x.TransException

commit

public static int[] commit(io.odysz.semantics.IUser usr,
                           ArrayList<String> sqls,
                           ArrayList<Clob> lobs,
                           int... flags)
                    throws SQLException

Throws:

SQLException

commit

public static int[] commit(String conn,
                           io.odysz.semantics.IUser usr,
                           String sql,
                           int... flags)
                    throws SQLException,
                           io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

commit

public static int[] commit(String conn,
                           io.odysz.semantics.IUser usr,
                           ArrayList<String> sqls,
                           int... flags)
                    throws SQLException,
                           io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

commit

public static int[] commit(io.odysz.semantics.IUser usr,
                           String sql)
                    throws SQLException,
                           io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

driverType

public static io.odysz.common.dbtype driverType(String conn)

connIds

public static Set<String> connIds()

loadMeta

public static HashMap<String,io.odysz.semantics.meta.TableMeta> loadMeta(String conn)
                                                                  throws SemanticException,
                                                                         SQLException

Build database tables' meta.

Parameters:

conn -

Returns:

metas

Throws:

SemanticException

SQLException

getMeta

public static HashMap<String,io.odysz.semantics.meta.TableMeta> getMeta(String connId)
                                                                 throws SemanticException,
                                                                        SQLException

Throws:

SemanticException

SQLException

getMeta

public static io.odysz.semantics.meta.TableMeta getMeta(String connId,
                                                        String tbl)
                                                 throws SemanticException,
                                                        SQLException

Parameters:

connId -

tbl -

Returns:

table meta

Throws:

SemanticException

SQLException

Since:

1.4.25

setMeta

public static void setMeta(String connId,
                           io.odysz.semantics.meta.TableMeta m)
                    throws SemanticException,
                           SQLException

Set table meta (providing a chance of extending table's semantics and keep a single copy for DB's meta).

Parameters:

connId -

m -

Throws:

SemanticException

SQLException

Since:

1.4.25

getSmtcsPath

public static String getSmtcsPath(String conn)

Get the smtcs file path configured in connects.xml.

Parameters:

conn -

Returns:

smtcs (e.g. semantics.xml)

getDebug

public static boolean getDebug(String conn)

uri2conn

public static String uri2conn(String uri)
                       throws SemanticException

Mapping client function id to data connection according to configuration. Uri pattern is matched with prefix of strings' in db config.xml.

Parameters:

uri -

Returns:

Throws:

SemanticException