long numbers instead of data

[garyd1234]

Hi,
I am writing a java servlet. When I run it with ODBC from an access database i can return the data looking great with correct spacing and everything. When i run the same servlet against a mysql database it returns a huge long hexadecimal number. Any ideas why? I can't figure it out.
Thanks.
Gary

 

[stefanwagner]

Well - hm. ODBC is still alive?
No problem.
What else to do access access...

For mysql you use of course a pure jdbc-driver?

How do you get your values from the resultset?
Some code please

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[sedj]

What is the data type in the database ?
What datatype are you extracting via the driver ?

Can you give an example of the data ?



--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[sedj]

FYI,

The original poster seemed to get bored with this thread, and tried his luck in this one instead : thread269-921574

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[stefanwagner]

Well - I got bored too and will switch to the other thread too.
hope to see you there

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[garyd1234]

Hi,
I have a mysql database set up using blobs for a field type because the data in there is large. When I try to read it back in java using a String field it only gives me part of the information stored in the field. I have tried declaring variables Blob or long var2 = Long.parseLong(var1); but those give errors I don't understand. How can I get the variable to hold the entire contents of the field in the database? Thanks.

 

[sedj]

In your other related post, I suggested you use the ResultSet.getBlob() method.

I still suggest you use that !

See the documentation on Blob :

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Blob.html

IE :
ResultSet rs ...
Blob blob = rs.getBlob();
byte[] b = blob.getBytes(1, (int)blob.length());

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk