>From: "James Mitchell" <[EMAIL PROTECTED]> >Reply-To: "OJB Users List" <[EMAIL PROTECTED]> >To: "OJB Users List" <[EMAIL PROTECTED]> >Subject: RE: Schema Tables : Internal tables >Date: Wed, 11 Sep 2002 12:26:33 -0400 > >...and if you are distributing apps that use OJB, the developer/deployer is >expected to build OJB to get them? I think NOT!
A thought: you can use torque without building OJB. A deployer might be expected to run an install script/wizard ;) >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. Great. Thats why I continued to explain the underlying SQL issue. > > > >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]> _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
