Why are you creating the tables manually? I believe that torque will auto generate them if you set up db2 as the database in the build properties.
however, You can use BLOB. The difference between BLOBs and LONGVARBINARY is only different in the way the database stores and indexes it. A LONGVARBINARY is a Column that is stored with the other column data in the underlying filesystem. But BLOBs are typically implemented with a higher performance reference to the binary data. In terms of JDBC, storing a BLOB and Storing a LONGVARBINARY are identical. Hope this helps. David >From: Ujwal Oswal <[EMAIL PROTECTED]> >Reply-To: "OJB Users List" <[EMAIL PROTECTED]> >To: 'OJB Users List' <[EMAIL PROTECTED]> >Subject: Schema Tables : Internal tables >Date: Wed, 11 Sep 2002 09:11:08 -0400 > >Hi All, > >I am trying to create the internal tables used for ODMG for DB2 database. I >need to know whether I use the BLOB type for LONGVARBINARY. > >Eg. One of the Internal tables: > >CREATE TABLE OJB_NRM >( > NAME VARCHAR (250), > OID_ LONGVARBINARY, > PRIMARY KEY(NAME) >); > >For the above table it doesn't allow me to create this table, it sends me >a >message LONGVARBINARY not supported. Instead can I use a BLOB type. If not >which type should I use. > >Thanks >UO > _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
