Package io.odysz.semantic.DA.drvmnger

Class SqliteDriver2

java.lang.Object

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

io.odysz.semantic.DA.drvmnger.SqliteDriver2

Direct Known Subclasses:

SqliteDriverQueued

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

Modifier and Type	Field	Description
protected Connection	conn	Sqlite connection. SqliteDriver using sigle connection to avoid error: org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked) see StackOverflow: Getting [SQLITE_BUSY] database file is locked with select statements

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

drvName, enableSystemout, flag_disableSql, flag_nothing, flag_printSql, id, locks, log

Method Summary

Modifier and Type	Method	Description
protected void	close()
int[]	commit(io.odysz.semantics.IUser usr, ArrayList<String> sqls, ArrayList<Clob> lobs, int i)
int[]	commit(ArrayList<String> sqls, int flags)	Commit statement
Connection	getConnection()	MUST CLOSE CONNECTION!
static SqliteDriver2	initConnection(String id, 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, printSql, printSql, prop, prop

Methods inherited from class java.lang.Object

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

Field Details

conn

protected Connection conn

Sqlite connection.
SqliteDriver using sigle connection to avoid error:
org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)
see StackOverflow: Getting [SQLITE_BUSY] database file is locked with select statements

Method Details

close

protected void close()
              throws SQLException

Overrides:

close in class AbsConnect<SqliteDriver2>

Throws:

SQLException

getConnection

public Connection getConnection()
                         throws SQLException

MUST CLOSE CONNECTION!

Returns:

connection

Throws:

SQLException

initConnection

public static SqliteDriver2 initConnection(String id,
 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