Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #28662

SQLite issue

Show all headers | View raw

Mi problema es bien basico y me esta volviendo loco. Pido por favor a los expertos que me den un poco de luz al respecto. 
gracias!

1)He bajado esto:
https://bitbucket.org/xerial/sqlite-jdbc/downloads/sqlite-jdbc-3.7.2.jar

2)generado SQLiteJDBC.java con el siguiente codigo:

import java.sql.*;

public class SQLiteJDBC
{
  public static void main( String args[] )
  {
    Connection c = null;
    Statement stmt = null;
    try {
      Class.forName("org.sqlite.JDBC");
      c = DriverManager.getConnection("jdbc:sqlite:test.db");
      System.out.println("Opened database successfully");

      stmt = c.createStatement();
      String sql = "CREATE TABLE COMPANY " +
                   "(ID INT PRIMARY KEY     NOT NULL," +
                   " NAME           TEXT    NOT NULL, " + 
                   " AGE            INT     NOT NULL, " + 
                   " ADDRESS        CHAR(50), " + 
                   " SALARY         REAL)"; 
      stmt.executeUpdate(sql);
      stmt.close();
      c.close();
    } catch ( Exception e ) {
      System.err.println( e.getClass().getName() + ": " + e.getMessage() );
      System.exit(0);
    }
    System.out.println("Table created successfully");
  }
}
3) Comiplado con : 
$ javac SQLiteJDBC.java
4) al intentar ejecutar con: 
$ java -classpath ".;sqlite-jdbc-3.7.2.jar" SQLiteJDBC 
arroja el siguiente error: 
"Error: no se ha encontrado o cargado la clase principal SQLiteJDBC"

desde ya muchas gracias!

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

SQLite issue manguicho@gmail.com - 2014-06-05 08:02 -0700
  Re: SQLite issue Joerg Meier <joergmmeier@arcor.de> - 2014-06-05 22:31 +0200
  Re: SQLite issue Steven Simpson <ss@domain.invalid> - 2014-06-06 13:51 +0100
    Re: SQLite issue Arne Vajhøj <arne@vajhoej.dk> - 2014-06-06 18:06 -0400

csiph-web