Re: PrintWriter as blob with mysql

From:

Daniel Pitts <newsgroup.spamfilter@virtualinfinity.net>

Newsgroups:

comp.lang.java.help

Date:

Sat, 09 Feb 2008 09:03:55 -0800

Message-ID:

<47addcbf$0$1448$7836cce5@newsrazor.net>

belletti.stefano@email.it wrote:

probably it's a poor design of my application, however ...

in a class i create
PrintWriter pw = new PrintWriter( new
BufferedOutputStream(socket.getOutputStream(), 1024), true);
then i "insert" it in a blob field in a mysql table
the insertion seems ok, the field contains something
like:"java.io.PrintWriter@c2ff5"

in another class i read that blob field (and try to use it as a
PrintWriter)

Blob writerletto = rs.getBlob("blobfield");
but it contains:"com.mysql.jdbc.Blob@1adc30" !!
and i'm not able to use it as a PrintWriter.

I've tried something like
pwTo=new PrintWriter(writerletto);
but there is not such constructor.

am idefinetely on the WRONG road ?

thank you

You can't pass that kind of thing through a database, especially since
your using a socket output stream. Sockets are endpoints on one
machine, you can't pass that to a database (which may be on another
machine) then then through on to another client (which may be yet on
another machine).

I think we need to clarify what your actual goal is. You're approach
(putting the socket connection "into" a database) won't work. Why are
you trying to move the socket output stream in the first place?

--
Daniel Pitts' Tech Blog: <http://virtualinfinity.net/wordpress/>