ms access: sqlexception

[Christian Eugster <ch...@bluewin.ch>]

Hi there

unfortunately i have to connect my application for a customer to an access
database. I succeeded to connect but i always get exceptions while inserting
or updating rows as follows:

INTERESTING: the insertstatement shows instead of values just '?' what could
this mean? Has anybody any idea?

Thank you!

Christian

[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert :
ch.eugster.pos.db.ProductGroup@1f8f8c8
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:INSERT INTO pos_product_group
(id,timestamp,deleted,galileo_id,default_tax_id,shortname,name,quantity,pric
e,opt_code,account,is_expense) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeInsert:
sun.jdbc.odbc.JdbcOdbcPreparedStatement@b83be0
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the insert (for a ch.eugster.pos.db.ProductGroup):
[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in der INSERT
INTO-Anweisung.
[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in der INSERT
INTO-Anweisung.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
Syntaxfehler in der INSERT INTO-Anweisung.
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
	at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
	at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
	at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
	at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
	at ch.eugster.pos.db.Table.store(Table.java:98)
	at ch.eugster.pos.db.Table.store(Table.java:194)
	at
ch.eugster.pos.admin.model.PersistentDBStore.save(PersistentDBStore.java:48)
	at ch.eugster.pos.admin.gui.container.SashForm.save(SashForm.java:543)
	at ch.eugster.pos.admin.MainWindow.buttonPressed(MainWindow.java:998)
	at ch.eugster.pos.admin.MainWindow$5.widgetSelected(MainWindow.java:838)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:89)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:81)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:840)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2022)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:1729)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:583)
	at org.eclipse.jface.window.Window.open(Window.java:563)
	at ch.eugster.pos.admin.MainWindow.getInstance(MainWindow.java:1116)
	at ch.eugster.pos.admin.App.<init>(App.java:71)
	at ch.eugster.pos.admin.App.main(App.java:130)
17.03.2004 23:27:20 ch.eugster.pos.db.Table describeError
SCHWERWIEGEND: java.sql.SQLException: [Microsoft][ODBC Microsoft Access
Driver] Syntaxfehler in der INSERT INTO-Anweisung.
17.03.2004 23:27:20 ch.eugster.pos.db.DBResult log
SCHWERWIEGEND: 4:
17.03.2004 23:27:20 ch.eugster.pos.db.DBResult log
SCHWERWIEGEND: 37000: [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler
in der INSERT INTO-Anweisung.
17.03.2004 23:27:20 ch.eugster.pos.db.Table describeError
SCHWERWIEGEND: [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in der
INSERT INTO-Anweisung.
[org.apache.ojb.broker.accesslayer.StatementManager] DEBUG: closeResources
was called
[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was
called, do rollback on current connection
sun.jdbc.odbc.JdbcOdbcConnection@e4245


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org