You will have to use clob's to store large strings in oracle.
Go to www.elephantwalker.com and login. If you don't have an account, create
one...its free.
Go to this request http://www.elephantwalker.com/rfa?id=86
There you can download a stateless session bean and oracle dao to store
large strings in oracle. A version of this bean is used on the site, and we
have tested it with EXTREMELY large strings.
I would not use any odbc bridge to do this....a real waste of time.
Regards,
the elephantwalker
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Lachezar
Dobrev
Sent: Thursday, September 13, 2001 8:51 AM
To: Orion-Interest
Subject: Oracle questions (Slightly OT)
Hello group.
I have urgent need of advise.
I use an Oracle DB. And I have problems.
1. When using a ThinDriver I can not save large strings, and it is a must
for me.
2. When using Oracle-Odbc-Jdbc-Ejb I can save the large strings, but...
Orion gets a lot of SQL exceptions, because of 'invalid character'. My
research shows, that while Oracle uses a DOT to express float numbers
(123.456) the jdbc-odbc bridge happens to use the COMMA for the delimiter,
because of my LOCAL settings. Then it just blows up steam.
So. My question is like is there any non-ODBC-using driver for Oracle,
that can handle large strings?
I'm in an urgent need for help, because the LOCAL settings change is not
an option.
Please any advice. PLEASE!
Lachezar
