[salassi]

This is a program to create a database in SQLite...I've created a folder in E:/TestProject....I've set this path to simulator/memory/PC file system for SDCard Files/

But my database doesn't seem to be created in SQLite......

Can any1 tell me where i went wrong?





xxx91;codexxx93;
package database;

import net.rim.device.api.ui.container.MainScreen;
import net.rim.device.api.database.Database;
import net.rim.device.api.database.DatabaseFactory;
import net.rim.device.api.database.Statement;
import net.rim.device.api.io.URI;
import net.rim.device.api.ui.Graphics;
import net.rim.device.api.ui.component.EditField;
import net.rim.device.api.ui.component.LabelField;
import net.rim.device.api.ui.component.RichTextField;
public class firstprogramscreen extends MainScreen
{
Database d;
public firstprogramscreen()
{

LabelField title = new LabelField("SQLite Create Database Sample",
LabelField.ELLIPSIS |
LabelField.USE_ALL_WIDTH);
setTitle(title);

EditField ed = new EditField()
{
protected void paint(Graphics graphics)
{
// TODO Auto-generated method stub
super.paint(graphics);
}
};
add(new RichTextField("Creating a Table called "));
try
{
URI myURI = URI.create("file:///SDCard/Databases/SQLite_Guide/DatabaseSample.db");
d = DatabaseFactory.openOrCreate(myURI);
Statement st = d.createStatement( "CREATE TABLE 'People' ( " +
"'Name' TEXT, " +
"'Age' INTEGER )" );
st.prepare();
st.execute();
st.close();
d.close();
}
catch ( Exception e )
{
System.out.println( e.getMessage() );
e.printStackTrace();
}
}

}

xxx91;/codexxx93;

Desparately waiting for the answer


Thanks in advance

[hrbuckley]

Something happened to the sticky thread. All you need to do is click the php icon on the far righe to the toolbar and paste your code in between the PHP tags.

PHP Code:

import net.rim.device.api.ui.container.MainScreen;
import net.rim.device.api.database.Database;
import net.rim.device.api.database.DatabaseFactory;
import net.rim.device.api.database.Statement;
import net.rim.device.api.io.URI;
import net.rim.device.api.ui.Graphics;
import net.rim.device.api.ui.component.EditField;
import net.rim.device.api.ui.component.LabelField;
import net.rim.device.api.ui.component.RichTextField;
public class firstprogramscreen extends MainScreen
{
  Database d;
  public firstprogramscreen()
  {

    LabelField title = new LabelField("SQLite Create Database Sample",
    LabelField.ELLIPSIS |
    LabelField.USE_ALL_WIDTH);
    setTitle(title);

    EditField ed = new EditField()
    {
       protected void paint(Graphics graphics)
       {
          // TODO Auto-generated method stub
          super.paint(graphics);
       }
    };
    add(new RichTextField("Creating a Table called "));
    try
    {
      URI myURI = URI.create("file:///SDCard/Databases/SQLite_Guide/DatabaseSample.db");
      d = DatabaseFactory.openOrCreate(myURI);
      Statement st = d.createStatement( "CREATE TABLE 'People' ( " +
      "'Name' TEXT, " +
      "'Age' INTEGER )" );
      st.prepare();
      st.execute();
      st.close();
      d.close();
    }
    catch ( Exception e )
    {
      System.out.println( e.getMessage() );
      e.printStackTrace();
    }
  }

} 


This makes it much easier to look at the code.

[Dougsg38p]

I don't like the space in your URI:

URI myURI = URI.create("file:///SDCard/Databases/SQLite_Guide /DatabaseSample.db");

Are you catching an exception?


Edit: never mind - there isn't a space there - just looks like it from the formatting.

[hrbuckley]

I created the following program based on the sample from the API documentation and your code;

PHP Code:

import javax.microedition.io.file.FileSystemRegistry;
import java.util.Enumeration;
import net.rim.device.api.database.Database;
import net.rim.device.api.database.DatabaseFactory;
import net.rim.device.api.database.Statement;
import net.rim.device.api.io.URI;
import net.rim.device.api.system.Application;
 
public class AddDatabaseTable extends Application 
{
    public static void main(Stringxxx91;xxx93; args)
    {
        AddDatabaseTable app = new AddDatabaseTable();
        try
        {
            Enumeration en = FileSystemRegistry.listRoots();
            while (en.hasMoreElements()) {
                System.out.println(en.nextElement());
            }
        
            //URI myURI = URI.create("/SDCard/test.db"); 
            URI myURI = URI.create("/SDCard/Databases/SQLite_Guide/DatabaseSample.db");
            
            Database d = DatabaseFactory.openOrCreate(myURI);
            Statement st = d.createStatement( "CREATE TABLE 'People' ( "+"'Name' TEXT, " + "'Age' INTEGER )" );
            st.prepare();
            st.execute();
            st.close();
        }
        catch ( Exception e ) 
        {         
            System.out.println( e.getMessage() );
        }
    }
} 


The file is created in the simulated SDCard, but only if it is mounted. When you run your code do you get an exception? If so what is exceptiion and message? Try using the FileSystemRegistry fragment to ensure that you actually have the file system you want to create the DB on. You will want to do this for any final code anyway.

[hrbuckley]

Originally Posted by Dougsg38p

I don't like the space in your URI:

URI myURI = URI.create("file:///SDCard/Databases/SQLite_Guide /DatabaseSample.db");

Are you catching an exception?


Edit: never mind - there isn't a space there - just looks like it from the formatting.

Yah, that slipped by me when I was reformatting the code.