ThreadSafeDatabase (Codename One API)

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

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

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
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

Class ThreadSafeDatabase

Constructor Summary

Method Summary

Methods inherited from class com.codename1.db.Database

Methods inherited from class java.lang.Object

Constructor Detail

ThreadSafeDatabase

Method Detail

getThread

beginTransaction

commitTransaction

rollbackTransaction

close

execute

execute

executeQuery

executeQuery

executeQuery

execute