Error handling

You can use the ULjException and SQLCode classes to handle errors. Most UltraLite methods throw ULjException errors. You can use the ULjException.getErrorCode method to retrieve the SQLCode value assigned to the error. You can use the ULjException.toString method to obtain a descriptive text of the error. SQLCode errors are negative numbers indicating the error type, and can be referenced using constants such as ULjException.SQLE_INDEX_NOT_FOUND.

Example

The following example illustrates a Java class that uses the ULjException class to handle an error that may occur when connecting to an UltraLite Java edition database:

import com.ianywhere.ultralitej12.*;
import net.rim.device.api.ui.component.*;
import java.util.*;

class DataAccess {
    DataAccess() {
    }
    
    public static synchronized DataAccess getDataAccess(boolean reset) 
        throws Exception
    {   
        if (_da == null) {
            _da = new DataAccess();
            ConfigObjectStore config = DatabaseManager.createConfigurationObjectStore("HelloDB");
            if (reset) {
                _conn = DatabaseManager.createDatabase(config);
                // _da.createDatabaseSchema();
            } 
            else {
                try {
                    _conn = DatabaseManager.connect(config);
                }
                catch (ULjException uex1) {
                    if (uex1.getErrorCode() != ULjException.SQLE_ULTRALITE_DATABASE_NOT_FOUND) {
                        Dialog.alert("Exception: " + uex1.toString() + ". Recreating database...");
                    }
                    _conn = DatabaseManager.createDatabase(config);
                    // _da.createDatabaseSchema();
                }
            }
        }
        return _da;        
    }
    private static Connection _conn;
    private static DataAccess _da;
}

Error handling

Example

See also