mbassiato
07-18-02, 05:34
| First of all I would like to introduce myself. My name is Marcello and I'm posting from Italy. Hello to all the attendants of this forum. I'm reverse-engineering a QuickBASIC application that uses a BTRieve DataBase to store data. The problem I'm now facing is that I have to migrate some data from these tables to a MySQL DB using Java. The QB application stores in a LongVarChar field an array of values I'm unable to read using JDBC APIs. In particular, I can only have the first character of the array read. The piece of code I used is something like the following: InputStream clob = resultSet.getBinaryStream("TheField"); int r; while ((r = clob.read()) != -1) { System.out.print(Byte.toString((byte)r) + " "); } I'm starting thinking that's a matter of compatibility or translation between the driver and the server, but I'm not sure. Can anyone help me? Thanks in advance. |