Yep, I think you got it Jeff. That is so odd, how both Derby and HSQLDB don't care if you use CLOB or String... regardless, it was a typo.
Thanks! Clinton On Sun, Dec 13, 2009 at 1:26 PM, Jeff Butler <jeffgbut...@gmail.com> 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. > > Jeff Butler > > > On Fri, Dec 11, 2009 at 11:10 PM, Guy Rouillier <guyr-...@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-...@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-...@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-unsubscr...@ibatis.apache.org > >>>>>> For additional commands, e-mail: user-java-h...@ibatis.apache.org > >>>>>> > >>>>>> > >>>>> > >>>> > >>>> > >>>> -- > >>>> Guy Rouillier > >>>> > >>>> --------------------------------------------------------------------- > >>>> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > >>>> For additional commands, e-mail: user-java-h...@ibatis.apache.org > >>>> > >>>> > >>> > >> > >> > > > > > > -- > > Guy Rouillier > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > >
