From: Fabio A. <as...@me...> - 2001-10-19 13:58:35
|
hi, I have (again) problems with eXist. The "error" seams to be in character encoding, this is my conf.xml: <db-connection driver=3D"org.gjt.mm.mysql.Driver" =09 url=3D"jdbc:mysql://localhost/FAS_test1?autoReconnect=3Dtru= e" user=3D"asnicar" password=3D"fabio" encoding=3D"UTF8" =09=09 database=3D"mysql" /> NB: I have the same result if I set: encoding=3D"ISO-8859-1" url=3D"jdbc:mysql://localhost/FAS_test1?autoReconnect=3Dtrue&useUnicode= =3Dtrue&characterEncoding=3Diso-8859-1" and: encoding=3D"ISO-8859-1" url=3D"jdbc:mysql://localhost/FAS_test1?autoReconnect=3Dtrue&characterE= ncoding=3Diso-8859-1" and: =20 encoding=3D"ISO-8859-1" url=3D"jdbc:mysql://localhost/FAS_test1?autoReconnect=3Dtrue" the server tells me: 19 Oct 2001 15:31:16,217 DEBUG (Parser.java [scan]:106) - scanning document shakespeare/hamlet.xml to determine tree structure ... 19 Oct 2001 15:31:17,714 DEBUG (Parser.java [store]:111) - storing document ... loading data from file '/home/asnicar/var/tips/XML:DB/eXist-0.6/tmp/dom59088.txt' 19 Oct 2001 15:31:40,625 DEBUG (RelationalBroker.java [flush]:1229) - java.io.IOException: java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Invalid authorization specification: Access denied for user: 'asnicar@localhost' (Using password: YES) but it is not an authorization problem: if I lookink database log I can find some (good) insert: [...] 354 Query insert into words (word_id, wdata) values (1729, 'arrest') 354 Query select word_id from words where wdata=3D'rebuk' 354 Query insert into words (word_id, wdata) values (1730, 'rebuk') 354 Query select word_id from words where wdata=3D'fine' [...] and some "strange" insert statements: 354 Query insert into inv_idx (doc_id, word_id, data) values (1, 21, '8\0\0\0\0\0\0=E6\0\0\0\0\0\0') 354 Query insert into inv_idx (doc_id, word_id, data) values (1, 20, '\0\0\0\0\0\08\0\0\0\0\0\0=E6\0\0\0\0\0\0') with "strange" characters: =E6 =B6=E0W =AE=DEW =BC$Q =A26Q >=F7P ... and CR many thanks for your help! ciao, FA_ |