Folgender Code:
verursacht folgende Fehlermeldung:
Bin ich blöd? Die Tabelle existiert definitiv nicht. mach ich nur SELECT * FROM Artikel, kann er die Tabelle nicht finden.
Code:
import java.sql.*;
import java.util.logging.*;
public class UseHSQLDB {
static Logger log = Logger.getLogger("de.myname.UseHSQLDB");
public static void main(String[] args)
throws SQLException, ClassNotFoundException { // Doit better ...
log.log(Level.INFO, "Starting to load JDBCDriver... ");
Class.forName("org.hsqldb.jdbcDriver");
log.log(Level.INFO, "JDBC Driver successfully loaded!");
Connection con =
DriverManager.getConnection( // tmp must exist. Right slash.
"jdbc:hsqldb:C:tmp/artikel","sa","");
log.log(Level.INFO, "Connection established!");
Statement stmt = con.createStatement();
String sqlQuery =
"CREATE TABLE Artikel (cdNr INTEGER, cdArtist CHAR(20), cdTitle CHAR(20))";
ResultSet rs = stmt.executeQuery(sqlQuery);
rs = stmt.executeQuery(sqlQuery);
sqlQuery = "INSERT INTO Artikel VALUES (1,'Groeni','Mensch')";
rs = stmt.executeQuery(sqlQuery);
sqlQuery = "INSERT INTO Artikel VALUES (2,'Sting','Fields of Gold')";
rs = stmt.executeQuery(sqlQuery);
sqlQuery = "INSERT INTO Artikel VALUES (3,'Bach','Pluratorium')";
rs = stmt.executeQuery(sqlQuery);
sqlQuery = "UPDATE Artikel SET cdTitle='W-Oratorium' WHERE cdNr=1";
rs = stmt.executeQuery(sqlQuery);
sqlQuery = "SELECT * FROM Artikel";
rs = stmt.executeQuery(sqlQuery);
System.out.println("\n\n\nArtikel- DB\n=============\n");
int counter = 0;
while (rs.next()) {
System.out.println(counter++ +".Datensatz:");
int cdNr = rs.getInt("cdNr");
System.out.println("\t[cdNr ->" + cdNr + "]");
String cdArtist = rs.getString("cdArtist");
System.out.println("\t[cdArtist ->" + cdArtist + "]");
String cdTitle = rs.getString("cdTitle");
System.out.println("\t[cdTitle ->" + cdTitle + "]\n");
}
con.close();
}
}
verursacht folgende Fehlermeldung:
Fehlermeldung:
--------------------Configuration: kjp - JDK version 1.5.0_02 <Default> - <Default>--------------------
14.11.2007 20:28:14 UseHSQLDB main
INFO: Starting to load JDBCDriver...
14.11.2007 20:28:14 UseHSQLDB main
INFO: JDBC Driver successfully loaded!
14.11.2007 20:28:14 UseHSQLDB main
INFO: Connection established!
Exception in thread "main" java.sql.SQLException: Table already exists: ARTIKEL in statement [CREATE TABLE Artikel]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at UseHSQLDB.main(UseHSQLDB.java:46)
Process completed.
Bin ich blöd? Die Tabelle existiert definitiv nicht. mach ich nur SELECT * FROM Artikel, kann er die Tabelle nicht finden.