Hello,
I had this exception :
Exception in thread "main" java.sql.SQLException: Can't find column: N������Lot in table Lot
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.bn.a(Unknown Source)
at com.hxtt.sql.bn.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at com.vecteurplus.synergies.diffusion.core.TestHxtt.main(TestHxtt.java:20)
when trying to make an insert into an access 97 table. (the column "N������Lot" exists in the table Lot) .
I think it's a problem with the column name containing a "������" character.
My version of the drivers :
Specification-Version: 3.2.082 on August 20, 2009
Comment: JDBC 4.0 Package for Microsoft Access
To reproduce the error:
1) prepare a database access 97 with one table (call it "Lot" ) with one field (call it "N������Lot", the data type doesn't matter I think)
2) try to run an insert statement like this one : "insert into Lot([N������Lot])values (4);"
and you should get the exception
Note that the problem doesn't occur if I use an access 2003 database with the same characteristics.
|
>Note that the problem doesn't occur if I use an access 2003 database
> with the same characteristics.
Yeah. For MS Access 95/97 format, you need charSet=aCorrectJavaCharaSet connection property:)
|
It's ok when I set yhe property charSet to "ISO-8859-1".
Thank you for you quick response.
|
Main
webmaster@hxtt.com