ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guy Rouillier <guyr-...@burntmail.com>
Subject Re: Beta 6 Oracle Invalid column type: getCLOB not implemented
Date Mon, 14 Dec 2009 05:36:14 GMT
On 12/13/2009 3:26 PM, Jeff Butler wrote:
> 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.

I built from head in SVN and it is working again for our application. 
Thanks, I'll update the issue.

>
> 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
>
>


-- 
Guy Rouillier

---------------------------------------------------------------------
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