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

SQLite issue

X-Received	by 10.182.105.230 with SMTP id gp6mr3865721obb.18.1401980529026; Thu, 05 Jun 2014 08:02:09 -0700 (PDT)
X-Received	by 10.140.93.23 with SMTP id c23mr222279qge.14.1401980528994; Thu, 05 Jun 2014 08:02:08 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!c1no23547421igq.0!news-out.google.com!k18ni4648qav.1!nntp.google.com!j5no1716508qaq.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.lang.java.programmer
Date	Thu, 5 Jun 2014 08:02:08 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=190.55.153.103; posting-account=mirxYwoAAAD9WWIEohIN7NKE9WMr0uXP
NNTP-Posting-Host	190.55.153.103
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<80f36094-2915-477a-9995-e86bde85587c@googlegroups.com> (permalink)
Subject	SQLite issue
From	manguicho@gmail.com
Injection-Date	Thu, 05 Jun 2014 15:02:09 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.lang.java.programmer:28662

Show key headers only | 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