db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henning P. Schmiedehausen" <...@intermeta.de>
Subject Re: [ojb] Re: [work_java] CLOB needs quotes
Date Tue, 05 Aug 2003 14:45:02 GMT
Federico Spinazzi <f.spinazzi@masterhouse.it> writes:

Yup, exactly. If you want to use your CLOB in Torque, Torque must know
how to translate "CLOB" in the xml schema to the native database.

	Regards
		Henning


>Henning P. Schmiedehausen wrote:

>>Federico Spinazzi <f.spinazzi@masterhouse.it> writes:
>>
>>If you tell me what native datatype db2 uses for CLOBs, I could actually add
>>it to Torque.... :-) Just "CLOB" ?
>>
>>	Regards
>>		Henning
>>  
>>
>Henning,
>I'm not sure if I understand exactly what you are asking me.

>I can say that the following works:

>CREATE TABLE FOO (FOO CLOB);
>INSERT INTO FOO VALUES ('foo');
>-- the following:
>SELECT FOO FROM FOO WHERE FOO = 'foo'; -- eh eh
>-- doesn't work as I think you cannot use a CLOB in a where clause (???).
>Cheers,
>Federico


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

-- 
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
hps@intermeta.de        +49 9131 50 654 0   http://www.intermeta.de/

Java, perl, Solaris, Linux, xSP Consulting, Web Services 
freelance consultant -- Jakarta Turbine Development  -- hero for hire

"You are being far too rational for this discussion."  
       --- Scott Robert Ladd in <3F1874B0.6030507@coyotegulch.com>

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


Mime
View raw message