You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Graham Lounder <gr...@caris.com> on 2003/11/25 20:00:06 UTC
MS Access Memo Field
Hey all,
I'm trying to save a string greater than 255 characters to a MS Access memo
field with no luck. I'm getting the following error:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]String data,
right truncated (null)
I've done some search on the internet and it seems this is a problem without
many solutions. I did notice that this was suppose to be fixed in rc4. I
did read that someone said that it might have something to do with the
autocommit setting?
Any Ideas?
Graham
========================================================================
Graham Lounder - Java Developer
CARIS Spatial Components Division
graham.lounder@caris.com
Phone: (506) 458-8533
Fax: (506) 459-3849
========================================================================
NO BINDING CONTRACT WILL RESULT FROM THIS EMAIL UNTIL SUCH TIME
AS A WRITTEN DOCUMENT IS SIGNED ON BEHALF OF THE COMPANY.
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
RE: MS Access Memo Field
Posted by Graham Lounder <gr...@caris.com>.
Thanks, that was the problem. I thought I had tried this earlier but I
guess not.
Cheers,
Graham
-----Original Message-----
From: news [mailto:news@sea.gmane.org]On Behalf Of TINO SCHÖLLHORN
Sent: November 26, 2003 4:14 AM
To: ojb-user@db.apache.org
Subject: Re: MS Access Memo Field
"Graham Lounder" <gr...@caris.com> schrieb im Newsbeitrag
news:000b01c3b386$57975170$b1caa8c0@caris.priv...
> Hey all,Hi,
as I can see you only have to set the data-type in your repository.xml of
the memo-field to LONGVARCHAR.
I have had the same problem, but now it is running fine.
Tino
>
> I'm trying to save a string greater than 255 characters to a MS Access
memo
> field with no luck. I'm getting the following error:
>
> java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]String
data,
> right truncated (null)
>
> I've done some search on the internet and it seems this is a problem
without
> many solutions. I did notice that this was suppose to be fixed in rc4. I
> did read that someone said that it might have something to do with the
> autocommit setting?
>
> Any Ideas?
>
> Graham
>
> ========================================================================
> Graham Lounder - Java Developer
> CARIS Spatial Components Division
> graham.lounder@caris.com
> Phone: (506) 458-8533
> Fax: (506) 459-3849
> ========================================================================
> NO BINDING CONTRACT WILL RESULT FROM THIS EMAIL UNTIL SUCH TIME
> AS A WRITTEN DOCUMENT IS SIGNED ON BEHALF OF THE COMPANY.
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: MS Access Memo Field
Posted by TINO SCH�LLHORN <ts...@tiscali.de>.
"Graham Lounder" <gr...@caris.com> schrieb im Newsbeitrag
news:000b01c3b386$57975170$b1caa8c0@caris.priv...
> Hey all,Hi,
as I can see you only have to set the data-type in your repository.xml of
the memo-field to LONGVARCHAR.
I have had the same problem, but now it is running fine.
Tino
>
> I'm trying to save a string greater than 255 characters to a MS Access
memo
> field with no luck. I'm getting the following error:
>
> java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]String
data,
> right truncated (null)
>
> I've done some search on the internet and it seems this is a problem
without
> many solutions. I did notice that this was suppose to be fixed in rc4. I
> did read that someone said that it might have something to do with the
> autocommit setting?
>
> Any Ideas?
>
> Graham
>
> ========================================================================
> Graham Lounder - Java Developer
> CARIS Spatial Components Division
> graham.lounder@caris.com
> Phone: (506) 458-8533
> Fax: (506) 459-3849
> ========================================================================
> NO BINDING CONTRACT WILL RESULT FROM THIS EMAIL UNTIL SUCH TIME
> AS A WRITTEN DOCUMENT IS SIGNED ON BEHALF OF THE COMPANY.
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org