java.sql.SQLException

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web10279

  • via Oracle Community by 843859, 7 months ago
    [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
  • via Oracle Community by 843804, 1 year ago
    [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
  • via Oracle Community by 843838, 1 year ago
    [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
  • Stack trace

    • java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:2525) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252) at TouristRegistrationGUI.deleteRecord(TouristRegistrationGUI.java:500) at TouristRegistrationGUI.buttonClicked(TouristRegistrationGUI.java:217) at BreezySwing.GBDialogButtonListener.actionPerformed(GBDialog.java:459) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1767) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1820) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:258) at java.awt.Component.processMouseEvent(Component.java:5021) at java.awt.Component.processEvent(Component.java:4818) at java.awt.Container.processEvent(Container.java:1380) at java.awt.Component.dispatchEventImpl(Component.java:3526) at java.awt.Container.dispatchEventImpl(Container.java:1437) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3214) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2929) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2859) at java.awt.Container.dispatchEventImpl(Container.java:1423) at java.awt.Window.dispatchEventImpl(Window.java:1566) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.EventQueue.dispatchEvent(EventQueue.java:445) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:190) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:144) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:134) at java.awt.Dialog.show(Dialog.java:524) at ExoticToursGUI.buttonClicked(ExoticToursGUI.java:186) at BreezySwing.GBFrameButtonListener.actionPerformed(GBFrame.java:518) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1767) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1820) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:258) at java.awt.Component.processMouseEvent(Component.java:5021) at java.awt.Component.processEvent(Component.java:4818) at java.awt.Container.processEvent(Container.java:1380) at java.awt.Component.dispatchEventImpl(Component.java:3526) at java.awt.Container.dispatchEventImpl(Container.java:1437) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3214) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2929) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2859) at java.awt.Container.dispatchEventImpl(Container.java:1423) at java.awt.Window.dispatchEventImpl(Window.java:1566) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.EventQueue.dispatchEvent(EventQueue.java:445) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:190) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:144) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130) at java.awt.EventDispatchThread.run(EventDispatchThread.java:98)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago
    Unknown user
    2 times, 11 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    12 more bugmates