|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
Re: [JDBC] Batch Update problem
Date: Tue Jan 15 2008 - 03:41:43 EST
Hello and thank you.
I wrote a test case that is working correctly as expected. I'm not able to reproduce the issue unfortunetly:-(
I also looked into the JDBC Driver source code and I didn't find anything reasonable. The sources are the same for JDBC3 and JDBC3G.
So, I would like to close this issue and I'll investigate the problem more.
Thank you very much for your help!
Have a nice day,
PETR
On Jan 7, 2008 3:55 AM, Kris Jurka <books@ejurka.com> wrote:
>
>
> On Sun, 30 Dec 2007, Hadraba Petr wrote:
>
> > I have a global PreparedStatement pStmt that handles the UPDATE
> > statement.
> >
> > In for-cycle I'm doing the following:
> > - prepare values for the UPDATE
> > - call pStmt.clearParameters();
> > - call pStmt.setObject(paramOrderID, paramValue) for each value with
> > the right paramID and value
> > - call pStmt.addbatch();
> >
> > After the for-cycle I'm calling the pStmt.executeBatch(); and
> > pStmt.close();
> >
> > Please note, no Exceptions are thrown — the SQL code is correct and no
> > primary key nor foreign key valoations are occuring.
> >
> > I'm able to post full source code and more info.
> >
>
> Please post a full test case. I don't see any reason why Jdbc3 vs Jdbc3g
> would be any different.
>
> Kris Jurka
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
---------------------------(end of broadcast)---------------------------TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq Received on Tue Jan 15 03:47:02 2008
This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:42:52 EDT
|
Contact Us Legal Notices Order Services Online Pantek Home Privacy Policy IT news Site Map Pantek Library |