db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kab <wer...@gmail.com>
Subject Insert JAVA_OBJECT in embedded Derby DB
Date Fri, 04 May 2007 09:02:20 GMT
Hi,

I tried to directly insert a Java object from typ mottrow.MItem to the table
ITEMS in my embedded Derby DB. But I got the following error:

java.sql.SQLException: An attempt was made to get a data value of type
'BLOB' from a data value of type 'mottrow.MItem'

In the query I used, I had defined the row ITEM to the typ BLOB, because
with the typ JAVA_OBJECT I got an error. In the derby documentation I have
read that the a JAVA_OBJECT is stored as BLOB in the DB, so I defined it
directly as BLOB.

SQL query used to create table:

String query = "create table APP.ITEMS (" +
                    "ID INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS
IDENTITY (START WITH 1, INCREMENT BY 1)," +
                    "ITEM BLOB," +
                    "LEVEL INT NOT NULL," +
                    "OWNER VARCHAR(30)," +
                    "LASTACCESS DATE," +
                    "FORMERLEVEL INTEGER NOT NULL )";

Statement to insert my JAVA_OBJECT:

            PreparedStatement stmt = con.prepareStatement("insert into
APP.ITEMS (ITEM) VALUES (?)");
            stmt.setObject(1,item);
            stmt.addBatch( );

Does somebody knows a solution for this problem?


Sincerely

Kevin

Mime
View raw message