io.odysz.semantic.DA.drvmnger

Class SqliteDriver2

java.lang.Object

io.odysz.semantic.DA.AbsConnect<SqliteDriver2>

io.odysz.semantic.DA.drvmnger.SqliteDriver2

public class SqliteDriver2
extends AbsConnect<SqliteDriver2>

All instance using the same connection.
Sqlite connection.
SqliteDriver using sigle connection to avoid error:
see StackOverflow: Getting [SQLITE_BUSY] database file is locked with select statements

Author:

odys-z@github.com

Field Summary

Fields inherited from class io.odysz.semantic.DA.AbsConnect

drvName, enableSystemout, locks, log

Method Summary

Modifier and Type	Method and Description
protected void	close()
int[]	commit(ArrayList<String> sqls, int flags) Commit statement
int[]	commit(io.odysz.semantics.IUser usr, ArrayList<String> sqls, ArrayList<Clob> lobs, int i)
protected Connection	getConnection() This method is only for debug and test, use #initConnection(String, String, String, boolean, int) before any function call.
static SqliteDriver2	initConnection(String jdbc, String user, String psword, boolean log, int flags) Get SqliteDriver2 instance, with database connection got via DriverManager.
AnResultset	select(String sql, int flag)

Methods inherited from class io.odysz.semantic.DA.AbsConnect

commit, driverType, getAutoseqLock, initDmConnect, initPooledConnect, prop, prop

Methods inherited from class java.lang.Object

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

Method Detail

close

protected void close()
              throws SQLException

Overrides:

close in class AbsConnect<SqliteDriver2>

Throws:

SQLException

getConnection

protected Connection getConnection()
                            throws SQLException

This method is only for debug and test, use #initConnection(String, String, String, boolean, int) before any function call. MUST CLOSE CONNECTION!

Returns:

connection

Throws:

SQLException

initConnection

public static SqliteDriver2 initConnection(String jdbc,
                                           String user,
                                           String psword,
                                           boolean log,
                                           int flags)
                                    throws SQLException

Get SqliteDriver2 instance, with database connection got via DriverManager.

Parameters:

jdbc -

user -

psword -

log -

flags -

Returns:

SqliteDriver2 instance

Throws:

SQLException

select

public AnResultset select(String sql,
                          int flag)
                   throws SQLException

Specified by:

select in class AbsConnect<SqliteDriver2>

Throws:

SQLException

commit

public int[] commit(ArrayList<String> sqls,
                    int flags)
             throws SQLException

Commit statement

Specified by:

commit in class AbsConnect<SqliteDriver2>

Parameters:

sqls -

flags -

Returns:

The update counts in order of commands

Throws:

SQLException

commit

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

Specified by:

commit in class AbsConnect<SqliteDriver2>

Throws:

SQLException