G
Gast00007
Gast
Hallo,
ich versuche mittels eines PreparedStatements einen Datensatz in eine MDB Datei zu schreiben... Nur leider klappt das nicht so ganz...
Folgender Code:
Dazu erhalte ich folgende Ausgabe vom JDBC Treiber, sobald ich die Methode ausführe:
Ich hoffe, mir kann jemand sagen, was ich falsch mache...
Danke schonmal!
Grüße
Der (noch)Gast
ich versuche mittels eines PreparedStatements einen Datensatz in eine MDB Datei zu schreiben... Nur leider klappt das nicht so ganz...
Folgender Code:
Code:
private void setMitarbeiter() {
try {
con = DBConn.openDB();
System.out.println("Connection Successful ");
} catch (Exception e) {
e.printStackTrace();
System.out.println("Keine Verbindung zur Datenbank");
}
try {
PreparedStatement speicherMitarbeiter = con.prepareStatement(
"INSERT into PERSONAL values ('?','?','?','?','?','?','?','?','?')");
System.out.println(nachname.getText());
speicherMitarbeiter.setString( 1, "Nachname" );
speicherMitarbeiter.setString( 2, "Vorname" );
speicherMitarbeiter.setString( 3, "position" );
speicherMitarbeiter.setString( 4, "Gebdatum" );
speicherMitarbeiter.setString( 5, "Einstdatum" );
speicherMitarbeiter.setString( 6, "Strasse" );
speicherMitarbeiter.setString( 7, "plz" );
speicherMitarbeiter.setString( 8, "ort" );
speicherMitarbeiter.setString( 9, "tel" );
speicherMitarbeiter.executeUpdate();
System.out.println(speicherMitarbeiter.toString());
speicherMitarbeiter.close();
con.close();
System.out.println("Datenbankverbindung getrennt");
}catch (Exception e) {
}
Dazu erhalte ich folgende Ausgabe vom JDBC Treiber, sobald ich die Methode ausführe:
DriverManager.getConnection("jdbcdbcRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\db.mdb")
trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@186db54]
*Driver.connect (jdbcdbcRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\db.mdb)
JDBC to ODBC Bridge: Checking security
No SecurityManager present, assuming trusted application/applet
JDBC to ODBC Bridge 2.0001
Current Date/Time: Mon Dec 08 19:17:29 CET 2008
Loading JdbcOdbc library
Allocating Environment handle (SQLAllocEnv)
hEnv=58266856
Allocating Connection handle (SQLAllocConnect)
hDbc=58267024
Connecting (SQLDriverConnect), hDbc=58267024, szConnStrIn=DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\db.mdb
*Connection.getMetaData
*DatabaseMetaData.getDriverName
Get connection info string (SQLGetInfo), hDbc=58267024, fInfoType=6, len=300
odbcjt32.dll
*DatabaseMetaData.getDriverVersion
Get connection info string (SQLGetInfo), hDbc=58267024, fInfoType=7, len=300
04.00.6305
*DatabaseMetaData.getDriverName
Get connection info string (SQLGetInfo), hDbc=58267024, fInfoType=6, len=300
odbcjt32.dll
Driver name: JDBC-ODBC Bridge (odbcjt32.dll)
*DatabaseMetaData.getDriverVersion
Get connection info string (SQLGetInfo), hDbc=58267024, fInfoType=7, len=300
04.00.6305
Driver version: 2.0001 (04.00.6305)
Caching SQL type information
*Connection.getMetaData
*DatabaseMetaData.getTypeInfo
Allocating Statement Handle (SQLAllocStmt), hDbc=58267024
hStmt=58270504
Get type info (SQLGetTypeInfo), hStmt=58270504, fSqlType=0
Number of result columns (SQLNumResultCols), hStmt=58270504
value=19
Get connection info string (SQLGetInfo), hDbc=58267024, fInfoType=10, len=300
03.52.0000
Fetching (SQLFetch), hStmt=58270504
Column attributes (SQLColAttributes), hStmt=58270504, icol=1, type=2
value (int)=12
Column attributes (SQLColAttributes), hStmt=58270504, icol=1, type=3
value (int)=128
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
GUID
Get integer data (SQLGetData), hStmt=58270504, column=2
value=-11
Get integer data (SQLGetData), hStmt=58270504, column=3
value=36
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
BIT
Get integer data (SQLGetData), hStmt=58270504, column=2
value=-7
Get integer data (SQLGetData), hStmt=58270504, column=3
value=1
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
BYTE
Get integer data (SQLGetData), hStmt=58270504, column=2
value=-6
Get integer data (SQLGetData), hStmt=58270504, column=3
value=3
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
LONGBINARY
Get integer data (SQLGetData), hStmt=58270504, column=2
value=-4
Get integer data (SQLGetData), hStmt=58270504, column=3
value=1073741823
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
VARBINARY
Get integer data (SQLGetData), hStmt=58270504, column=2
value=-3
Get integer data (SQLGetData), hStmt=58270504, column=3
value=255
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
BINARY
Get integer data (SQLGetData), hStmt=58270504, column=2
value=-2
Get integer data (SQLGetData), hStmt=58270504, column=3
value=255
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
LONGCHAR
Get integer data (SQLGetData), hStmt=58270504, column=2
value=-1
Get integer data (SQLGetData), hStmt=58270504, column=3
value=2147483647
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
CHAR
Get integer data (SQLGetData), hStmt=58270504, column=2
value=1
Get integer data (SQLGetData), hStmt=58270504, column=3
value=255
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
CURRENCY
Get integer data (SQLGetData), hStmt=58270504, column=2
value=2
Get integer data (SQLGetData), hStmt=58270504, column=3
value=19
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
INTEGER
Get integer data (SQLGetData), hStmt=58270504, column=2
value=4
Get integer data (SQLGetData), hStmt=58270504, column=3
value=10
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
COUNTER
Get integer data (SQLGetData), hStmt=58270504, column=2
value=4
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
SMALLINT
Get integer data (SQLGetData), hStmt=58270504, column=2
value=5
Get integer data (SQLGetData), hStmt=58270504, column=3
value=5
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
REAL
Get integer data (SQLGetData), hStmt=58270504, column=2
value=7
Get integer data (SQLGetData), hStmt=58270504, column=3
value=7
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
DOUBLE
Get integer data (SQLGetData), hStmt=58270504, column=2
value=8
Get integer data (SQLGetData), hStmt=58270504, column=3
value=15
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
DATETIME
Get integer data (SQLGetData), hStmt=58270504, column=2
value=11
Get integer data (SQLGetData), hStmt=58270504, column=3
value=19
Fetching (SQLFetch), hStmt=58270504
Get string data (SQLGetData), hStmt=58270504, column=1, maxLen=129
VARCHAR
Get integer data (SQLGetData), hStmt=58270504, column=2
value=12
Get integer data (SQLGetData), hStmt=58270504, column=3
value=255
Fetching (SQLFetch), hStmt=58270504
End of result set (SQL_NO_DATA)
*ResultSet.close
Free statement (SQLFreeStmt), hStmt=58270504, fOption=1
*ResultSet has been closed
Get connection info (SQLGetInfo), hDbc=58267024, fInfoType=44
int value=19
Get connection info (SQLGetInfo), hDbc=58267024, fInfoType=168
int value=1
Get connection info (SQLGetInfo), hDbc=58267024, fInfoType=151
int value=127
Get connection info (SQLGetInfo), hDbc=58267024, fInfoType=121
int value=0
Get connection info (SQLGetInfo), hDbc=58267024, fInfoType=120
int value=0
Get connection info (SQLGetInfo), hDbc=58267024, fInfoType=153
int value=2
getConnection returning driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@186db54]
Connection Successful
*Connection.prepareStatement (INSERT into PERSONAL values ('?','?','?','?','?','?','?','?','?'))
Allocating Statement Handle (SQLAllocStmt), hDbc=58267024
hStmt=58270504
Setting statement option (SQLSetStmtOption), hStmt=58270504, fOption=6, vParam=0
Setting statement option (SQLSetStmtOption), hStmt=58270504, fOption=7, vParam=1
Preparing (SQLPrepare), hStmt=58270504, szSqlStr=INSERT into PERSONAL values ('?','?','?','?','?','?','?','?','?')
Number of parameter markers (SQLNumParams), hStmt=58270504
value=0
Registering Statement sun.jdbc.odbc.JdbcOdbcPreparedStatement@b166b5
Ich hoffe, mir kann jemand sagen, was ich falsch mache...
Danke schonmal!
Grüße
Der (noch)Gast