Very Computer

Can anyone provide me with a bit of code, directions, or any helpful advice
whatever that will help me serialize objects and store them in a standard
relational database.  (Not ODBMS)

Any help would be GREATLY appreciated!

Thanks!
Will

I would suggest you take a look at our Relational Object Framework (ROF).

ROF allows you to "map" your Java objects into a standard relational database.
Unlike just munging it all into a blob, this approach allows you to query the
database based on member variables of the object.

Using ROF, Java programmers can create applications that interact with any
RDBMS without knowing SQL, the structure of the database, or managing the
connection layer via JDBC. This allows programmers to access an RDBMS without
any database specific coding.

Because ROF maintains its own model of the database and the class mappings, the
database structure and class definitions can change independently.

Give it a test http://www.watershed.com

Good luck,
Dirk Fromhein

Here's a code snippet that shows object serialiation/deserialization
to/from a DBMS. The example is for Oracle, but except for the
DDL, it would be the same for any other DBMS. Lemme know if
it helps,
Joe Weinstein at WebLogic, Inc.

    stmt.executeUpdate("create table " + tablename + "(foo long raw)");
     pstmt = con.prepareCall("insert into " + tablename + " values(?)");
    Object o = "1234567890"; // A String object this time...

    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    ObjectOutputStream oos     = new ObjectOutputStream(baos);
    oos.writeObject(o);

    byte[] bytes = baos.toByteArray();
    ByteArrayInputStream bais = new ByteArrayInputStream(bytes);

    pstmt.setBinaryStream(1, bais, bytes.length);
    pstmt.executeUpdate();
    pstmt.close();

    rs = stmt.executeQuery("select * from " + tablename + "");

    while(rs.next())
    {
       java.io.InputStream x = rs.getBinaryStream(1);
       ObjectInputStream ox  = new ObjectInputStream(x);
       Object oout = ox.readObject();
       String objName = oout.getClass().getName();

        if (!objName.equals("java.lang.String"))
        { // deser. failed
        }
        if (!oout.equals(o))
        { // deser failed.
        }
    }

Joseph Weinstein        Staff Engineer
http://www.weblogic.com
See our newsgroups:       http://www.weblogic.com/services/newsgroups.html
try weblogic for free *with support*:  http://www4.weblogic.com/register.html