Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of jeffgbutler@gmail.com
 designates 209.85.211.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=I2AfnMY3HB5YBx3JgeQiA44usjqru0jMljh3Kb/za1wEb9kMXw1A/paP14zMiad0Bv
         vU0mIF4tlqnnx9kfw6cBO5sdDlT8dp5P88I/rG6tvf9crPMp4NVL36YAOKIyOOk8s7o7
         hM6RWXH4s2d47gPF5+glB3gLGqDobR0vMSyfc=
MIME-Version: 1.0
In-Reply-To: <4B212ADA.6040801@burntmail.com>
References: <4B211E2A.7000708@burntmail.com>
	 <c593b8750912100833n270ca0b4k12f32a1dead3d3d5@mail.gmail.com>
	 <4B212ADA.6040801@burntmail.com>
Date: Thu, 10 Dec 2009 11:19:47 -0600
Message-ID: <c593b8750912100919v316c8882v7da9c1302c9803bb@mail.gmail.com>
Subject: Re: Beta 6 Oracle Invalid column type: getCLOB not implemented
From: Jeff Butler <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: text/plain; charset=ISO-8859-1

JDBC 3 has always been a requirement. There was a change in this area
in ibatis but I don't recall the particulars right now. I'll need to
do a bit of research to recall.

Hmmm works on windows but not on linux? I'd double check to make sure
that there is not an older driver sneaking into the mix on linux.

Jeff Butler


On 12/10/09, Guy Rouillier <guyr-ml1@burntmail.com> wrote:
> On 12/10/2009 11:33 AM, Jeff Butler wrote:
>> This method (getCLOB) is a JDBC 3 method. You must now use a driver
>> that is JDBC 3 compliant.
>
> I'm using the ojdbc6.jar driver from 11g (although our databases are
> 10g, the 11g drivers are required for JDK 6.)  The Oracle JDBC FAQ says
> this about JDBC version support:
>
> Oracle 11.1.0 and 11.2.0 support:
>
>        Full support for JDBC 3.0 in the JDK 1.5 drivers.
>        Full support for JDBC 4.0 in the JDK 1.6 drivers with the
> exception of SQLXML which is not supported.
>
> I wouldn't think the JDBC 3 requirement was introduced between Beta 5
> and Beta 6, right?  The code works fine with the Beta 5 code.
>
> The best hint I could find with some quick Googling is that getCLOB
> should not be used to retrieve a VARCHAR column.  All the character
> columns in the table I supplied in the Jira issue are VARCHAR; the table
> has no CLOB columns.
>
> I'm also at a loss to figure out why everything works fine on Windows
> but fails on Linux.  Same Oracle driver, same JDK version, same Tomcat
> version.  Obviously, the VM is native code.
>
> Something has changed between Beta 5 and Beta 6 to cause this.
>
> Thanks.
>
>>
>> On 12/10/09, Guy Rouillier<guyr-ml1@burntmail.com>  wrote:
>>> I'm getting a catastrophic failure with Beta 6 that does not happen with
>>> Beta 5.  I opened Jira issue IBATIS-712 for this:
>>>
>>> https://issues.apache.org/jira/browse/IBATIS-712: Oracle Invalid column
>>> type: getCLOB not implemented for class
>>> oracle.jdbc.driver.T4CVarcharAccessor
>>>
>>> Thanks.
>>>
>>> --
>>> Guy Rouillier
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>>
>>>
>>
>
>
> --
> Guy Rouillier
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

-- 
Sent from my mobile device

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org