Hmm, doesn't sounds quite right. The getColumn tag only uses the
getClob() method for CLOB data types; in all other cases, it uses
getString(). This sounds like a driver issue, but I can't be certain.
On Tue, 5 Jun 2001, Yiyi Sun wrote:
> Hi Morgan,
>
> The memo type is very useful to store the large text. I used to use the
> getString(...) method of the Statement class to read memo fields while using
> the jdbc-odbc bridge and MS Access.
>
> I found in the source that the GetColumnTag class uses JDBC 2.0's Clob class
> . In JDK1.3 and beofore, the jdbc-odbc bridge is only JDBC 1.1. In JDK1.4
> the bridge will be JDBC 2.0 that could support Clob. Until the finaly
> release of JDK1.4 in Q4 of this year, it seems that we cannot use DBTags
> with jdbc-odbc.
>
> Is it right?
>
> Cheers!
>
> Yiyi
>
>
>
> > I've never heard of the memo type. Have you successfully accessed memo
> > fields with JDBC drivers? If so, how did you do it?
> >
> > It's possible that memo fields are not supported by your JDBC drivers.
> >
> > On Sat, 2 Jun 2001, Yiyi Sun wrote:
> >
> > > Hi All,
> > >
> > > When I am using DBTags with jdbc:odbc and MS Access database, the
> > > <sql:getColumn ... /> Tag raises java.sql.SQLException if the fields to
> be
> > > read are of memo type.
> > >
> > > Any workaround or suggestion? Thanks
> > >
> > > Yiyi
> > >
> > >
>
>
