Unanswered: Reading LVAR fields with Pervasive JDBC Drivers
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");
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.