Hi Molly ! 

I am arriving a bit late in the conversation but ... 
I got the same problem than you with an Access database, and, after having 
read your messages, I tried to use the getAsciiStream method.

I thought i could solve my problem by using : 

    InputStream inpStr = myResultSet.getAsciiStream("myColumn");

and then use  :

    int nbrOfBytesThatCanBeRead = inpStr.available();
    byte[] byteArray = new byteArray [nbrOfBytesThatCanBeRead];
    inpStr.read(byteArray);
    String strToReturn = new String(byteArray);

This code seems correct, but the inpStr.available(); method seems to 
provoke an exception each time I call it.

Have you met this problem too ?
What solution did u use to solve your problem ?
Maybe you could show me a part of your source code ?

Thanks in advance !

Jimmy






> I think i'll go for Geert's suggestion to use the getAsciiStream.
> But looking at the documentation, there don't seem to be any 
corresponding
> JAVA type that supports sql "LONGCHAR" type.
> 
> Anyway, all the complication in trying to use MsAccess database with JSP,
> defeats the whole purpose of using it in the first place, i.e. for a 
quick
> prototype for a small project.
> 
> But, i'd like to thank you all for the quick and helpful responses.
> 
> I've learnt a lot, simply by being on this mailing list.
> 
> Thanks,
> molly
>