com.codename1.db

Class ThreadSafeDatabase

java.lang.Object

com.codename1.db.Database

com.codename1.db.ThreadSafeDatabase

Deprecated.

platform specific nuances prevented this approach from working out, we improved the native iOS support for thread safety instead

public class ThreadSafeDatabase
extends Database

Wraps all database calls in a single thread so they are all proxied thru that thread

Constructor Summary

Constructors

Constructor and Description
ThreadSafeDatabase(Database db) Deprecated. Wraps the given database with a threadsafe version

Method Summary

Modifier and Type	Method and Description
void	beginTransaction() Deprecated. Starts a transaction
void	close() Deprecated. Closes the database
void	commitTransaction() Deprecated. Commits current transaction
void	execute(String sql) Deprecated. Execute an update query.
void	execute(String sql, Object... params) Deprecated. Execute an update query with params.
void	execute(String sql, String[] params) Deprecated. Execute an update query with params.
Cursor	executeQuery(String sql) Deprecated. This method should be called with SELECT type statements that return row set.
Cursor	executeQuery(String sql, Object... params) Deprecated. This method should be called with SELECT type statements that return row set it accepts object with params.
Cursor	executeQuery(String sql, String[] params) Deprecated. This method should be called with SELECT type statements that return row set.
EasyThread	getThread() Deprecated. Returns the underlying easy thread we can use to pipe tasks to the db thread
void	rollbackTransaction() Deprecated. Rolls back current transaction

Methods inherited from class com.codename1.db.Database

delete, exists, getDatabasePath, isCustomPathSupported, openOrCreate, supportsWasNull, wasNull

Methods inherited from class java.lang.Object

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

Constructor Detail

ThreadSafeDatabase

public ThreadSafeDatabase(Database db)

Deprecated.

Wraps the given database with a threadsafe version

Parameters:

db - the database

Method Detail

getThread

public EasyThread getThread()

Deprecated.

Returns the underlying easy thread we can use to pipe tasks to the db thread

Returns:

the easy thread object

beginTransaction

public void beginTransaction()
                      throws IOException

Deprecated.

Description copied from class: Database

Starts a transaction

NOTE: Not supported in Javascript port. This method will do nothing when running in Javascript.

Specified by:

beginTransaction in class Database

Throws:

IOException - if database is not opened

commitTransaction

public void commitTransaction()
                       throws IOException

Deprecated.

Description copied from class: Database

Commits current transaction

NOTE: Not supported in Javascript port. This method will do nothing when running in Javascript.

Specified by:

commitTransaction in class Database

Throws:

IOException - if database is not opened or transaction was not started

rollbackTransaction

public void rollbackTransaction()
                         throws IOException

Deprecated.

Description copied from class: Database

Rolls back current transaction

NOTE: Not supported in Javascript port. This method will do nothing when running in Javascript.

Specified by:

rollbackTransaction in class Database

Throws:

IOException - if database is not opened or transaction was not started

close

public void close()

Deprecated.

Description copied from class: Database

Closes the database

Specified by:

close in class Database

execute

public void execute(String sql)
             throws IOException

Deprecated.

Description copied from class: Database

Execute an update query. Used for INSERT, UPDATE, DELETE and similar sql statements.

Specified by:

execute in class Database

Parameters:

sql - the sql to execute

Throws:

IOException

execute

public void execute(String sql,
                    String[] params)
             throws IOException

Deprecated.

Description copied from class: Database

Execute an update query with params. Used for INSERT, UPDATE, DELETE and similar sql statements. The sql can be constructed with '?' and the params will be binded to the query

Specified by:

execute in class Database

Parameters:

sql - the sql to execute

params - to bind to the query where the '?' exists

Throws:

IOException

executeQuery

public Cursor executeQuery(String sql,
                           String[] params)
                    throws IOException

Deprecated.

Description copied from class: Database

This method should be called with SELECT type statements that return row set.

Specified by:

executeQuery in class Database

Parameters:

sql - the sql to execute

params - to bind to the query where the '?' exists

Returns:

a cursor to iterate over the results

Throws:

IOException

executeQuery

public Cursor executeQuery(String sql)
                    throws IOException

Deprecated.

Description copied from class: Database

This method should be called with SELECT type statements that return row set.

Specified by:

executeQuery in class Database

Parameters:

sql - the sql to execute

Returns:

a cursor to iterate over the results

Throws:

IOException

executeQuery

public Cursor executeQuery(String sql,
                           Object... params)
                    throws IOException

Deprecated.

Description copied from class: Database

This method should be called with SELECT type statements that return row set it accepts object with params.

Overrides:

executeQuery in class Database

Parameters:

sql - the sql to execute

params - to bind to the query where the '?' exists, supported object types are String, byte[], Double, Long and null

Returns:

a cursor to iterate over the results

Throws:

IOException

execute

public void execute(String sql,
                    Object... params)
             throws IOException

Deprecated.

Description copied from class: Database

Execute an update query with params. Used for INSERT, UPDATE, DELETE and similar sql statements. The sql can be constructed with '?' and the params will be binded to the query

Overrides:

execute in class Database

Parameters:

sql - the sql to execute

params - to bind to the query where the '?' exists, supported object types are String, byte[], Double, Long and null

Throws:

IOException