package net.primarysolutions.dbtest;

import android.app.Activity;
import android.os.Bundle;
import android.util.Log;

import com.ianywhere.ultralitejni12.ConfigPersistent;
import com.ianywhere.ultralitejni12.Connection;
import com.ianywhere.ultralitejni12.DatabaseManager;
import com.ianywhere.ultralitejni12.PreparedStatement;
import com.ianywhere.ultralitejni12.ULjException;

public class DBTestActivity extends Activity {

private ConfigPersistent m_config;
private Connection m_conn;

/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {

    try
    {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        createDatabase();
    }
    catch (ULjException e)
    {
        Log.e("STUFF", e.getMessage());
    }
}

private void createDatabase() throws ULjException
{
    String db_name = "gkanywhere.udb";

    m_config = DatabaseManager.createConfigurationFileAndroid(db_name, this.getApplicationContext());

    m_config.setLazyLoadIndexes(true);

    m_conn = DatabaseManager.createDatabase( m_config );

    m_conn = DatabaseManager.connect( m_config );

    createModules();
}

void createModules()
        throws ULjException
    {
        String sql = "CREATE TABLE Modules (" +
                "Module_Name VARCHAR(30) NOT NULL, " +
                "Install_Date DATE NULL, " +
                "License_Expiration DATE NULL, " +
                "License_Limit INTEGER NULL, " +
                "Version VARCHAR(20) NULL, " +
                "PRIMARY KEY ( Module_Name ASC ))";
        executeDDL(sql);

    }

private void executeDDL(String sql) throws ULjException 
    {
    PreparedStatement ps = m_conn.prepareStatement(sql);
    ps.execute();
    ps.close();
    }
}

Tag = dalvikvm
Text = Exception Ljava/lang/UnsatisfiedLinkError; thrown during Lcom/ianywhere/ultralitejni12/implementation/JniDbMgr;.<clinit>

m_conn = DatabaseManager.createDatabase( m_config );