Mailing-List: contact taglibs-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: taglibs-user@jakarta.apache.org
Message-ID: <005901c0f008$b1a662d0$01000001@dell>
Reply-To: "Yiyi Sun" <yiyisun@yahoo.com>
From: "Yiyi Sun" <yiyisun@yahoo.com>
To: "Morgan Delagrange" <morgand@apache.org>
Cc: <taglibs-user@jakarta.apache.org>
References: <Pine.BSF.4.21.0106061147520.23445-100000@localhost>
Subject: Re: DBTags and Memo fields
Date: Fri, 8 Jun 2001 06:48:40 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

As I said we cannot use DBTags with jdbc-odbc. I think that's a problem of
the driver. jdbc-odbc bridge too. The getColumnType() returns -1 on my memo
field.

Yiyi

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