Subject | Re: Data Won't stick |
---|---|
Author | Kevin Herrmann |
Post date | 2005-07-20T07:48:31Z |
Found the issue -- was using Prepared Statement instead of Callable statement.
Works like a champ, now.
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Works like a champ, now.
> Message: 8Kevin Herrmann
> Date: Tue, 19 Jul 2005 09:18:51 -0000
> From: "Kevin Herrmann" <kevinherrmann@...>
> Subject: Data Won't stick
>
> Hi,
>
> I'm using FB 1.5.2 and the JDBC Driver 1.5.5. When I obtain a
> connection, I immediately call:
> setAutocommit(false);
>
> Then, I set up some prepared statements and call:
> commit();
>
> Subsequently, when data is available, I execute the prepared
> statements (one of which is an SP) and then call:
> commit();
>
> It behaves just fine, but no data is committed. I searched for some
> time to see if I was omitting something simple, but can't find a thing.
>
> TIA,
> Kevin
>
>
>
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 9
> Date: Tue, 19 Jul 2005 07:00:06 -0300
> From: Francisco Antonio Vieira Souza <avs1001@...>
> Subject: Query with ProgressBar
>
> Is there any way to perform large queries with a progressbar?
> Did anyone ever do this?
> (I have a query with about 10.000 records wich takes a bit long to show)
>
> Thanks in advance
>
>
>
>
> _______________________________________________________
> Yahoo! Acesso Grátis - Internet rápida e grátis.
> Instale o discador agora! http://br.acesso.yahoo.com/
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 10
> Date: Tue, 19 Jul 2005 12:19:22 +0200
> From: "Roman Rokytskyy" <rrokytskyy@...>
> Subject: Re: Data Won't stick
>
>
> > It behaves just fine, but no data is committed. I searched for some
> > time to see if I was omitting something simple, but can't find a thing.
>
> Can you prepare a stanalone test case?
>
> Roman
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 11
> Date: Tue, 19 Jul 2005 12:19:22 +0200
> From: "Roman Rokytskyy" <rrokytskyy@...>
> Subject: Re: Data Won't stick
>
>
> > It behaves just fine, but no data is committed. I searched for some
> > time to see if I was omitting something simple, but can't find a thing.
>
> Can you prepare a stanalone test case?
>
> Roman
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
>
>
> ------------------------------------------------------------------------
> Yahoo! Groups Links
>
>
>
>
> ------------------------------------------------------------------------
>
>
>
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs