Fred, try to set autocommit to false and then manually commit your transaction. I vaguely remember some problem we had in a JDBC course with Access, where the autocommit caused some headache. Let us know if it worked! HTH Gunter
:-) -----Original Message----- :-) From: Ben Groeneveld [mailto:[EMAIL PROTECTED]] :-) Sent: Monday, January 14, 2002 10:16 AM :-) To: JRun-Talk :-) Subject: Re: LongTexts :-) :-) :-) Fred, this sounds related to msaccess and not JDBC. I :-) regularly update :-) oracle text fields via JDBC that are 3200 wide. Maybe see if there :-) isn't another datatype you can use. Hope that helps. BenG. :-) :-) Fred Schroomnig wrote: :-) :-) >Hi All, I have an access DB for fooling about on. I'm :-) trying to enter a text Longer then 255 characters into a :-) 'memo' field. I'm using a PreparedStatement and my code :-) looks something like this: :-) > :-) >ps = conn.prepareStatement("INSERT INTO table (First, :-) Last, eMail,comment) VALUES(?, ?, ?, ?)"); :-) >ps.setString(1, request.getParameter("First")); :-) >ps.setString(2, request.getParameter("Last")); :-) >ps.setString(3, request.getParameter("eMail")); :-) >ps.setString(4, request.getParameter("comment")); :-) > :-) >It works fine if the 'comments' value is less the or equal :-) to 255 Characters, it crahses with an error telling me that :-) the String is to long. The question is how do I enter :-) Strings longer then 255 chars into a DB using JDBC? :-) > :-) >Tahnks in advance, :-) > :-) >Chris :-) > :-) :-) -- :-) Ben Groeneveld :-) Information Concepts, Inc., 115 N.W. Oregon, Suite 30, :-) Bend, OR 97701 :-) Mailto:[EMAIL PROTECTED], phone:541.388.3611, :-) cell:208.520.6488 :-) :-) :-) ____________________________________________________________ :-) __________ :-) Structure your ColdFusion code with Fusebox. Get the :-) official book at http://www.fusionauthority.com/bkinfo.cfm :-) Archives: http://www.mail-archive.com/[email protected]/ :-) Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
