RE: [JDBC] Large Objects

2001-07-31 Thread chris markiewicz
anks chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kovács Péter Sent: Monday, July 30, 2001 3:12 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Daniel Fisher; [EMAIL PROTECTED] Subject: RE: [JDBC] Large Objects This would be the standard way of inserting Large Ob

RE: [JDBC] Large Objects

2001-07-29 Thread Kovács Péter
]; Daniel Fisher; [EMAIL PROTECTED] Subject: Re: [JDBC] Large Objects if you want to insert Large Objects, you need to use one of the setXXXStream of the statement, not setBytes. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to

RE: [JDBC] Large Objects

2001-07-29 Thread Dave Cramer
Yes, you have to commit the transaction at the end Con.commit(), or con.rollback() I think. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane Sent: July 29, 2001 4:20 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] Large

Re: [JDBC] Large Objects

2001-07-29 Thread Tom Lane
Daniel Fisher <[EMAIL PROTECTED]> writes: > I'm having some trouble inserting a large object into the database. > I'm fairly certain that the problem is in my java code because I wrote some quick >PHP code and it worked fine. > The main problem is I'm not getting any errors, so I'm kinda stumped.

Re: [JDBC] Large Objects

2001-07-27 Thread Nils O. Selåsdal
On Friday 27 July 2001 16:59, Daniel Fisher wrote: > I'm am attempting to make one of my Java servlets work with both MySQL & > Postgres. I'm having some trouble inserting a large object into the > database. I'm fairly certain that the problem is in my java code because I > wrote some quick PHP co

Re: [JDBC] Large Objects

2001-07-27 Thread Daniel Fisher
I tried that but I got the same results. -- Daniel Fisher On Friday 27 July 2001 12:36, you wrote: > You probably need to add a conn.commit(); statement after the > executeUpdate. > > Philip > > On Fri, 27 Jul 2001, Daniel Fisher wrote: > > I'm am attempting to make one of my Java servlets wor

Re: [JDBC] Large Objects

2001-07-27 Thread Daniel Fisher
Yeah that line is in my code. See the source below. -- Daniel Fisher On Friday 27 July 2001 12:13, you wrote: > Hi, > > You should verify that you are in a transactionnal mode ie this line might > appear : > myConnection.setAutoCommit(false); > > If not, you problem might be solved. > Hope thi

Re: [JDBC] Large Objects

2001-07-27 Thread Philip Crotwell
You probably need to add a conn.commit(); statement after the executeUpdate. Philip On Fri, 27 Jul 2001, Daniel Fisher wrote: > I'm am attempting to make one of my Java servlets work with both MySQL & Postgres. > I'm having some trouble inserting a large object into the database. > I'm fairly

RE: [JDBC] Large Objects

2001-07-27 Thread PERIN Pascal
Have a look at this : http://www.fr.postgresql.org/devel-corner/docs/postgres/jdbc-lo.html --- Pascal PERIN SESAM - Chargé de mission Tel : 33 1 47 15 49 66 Fax : 33 1 47 15 49 75 http://www.sesam.org --- > -Message d'origine- > De

RE: [JDBC] Large Objects

2001-07-27 Thread PERIN Pascal
Hi, You should verify that you are in a transactionnal mode ie this line might appear : myConnection.setAutoCommit(false); If not, you problem might be solved. Hope this helps Pascal --- Pascal PERIN SESAM - Chargé de mission Tel : 33 1 47 15 49 66 Fax : 33 1 47 15