...and if you are distributing apps that use OJB, the developer/deployer is expected to build OJB to get them? I think NOT!
I distribute the required sql in a separate .sql file and mention in the readme that they need to run them against the target db. James Mitchell Software Engineer\Struts Evangelist Struts-Atlanta, the "Open Minded Developer Network" http://www.open-tools.org/struts-atlanta > -----Original Message----- > From: David Raphael [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 12:18 PM > To: [EMAIL PROTECTED] > Subject: Re: Schema Tables : Internal tables > > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
