File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem storing a vector Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem storing a vector" Watch "Problem storing a vector" New topic

Problem storing a vector

james wilson

Joined: Nov 17, 2001
Posts: 15
I have a problem when trying to retrieve a vector from a mySQL database I get a EOFException, the code is as below;
to write;

to read;

Is there any obvisous mistake that I am making, because I cannot see it and I am tearing my hair out!
Thanks in advance
James Wilson
Where there's a will there's a way.
Where there's a way there's a java exception!
[ Edited by Dave to format code ]
[This message has been edited by David O'Meara (edited December 04, 2001).]
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 567
what does sqlQuery look like after you've executed
sqlQuery="UPDATE user SET dbTime = ('"+vectordata+"') WHERE dbUserId = ('"+userid+"')";

What's the EOF exception? it's not from the DB is it?

I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
james wilson

Joined: Nov 17, 2001
Posts: 15
Thanks for the offer of help Adam, but i decided to take an alternative approach, and store the inofrmation in a seperate table, thus negating the need for a vector.
Thanks anywho.
I agree. Here's the link:
subject: Problem storing a vector
It's not a secret anymore!