db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robles, Rogelio" <Rogelio.Rob...@experian.com>
Subject RE: R: Using DB2 7.2 with Torque
Date Mon, 24 Nov 2003 23:38:59 GMT

replace type="BLOB" with type="VARBINARY" and regenerate your SQL 

DB2's BLOBs require a size value, so your column should be: svg BLOB(65535) 
whatever number that fits your needs

Rogelio

> -----Original Message-----
> From: Charles-Alexandre Sabourdin [mailto:kaneda@dedaletechnology.com]
> Sent: Monday, November 24, 2003 3:39 AM
> To: torque-user@db.apache.org
> Subject: Re: R: Using DB2 7.2 with Torque
> 
> 
> this comand does not work :
> CREATE TABLE SchemasFiles
> (
>                             idBlob INTEGER NOT NULL,
>                         svg BLOB,
>                             idSch INTEGER NOT NULL
> )
> I have the following error :
> 
> Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI 
> Driver][DB2/LINUX] SQL0604N La 
> longueur, la précision ou l'attribut d'échelle pour la 
> colonne, le type 
> distinct, le type structuré, l'attribut du type structuré, la 
> fonction ou  le 
> mappage de type "SVG" sont incorrects.  SQLSTATE=42611
> 
> This could be either a torque-gen error (because the BLOB 
> attribut is not 
> correctly managed
> my torque file containe this :
> 
> <table name="SchemasFiles" idMethod="idbroker" skipSql="false" 
> basePeer="org.apache.torque.util.BasePeer">
>         <column name="idBlob" primaryKey="true" 
> required="true" type="INTEGER" 
> autoIncrement="false" inputValidator="" javaNamingMethod="nochange" 
> inheritance="false" />
>         <column name="svg" primaryKey="false" type="BLOB" 
> autoIncrement="false" inputValidator="" javaNamingMethod="nochange" 
> inheritance="false" />
>         <column name="idSch" primaryKey="true" 
> required="true" type="INTEGER" 
> autoIncrement="false" inputValidator="" javaNamingMethod="nochange" 
> inheritance="false" />
>         <foreign-key foreignTable="Schemas">
>             <reference local="idSch" foreign="idSch" />
>         </foreign-key>
>     </table>
> 
> 
> Le Vendredi 21 Novembre 2003 15:56, Giulio Vezzelli a écrit :
> > We are actually using Torque with both DB2 UDB 7.1 and 7.2, 
> and it works.
> >
> > Any specific questions ?
> >
> >
> > Giulio Vezzelli
> > Infolog S.r.l.
> > Via Alfieri, 28
> > Modena - 41100
> > Telefono : +39-059-822446
> > Sito web : http://www.infolog.it
> > E-mail : giulio.vezzelli@infolog.it
> >
> > > -----Messaggio originale-----
> > > Da: Charles-Alexandre Sabourdin 
> [mailto:kaneda@dedaletechnology.com]
> > > Inviato: venerdì 21 novembre 2003 12.26
> > > A: 'Apache Torque Users List'
> > > Oggetto: Using DB2 7.2 with Torque
> > >
> > >
> > >     Hello,
> > > does anyone has used Torque with DBé product ? or  Hypersonic
> > > I notice that
> > > there where no status nor tester.
> > > I could becam tester for those, but how should I do this ?
> > >
> > >
> > >
> > >
> > > --
> > > Charles-Alexandre
> > > SABOURDIN
> > > -----------------
> > >
> > >
> > > 
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> 
> -- 
> Charles-Alexandre
> SABOURDIN
> -----------------
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message