我想使用通过NetBeans的UCanAccess在Access表中进行一些小的更改,但是我遇到了一个问题
pst.executeUpdate();
数据库详细信息:
database name : duruBistro.accdb
table name : person
field names: tc_no (text)
name (text)
surname (text)
salary (number)
代码:
Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\ysnndr \\Documents\\accessDB\\duruBistro.accdb");
String query = "UPDATE PERSON SET SALARY = ? WHERE TC_NO = '189'";
PreparedStatement pst = conn.prepareStatement(query);
pst.setInt(1, 2500);
pst.executeUpdate();
异常(exception):
run:
java.lang.IllegalArgumentException: Given index Index@53f65459[
name: (PERSON) PrimaryKey
number: 0
isPrimaryKey: true
isForeignKey: false
data: IndexData@3b088d51[
dataNumber: 0
pageNumber: 317
isBackingPrimaryKey: true
isUnique: true
ignoreNulls: false
columns: [
ReadOnlyColumnDescriptor@1786dec2[
column: TextColumn@711f39f9[
name: (PERSON) TC_NO
type: 0xa (TEXT)
number: 17
length: 22
variableLength: true
compressedUnicode: true
textSortOrder: SortOrder[1055(0)]
]
flags: 1
]
]
initialized: false
pageCache: IndexPageCache@74650e52[
pages: (uninitialized)
]
]
] is not usable for indexed lookups due to unsupported collating sort order SortOrder[1055(0)] for text index
at com.healthmarketscience.jackcess.impl.IndexCursorImpl.createCursor(IndexCursorImpl.java:111)
net.ucanaccess.jdbc.UcanaccessSQLException: Given index Index@53f65459[
name: (PERSON) PrimaryKey
number: 0
isPrimaryKey: true
isForeignKey: false
data: IndexData@3b088d51[
dataNumber: 0
pageNumber: 317
at com.healthmarketscience.jackcess.CursorBuilder.toCursor(CursorBuilder.java:302)
at net.ucanaccess.commands.IndexSelector.getCursor(IndexSelector.java:148)
isBackingPrimaryKey: true
isUnique: true
at net.ucanaccess.commands.CompositeCommand.persist(CompositeCommand.java:83)
ignoreNulls: false
columns: [
ReadOnlyColumnDescriptor@1786dec2[
column: TextColumn@711f39f9[
name: (PERSON) TC_NO
type: 0xa (TEXT)
number: 17
length: 22
variableLength: true
compressedUnicode: true
textSortOrder: SortOrder[1055(0)]
]
flags: 1
]
]
initialized: false
pageCache: IndexPageCache@74650e52[
pages: (uninitialized)
]
]
] is not usable for indexed lookups due to unsupported collating sort order SortOrder[1055(0)] for text index
at net.ucanaccess.jdbc.UcanaccessConnection.flushIO(UcanaccessConnection.java:312)
at net.ucanaccess.jdbc.UcanaccessConnection.commit(UcanaccessConnection.java:202)
at net.ucanaccess.jdbc.AbstractExecute.executeBase(AbstractExecute.java:143)
at net.ucanaccess.jdbc.ExecuteUpdate.execute(ExecuteUpdate.java:56)
at net.ucanaccess.jdbc.UcanaccessPreparedStatement.executeUpdate(UcanaccessPreparedStatement.java:248)
at com.ui.AccdbcConnection.main(AccdbcConnection.java:29)
BUILD SUCCESSFUL (total time: 1 second)
最佳答案
解释错误消息:
这是Jackcess的一个已知限制,JCancess是UCanAccess用于读取和写入Access数据库文件的记录管理器。为了对类型为Text
的主键的表执行更新,Jackcess要求Access数据库使用“常规”或“常规-传统”排序顺序。
若要更改所讨论的Access数据库文件的排序顺序,请执行以下操作:
File > Options
下,将“新数据库排序顺序”更改为“常规”(或“常规-传统”)。 您的Java应用程序不应再引发异常。但是,如果问题仍然存在,则Windows区域设置也可能存在问题。有关其他可能的解决方案,请参见this answer。