db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles-Alexandre Sabourdin <kan...@dedaletechnology.com>
Subject Re: R: Using DB2 7.2 with Torque
Date Mon, 24 Nov 2003 11:39:06 GMT
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


Mime
View raw message