-
Situation:
One of columns in a MDB file contains non-latin strings (cyrillic values). This column is also indexed as a primary key.
When I insert a cyrillic string to a table, Jackcess throws the error:
java.io.IOException: unmapped string index value п
at com.healthmarketscience.jackcess.Index.writeNonNullIndexTextValue(Index.java:1088)
at...
2009-12-23 15:10:17 UTC by kirill2007
-
seems access will only read the overflow info if it is in the header row. guess you never know until you try. (that probably doesn't mean a whole lot to you, sorry).
anyway, this is checked into trunk and will be in the 1.1.21 release.
2009-12-23 02:43:17 UTC by jahlborn
-
jahlborn committed revision 424 to the Jackcess SVN repository, changing 2 files.
2009-12-23 02:41:00 UTC by jahlborn
-
jahlborn committed revision 423 to the Jackcess SVN repository, changing 1 files.
2009-12-23 01:50:52 UTC by jahlborn
-
I’m executing the following simple code that updates the file “domains.mdb” (it is attached as well):
Database db = Database.open(new File("domains.mdb"));
Table t = db.getTable("domains");
// go to record #1
t.getNextRow();
// set new objects
Object[] objs = new Object[7];
objs[0] = "soft";
objs[1] = new Integer(5);
objs[2] = new Integer(0);.
2009-12-22 08:54:05 UTC by kirill2007
-
jahlborn committed revision 422 to the Jackcess SVN repository, changing 2 files.
2009-12-22 02:39:46 UTC by jahlborn
-
yeah, unfortunately the formatting information is stored in a currently undeciphered format inside access. so, jackcess cannot read field formatting information.
why do you need to formatting information in order to convert the fields to timestamps? they should be coming out as java Dates, which should be directly insertable via jdbc.
2009-12-09 23:11:37 UTC by jahlborn
-
I ran into a little problem with time fields ("Date/Time" column with "Short Time" format): I'd like to map them into a timestamp in Postgres, but I can't find a way to get the formatting information. Is that available somewhere?
It seems mdbtools doesn't get that one right either.
2009-12-09 01:29:19 UTC by peterbecker
-
jahlborn committed revision 421 to the Jackcess SVN repository, changing 3 files.
2009-12-07 03:35:44 UTC by jahlborn
-
jahlborn committed revision 420 to the Jackcess SVN repository, changing 2 files.
2009-12-05 14:56:47 UTC by jahlborn
