Thanks for the tip, I tried it and it didn't do the trick. I suppose it is my Driver, I'm using JdbcOdbcBridge from SUN. I suppose that doesn't support more then 255.
Thanks again. "Gunter Sammet" <[EMAIL PROTECTED]> wrote: >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 > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
