Hm, informative link, thank you. I'll check into this in a moment though I
just found something that might be causing other problems I've been having,
as well (i.e. the idmethod='native' not _ever_ working). In the
Torque.properties file built by the tdk2.2 the string:
torque.database.nodedb.adapter=mysql
is left in the file. I'm not quite certain why this isnt' updating itself
to 'oracle' but I can imagine if torque thinks it's working on a mysql
database then anything outside of SQL92 might definitely screw up
(including sequences and clobs, etc). Can anyone comment on why this
parameter might've been left as 'mysql' even though in the build.properties
file I've correctly defined:
database = oracle
and
databaseDriver = oracle.jdbc.OracleDriver
Any help is greatly appreciated; Gabor, my thanks for the pointers.
-j
Gabor Kincses
<npure2001@yahoo. To: Turbine Torque Users List
com>
<[EMAIL PROTECTED]>
cc:
12/10/2002 04:20 Subject: Re: Oracle CLOBs return null
PM
Please respond to
"Turbine Torque
Users List"
I doubt this is a problem with torque.
I have seen something quite similar with the Oracle
JDBC driver about 2 years ago. Even the examples in
the OTN tutorial didn't work right. This was somewhat
correlated to the version of the download (8.0.5 vs.
8.1.6). These are of course engine release numbers,
but stupidly the driver downloads were tied to these.
Also, code that worked with 8.0.5 didn't work with
8.1.6. I think I always used the type-4 version (no
type-2 on FreeBSD :(). Have you tried the type-2
version of the driver?
You may want to compare the SQL that torque issues to
some of the success stories like this:
http://groups.google.com:80/groups?hl=en&lr
=&ie=UTF-8&selm=39731cb6.21753698%40news.colt.net
--- [EMAIL PROTECTED] wrote:
>
> If any of the fields in my model are marked as CLOBs
> Torque seems to return
> null when running a select for these fields. I found
> this link in the
> archive:
>
>
http://www.mail-archive.com/[email protected]/msg00515.html
>
> stating that the solution is to, instead, mark all
> CLOBs are LONGVARBINARY
> fields. Is this really the case? If so, why? Nothing
> in the archives seems
> to explain Torque's issue w/ Oracle CLOBs ... can
> anyone elaborate?
>
> Regards,
> -j
>
> -------------------------------------------------
> James Diggans
> Bioinformatics Programmer
> Gene Logic, Inc.
> Phone: 301.987.1756
> FAX: 301.987.1701
>
>
>
> --
> To unsubscribe, e-mail:
>
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
=====
Gabor Kincses
Running FreeBSD 4.7-RELEASE and Mandrake Linux 8.1
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
