Hey Leute,
ich habe einen Code und will gern ein Insert in einer DERBY-DB machen...
Hier der Code:
Er spuckt mir dabei aber folgende Exception aus:
Ich weiß nicht was daran falsch ist...eigentlich ist die Syntax korrekt :/
ich habe einen Code und will gern ein Insert in einer DERBY-DB machen...
Hier der Code:
Java:
/*
* Hinzufügen eines neuen Turniers
*/
public void insertTournament(Statement stmt, Connection conn, String name,
String dateTime, String referee) throws SQLException {
if (name.equals("") || dateTime.equals("") || referee.equals("")) {
} else {
stmt = conn.createStatement();
stmt.executeUpdate("INSERT INTO Tournament(datetime,name,referee) VALUES ('"
+ dateTime + "', '" + name + "', '" + referee + "'");
stmt.close();
System.out.println("Turnier Hinzugefügt!");
}
// Ende
}
}
Er spuckt mir dabei aber folgende Exception aus:
Java:
DerbyDB-Server gestartet!
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "<EOF>" at line 1, column 71.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
at de.flunkyball.util.InsertsAndDelete.insertTournament(InsertsAndDelete.java:118)
at de.flunkyball.masks.NewTournament$1.actionPerformed(NewTournament.java:112)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLException: Syntax error: Encountered "<EOF>" at line 1, column 71.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 35 more
Caused by: ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 71.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 29 more
Ich weiß nicht was daran falsch ist...eigentlich ist die Syntax korrekt :/