Добрый день.
Использую:
commons-lang-2.6
commons-logging-1.1.1
hsqldb
jackcess-2.1.2
jackcess-encrypt-1.0.4
ucanaccess-3.0.0
При вставке записи (запись ниже) через ODBC-JDBC все ок, при вставке напрямую используя UCanAccess выдает ошибку:
Сама запись:
1.
INSERT INTO TasksUnicode VALUES (16233,1441172276,'login','Sidorov Ivan',1, 'Student',2)
Код ошибки:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.0 data exception: invalid character value for cast
at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:154)
at SafetyInspectionRegister.SafetyDatabase.addNewUnicodeRow(SafetyDatabase.java:451)
at SafetyInspectionRegister.MainWindow$2.actionPerformed(MainWindow.java:342)
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.AWTEventMulticaster.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.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
.............
Прошу подсказать, в чем разница?
