ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: Beta 6 Oracle Invalid column type: getCLOB not implemented
Date Sun, 13 Dec 2009 20:26:09 GMT
I believe I have found and fixed the error in iBATIS.  Please try
building from SVN and let me know if the issue is resolved.

Jeff Butler


On Fri, Dec 11, 2009 at 11:10 PM, Guy Rouillier <guyr-ml1@burntmail.com> wrote:
> I've posted an update to Jira issue IBATIS-712.  I can get this to fail
> repeatedly with a simple command line program, on either Windows or Linux,
> with either JDK 5 or JDK 6 and any Oracle driver appropriate for the JDK
> version.  We are using Oracle 10g 10.0.2.0.3.
>
> Please let me know what else I can do to assist in debugging this.  This is
> an obvious showstopper for us to deploy our app with iBATIS.
>
> Thanks.
>
> On 12/10/2009 1:06 PM, Guy Rouillier wrote:
>>
>> On 12/10/2009 12:19 PM, Jeff Butler wrote:
>>>
>>> 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.
>>
>> I created a simple JSP in the same Tomcat context as our application, to
>> make sure it would load the same JDBC driver as our app. Here is what I
>> executed:
>>
>> <%
>> ... get a connection
>> DatabaseMetaData dmd = conn.getMetaData();
>> aDriverVersion = dmd.getDriverVersion();
>> %>
>>
>> <p> Driver version: <%= aDriverVersion %>
>>
>>
>> On both Windows and Linux, the result is
>>
>> Driver version: 11.2.0.1.0
>>
>> Please let me know if I can help in any way to isolate this issue. Thanks.
>>
>>>
>>> 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
>>>>
>>>>
>>>
>>
>>
>
>
> --
> Guy Rouillier
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

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


Mime
View raw message