[JDBC] Fastpath error on solaris 2.8 pgsql 7.1.3

2001-08-27 Thread T . R . Missner
Anyone seen this error before? It doesn't happen every time I insert a blob so I assume the code is correct. Only happens occasionaly. I have no idea how to troubleshoot this problem. Any help would be appreciated. FastPath call returned ERROR: lo_write: invalid large obj descriptor (0) I

RE: [JDBC] Fastpath error on solaris 2.8 pgsql 7.1.3

2001-08-28 Thread T . R . Missner
So I wanted to thank you. Indeed I did have a thread problem in my application that caused the same connection to be used by more than one thread at time. Thus the occassional problem due to transactions being out of sync. t.r. missner level(3) communications Chris -- you can explicity call m

RE: [JDBC] Unterminated quoted string error.

2001-08-28 Thread T . R . Missner
I had a similar problem and fixed it by using a preparedStatement and setting the parameter of my string data using myPreparedStatement.setString(myString) t.r. missner level(3) communications -Original Message- From: Thomas O'Dowd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-05 Thread T . R . Missner
What I have is a connection pool. I initially grab 2 connections, one primary one secondary. If the insert fails on the primary connection I try the secondary, if it fails I simply delete the 2 I have and grab 2 more from the connection pool. After creating the new ones I have never seen it fai

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-05 Thread T . R . Missner
Chris, I had the same problem on the insert side and thought it went away but it is back and I am convinced it is related to more than one thread using the same connection at the same time. What I have done as a work around in the interim ( until I write my own connection manager class ) is ca

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-06 Thread T . R . Missner
I really don't understand why this is happening either. my current guess is that there is something going on in the way we are reusing connections. To answer your question I don't think there is any relationship between the 2 connections just that after the first one is corrupted I use the secon

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-06 Thread T . R . Missner
I am in the process of rewriting my connection pooling object. I'll share the results when i am finished later today I suspect. How are you determining whether a transaction is active? getAutoCommit? -Original Message- From: chris markiewicz [mailto:[EMAIL PROTECTED]] Sent: Thursday, Sept

Re: [JDBC] error - NOTICE: current transaction...MORE DETAIL...

2001-09-06 Thread T . R . Missner
I also built a linked list of available connections today and my problem has completly gone away. I have an intensly threaded app and it has been running now for several hours doing 1000's of inserts without the problem I was having before. I don't know how dave implemented his list but I have