I have binary data that I want to store at the MonetDB server and manage it through the JDBC interface. I just figured out that Monet's JDBC interface does not implement set/getBytes() or set/getBlob(). I tried to create a String object out of my vector of bytes through new String(vector) but the string it generates is crap and the system halts. Any ideas to overcome the problem? Moreover, while surfing the source code of Monet's JDBC driver I found something weird. I think line 67 of MonetClob.java should be return(buf.substring((int)(pos - 1), (int)(pos-1 + length))); instead of return(buf.substring((int)(pos - 1), (int)(pos + length))); Cheers, Rodrigo

Rodrigo Schmidt wrote:

Sorry... The system halts when I try to write this string on the database as a String using JDBC.

How exactly are you writing the String to the database? Using an insert statement? using a PreparedStatement? Can you enable the debuglog (append "?debug=true" to the JDBC connection URL as query string) and send it to us for further examination?

Rodrigo Schmidt wrote:

Of course, although I think it would be easier to debug with the code I sent before. I just do not know where this debuglog is written. Tell me and I send it to you.

Usually this is true, but since I don't have your data, I cannot exactly replicate your problem. I think the debuglog is going to tell me quite fast who is doing what wrong and where I have to look for to fix this issue. De debug log is written to the current working directory of the Java Runtime Environment and is named like monet_221637215371.log

Hello,

getBytes() works, getBlob() doesn't. All setXXX() don't work, as we don't support updateable ResultSets. When setting/requesting this mode, an SQLWarning or SQLException should be generated telling you so. If not, this is a bug.

I am not trying to use a ResultSet to update values. I am using a preparedStatement, and setBytes and setBlob are not implemented for it in Monet's driver (these calls throw SQLException).

A Vector of bytes, so you have something like: Vector b = new Vector(); for (int i = 0; i < 10; i++) b.add(new Byte((byte)i));

and you want to put that in a String?

byte[] bytes = (byte[])(b.toArray(new byte[b.length()])); String bindata = new String(bytes, "UTF-8");

then feed bindata to the driver. On a PreparedStatement it *should* work.

This is more or less what I do and, unless I made some silly mistake while implementing (it would not be the first time), it does not work. Here it is briefly what I do (with comments pointing out what I verified during debugging): // MAXSIZE = 300000 ByteArrayOutputStream buffer = new ByteArrayOutputStream(MAXSIZE); ObjectOutputStream bufferwrapper = new ObjectOutputStream(buffer); bufferwrapper.writeObject("name1"); // I do not want to write "name1" into the database. This is just // an example. Actually, what I want to write is a Serialized // object. "name1" is just a simple object very suitable for testing. PreparedStatement addpropvalue = connect.prepareStatement( "INSERT INTO name (VERSION,VALUE) VALUES (1,?);"); // name is a table previously created with the structure // (VERSION INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(300000)) addpropvalue.setBytes(1,buffer.toByteArray()); byte[] bv = buffer.toByteArray(); // contents checked at this point - OK String v = new String(bv,"UTF-8"); // contents checked again - OK // first bytes are binary code (below 32), last bytes // represent "name1" in ASCII addpropvalue.setString(1,v); addpropvalue.executeUpdate(); // execution stalls at this point. ---- Cheers, Rodrigo