Re: JDBC causing the connection to close after executing a COPY command

I am attaching the new patch.

For CopyInResponse, client will send a CopyFail message and server won't wait for the client input. For CopyOutResponse, exception is generated for only CopyOutResponse and not for every CopyData message. Also slightly changed the 'ignoring' mechanism from reading the message to ignore it to skipping the message. I hope this
will also improve the performance.

Altaf Malik
EnterpriseDB
http://www.enterprisedb.com/

Kris Jurka <books(at)ejurka(dot)com> wrote:

In the case of copying data from the server, if you do have a
large table, you'll generate a SQLException for every row of the copy
result which isn't great, but I guess it's better than failing completely.

Trying to copy out a single column table of 100k integers took about seven
minutes and 150 MB of memory here.

Also, it doesn't work for copying data to the server. In that case the
server is sitting waiting for data and the driver is waiting for the
server and nothing happens. That was the case before, so this is no
worse.

Do you have plans to work on this further or shall I apply just this minor
improvement?

Kris Jurka

Best Regards
Muhammad Altaf Malik
Sr. Software Engineer,
EnterpriseDB (SMC) (pvt) Ltd.
3rd floor, Software Technology Park,
Islamabad. Ph: +92 (051) 2873815
Cell: 0321-5177961

---------------------------------
Never miss a thing. Make Yahoo your homepage.