Sqlite INSERT no me funciona.

[alex760125]

Un saludo! Les comento q logro conectarme a mi BD Sqlite pero no puedo insertar datos. Q sucede?

Conectado
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: VISITORS)
at org.sqlite.core.DB.newSQLException(DB.java:909)
at org.sqlite.core.DB.newSQLException(DB.java:921)
at org.sqlite.core.DB.throwex(DB.java:886)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:127 )
at org.sqlite.core.DB.prepare(DB.java:227)
at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3 Statement.java:81)
at SqlitePruebas.main(SqlitePruebas.java:14)

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class SqlitePruebas {

public static void main(String[] args) {

try {
Connection konetCAGB = ConectionPrueba.ConnectCAGB();
Statement statementB4 = konetCAGB.createStatement();
String codigosql = "INSERT INTO VISITORS (House, Name, LastName, License, Company) VALUES ('9935', 'SANDRA', 'ROJAS', 'R254236-3', 'LOS VERDES');";
statementB4.executeQuery(codigosql);
konetCAGB.close();

} catch (SQLException e1) {

e1.printStackTrace();
}
}

}

class ConectionPrueba {

static Connection con = null;

public static Connection ConnectCAGB(){

try{
Class.forName("org.sqlite.JDBC");
Connection con = DriverManager.getConnection("jdbc:sqlite:DatabaseC ontrolAccessGB.sqlite");
System.out.println("Conectado");
return con;
}catch(Exception e){

System.out.println("No Conectado");

return con = null;
}


}


}