I think it's jdbc driver converts your input to access text datatype.
text datatype is having limitation 255 characters.
But for memo you can store 65535 characters.
What kind of set method you are using.
setString or setAsciiStream or setObject
Try setObject method.
If you want to know what is the equivalent datatype in java then write the
following and check.
Statement stmt = conn.createStatement ();
DatabaseMetaData mData = conn.getMetaData();
ResultSet tables = mData.getColumns(null, null, "table name", null);
int numColumns=0;
while (tables != null && tables.next()) {
tableCat = tables.getString(1);
tableSchem = tables.getString(2);
tableName2 = tables.getString(3);
columnName = tables.getString(4);
dataType = tables.getShort(5);
typeName = tables.getString(6);
columnSize = tables.getInt(7);
bufferLength = tables.getObject(8);
decimalDigits = tables.getInt(9);
numPrecRadix = tables.getInt(10);
nullable = tables.getInt(11);
System.out.println();
System.out.println("tableCat:\t" + tableCat);
System.out.println("tableSchem:\t" + tableSchem);
System.out.println("tableName2:\t" + tableName2);
System.out.println("columnName:\t" + columnName);
System.out.println("dataType:\t" + dataType);
System.out.println("typeName:\t" + typeName);
System.out.println("columnSize:\t" + columnSize);
System.out.println("bufferLength:\t" + bufferLength);
System.out.println("numPrecRadix:\t" + numPrecRadix);
System.out.println("nullable:\t" + nullable);
System.out.println();
numColumns++;
}
System.out.println("***** Number of Columns ***** " + numColumns);
Thanks,
TAMIL
************************************
> ----- Original Message -----
> From: Paul Szynol
> To: [EMAIL PROTECTED]
> Sent: Tuesday, August 24, 1999 6:19 PM
> Subject: ACCESS
>
> >hello, everyone,
> >
> > is anyone out there working with access??
> >
> > i am having an on-going difficulty.
> >
> > preparedStatement truncates memo fields to 255.
>
> I believe that your problem is that Access has a 255 byte maximum field
> size.
>
> ----------------------------------------------------------------------------
> --------------
>
> Michael Katz
> Have Skills, Will Travel For Money
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
