Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: domain of
 gcjiu-ibatis-user-java@m.gmane.org designates 80.91.229.2 as permitted
 sender)
To: ibatis-user-java@incubator.apache.org
From: Francisco Leon <fleona@cantv.net>
Subject: Re: CLOBs with Oracle 9i
Date: Thu, 28 Apr 2005 15:26:27 +0000 (UTC)
Lines: 28
Message-ID: <loom.20050428T172235-350@post.gmane.org>
References: <20050428044613.88996.qmail@web20821.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
User-Agent: Loom/3.14 (http://gmane.org/)
Sender: news <news@sea.gmane.org>


> As Richard has already said, the 10g drivers should
> work.  If that is not possible or practical in your
> environment, however, there is a way to create a
> TypeHandler implementation that handles Oracle clobs
> using the 9i thin driver and which doesn't suffer from
> the 4000 character limit issue.  The caveat is that
> you need to be using iBatis in conjunction with the
> Spring framework and also need to be running the
> queries inside transactions (which is simple if you're
> using Spring anyway).

I am using the ojdbc14.jar but connecting with a "jdbc:oracle:thin...." url
because i was told that connecting this way doesn't require any additional
oracle software.
I have a table with an attribute that uses a CLOB. I need to be able to
insert it (i am using transactions there), query it, search it, etc.
Using spring is really not an option.

The application already runs fine on postgresql. The oracle 9i docs say
varchar2 is limited to 4000 bytes, it doesn't say anything about a jdbc
bug (ok, i don't think they would say it's a bug anyway)

If i can get the same functionality with just replacing ojdbc14.jar with
the oracle 10g version i guess that's my answer, i will try it.

If there's any other info you need to help me please let me know.
Thanks