Re: MS Access Issues

Tony LaPaso <[email protected]> Fri, 31 Jan 2003 20:30:31 -0600
Newsgroups gmane.comp.java.sun.webjava.advanced
Message-ID <000901c2c999$e4ac94d0$d9ddf80c@abner>
I don't think a Memo maps to a String. You may need to treat it as a Blob. I
know I've stored huge (several hundred MB) objects in OLE fields in Access
and was able to retrieve them just fine w/JDBC (ODBC/JDBC bridge) with no
problem. I thinkyou may need to treat the Memo field as a Blob and read it
in chunks.



----- Original Message -----
From: "S M Humayun" <[email protected]>
To: <[email protected]>
Sent: Tuesday, January 28, 2003 7:22 AM
Subject: MS Access Issues


> Hi all,
>
> I am working on an API which will be focused on Java connectivity with MS
Access database and will cover issues like forward and backword cursur
movement, paging, etc. I had succeeded till now and you guys will hear a
good news soon.
>
> I had encountered another strange problem, while retrieving data from MS
Access filed type "Memo", it returns null String (i.e. "") , did you guys
encountered the same problem ? any help in this regard would be appreciated
!
>
> regards,
>
> Humayun.
>
>
===========================================================================
> To unsubscribe, send email to [email protected] and include in the
body
> of the message "signoff WEBJAVA-ADVANCED".  For general help, send email
to
> [email protected] and include in the body of the message "help".
>

===========================================================================
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff WEBJAVA-ADVANCED".  For general help, send email to
[email protected] and include in the body of the message "help".