hi all,
with getString("...") one can read text fields from an table.
with getInt("...") one can read fields with numbers from an table
....so far so good but:
HOW CAN I READ MEMO FIELDS WITH JDBC-ODBC ?
i have an access db with a text field which contents more than 255 characters ==> access reformates this to a memo field.
any help will be appreciated.
thanx,
andi
You can try to use getAsciiStream or getBinaryStream.
byte[] buffer = new byte[4096];
int size;
StringBuffer buf = new StringBuffer();
InputStream strin =rs.getAsciiStream(i); //The memo field
if(strin != null){
for(;;){
size = strin.read(buffer);
if(size <= 0){
break;
}
buf.append(new String
(buffer,0,size));
}
System.out.println(buf);
> You can try to use getAsciiStream or getBinaryStream.
> >byte[] buffer = new byte[4096];
>int size;
>StringBuffer buf = new StringBuffer();
> InputStream strin =rs.getAsciiStream(i); //The
> //The memo field
>if(strin != null){
>for(;;){
>size = strin.read(buffer);
>if(size <= 0){
>break;
>}
>buf.append(new String
>(buffer,0,size));
>}
>System.out.println(buf);
>
I have a question about your code.
Can you explain me why the size of "byte[] buffer" shoud be 4096?
Hi All,
Yes, you can read MEMO using JDBC-ODBC Bridge.
No, getObject(..) and casting them to String wo'nt work for Memo.
You need to treat MEMO as an InputStream and has to retrieve the data as follows :
--
String temp = "";
try
{
if(is != null)
{
InputStreamReader isr = new InputStreamReader(rs.getAsciiStream(i));
int c = 0;
while(c != -1)
{
c = isr.read();
if(c != -1)
temp += (char)c;
}
}
else
temp = null;
}
catch(IOException e)
{
throw new SQLException("Custom SQLException : Unable to open stream for MEMO field because " + e.toString());
}
return temp;
--
I hope this will help u guys.
regards,
Humayun
