Thread: prepareCall with batch?
Is there a way we can get this working? People have been bringing it up for years now 2007-03-21 18:37:46,290 INFO [http-8080-1] SpCueDaoJdbc - org.postgresql.util.PSQLException: A result was returned when none was expected. 2007-03-21 18:37:46,296 INFO [http-8080-1] SpCueDaoJdbc - org.postgresql.util.PSQLException: A result was returned when none was expected. 2007-03-21 18:37:46,297 INFO [http-8080-1] SpCueDaoJdbc - org.postgresql.util.PSQLException: A result was returned when none was expected. -Matt
Matt Chambers wrote: > Is there a way we can get this working? People have been bringing it up > for years now See thread "Utilizing executeBatch() with stored procedures". Requires a small change to the driver. -- Guy Rouillier
Actually I have a driver you can test. if you're interested. Dave On 22-Mar-07, at 2:05 AM, Guy Rouillier wrote: > Matt Chambers wrote: >> Is there a way we can get this working? People have been bringing >> it up for years now > > See thread "Utilizing executeBatch() with stored procedures". > Requires a small change to the driver. > > -- > Guy Rouillier > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >
Dave Cramer wrote: > Actually I have a driver you can test. > > if you're interested. Dave, sorry, I can't remember if I replied to this. I have a test case for executeBatch if you would make the driver available. Thanks. > Dave > On 22-Mar-07, at 2:05 AM, Guy Rouillier wrote: > >> Matt Chambers wrote: >>> Is there a way we can get this working? People have been bringing it >>> up for years now >> >> See thread "Utilizing executeBatch() with stored procedures". >> Requires a small change to the driver. >> >> --Guy Rouillier >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Guy Rouillier
Dave Cramer wrote: > Actually I have a driver you can test. > > if you're interested. Dave, sorry for the long delay in responding - at present, this is a background project. I tried the updated driver you supplied, and invoking stored procedures via executeBatch() is working. I have a long duration test (20 hrs) that I'll leave running. If any errors occur, I'll report back. Will you be submitting your change to the JDBC driver maintainers? > > Dave > On 22-Mar-07, at 2:05 AM, Guy Rouillier wrote: > >> Matt Chambers wrote: >>> Is there a way we can get this working? People have been bringing it >>> up for years now >> >> See thread "Utilizing executeBatch() with stored procedures". >> Requires a small change to the driver. >> >> -- >> Guy Rouillier >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Guy Rouillier
On 26-Apr-07, at 2:05 PM, Guy Rouillier wrote: > Dave Cramer wrote: >> Actually I have a driver you can test. >> if you're interested. > > Dave, sorry for the long delay in responding - at present, this is > a background project. I tried the updated driver you supplied, and > invoking stored procedures via executeBatch() is working. I have a > long duration test (20 hrs) that I'll leave running. If any errors > occur, I'll report back. > > Will you be submitting your change to the JDBC driver maintainers? As I am one, yeah ;) Dave > >> Dave >> On 22-Mar-07, at 2:05 AM, Guy Rouillier wrote: >>> Matt Chambers wrote: >>>> Is there a way we can get this working? People have been >>>> bringing it up for years now >>> >>> See thread "Utilizing executeBatch() with stored procedures". >>> Requires a small change to the driver. >>> >>> -- >>> Guy Rouillier >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 3: Have you checked our extensive FAQ? >>> >>> http://www.postgresql.org/docs/faq >>> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 4: Have you searched our list archives? >> http://archives.postgresql.org > > > -- > Guy Rouillier > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate