pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedJDBC for 7.0 - Tuple received before MetaData exception
4+ messages / 2 participants
[nested] [flat]
* JDBC for 7.0 - Tuple received before MetaData exception
@ 2000-05-25 12:35 Gunnar R|nning <gunnar@candleweb.no>
0 siblings, 0 replies; 4+ messages in thread
From: Gunnar R|nning @ 2000-05-25 12:35 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
I'm currently going over my log files to search for suspect error
messages. I found one suspicous error message(I only have one instance of
this exception in my log files). Does anybody know what the reason for this
error could be ? e.g. something on the database server side, concurrency
problems etc.
Regards,
Gunnar
[abJDBCServer] doQuery(LocationDS) "SELECT LOC_ID , LOC_TYPE , LOC_NAME , LOC_PARENT FROM LOCATION WHERE LOC_PARENT IS NULL AND NOT LOC_TYPE=0 ORDER BY LOC_NAME"
abJDBCServer: handle open link exception = Tuple received before MetaData.
Tuple received before MetaData.
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(Compiled Code)
at org.postgresql.util.PSQLException.<init>(PSQLException.java:22)
at org.postgresql.Connection.ExecSQL(Compiled Code)
at org.postgresql.jdbc2.Statement.execute(Compiled Code)
at org.postgresql.jdbc2.Statement.executeQuery(Compiled Code)
at progress.apptivity.agent.server.abJDBCServer.doQueryImpl(Compiled Code)
at progress.apptivity.agent.server.abJDBCServer.doQueryImpl(Compiled Code)
at progress.apptivity.agent.server.abJDBCServer.doQuery(Compiled Code)
at progress.apptivity.agent.server.abJDBCServer.serverRequest(Compiled Code)
at SearchFasterServerEvents.serverRequest(Compiled Code)
at progress.apptivity.server.abServer.serverRequest(Compiled Code)
at progress.apptivity.server.abQuerySetImpl.serverRequest(Compiled Code)
at progress.apptivity.client.iiop._abQuerySetImplBase.invoke(Compiled Code)
at IE.Iona.OrbixWeb.CORBA.ServerDispatcher.dispatch(Compiled Code)
at IE.Iona.OrbixWeb.CORBA.ServerDispatcher.system_dispatch(Compiled Code)
at IE.Iona.OrbixWeb.CORBA.BOAImpl.continueThreadDispatch(Compiled Code)
at IE.Iona.OrbixWeb.CORBA.ORB.continueThreadDispatch(Compiled Code)
at progress.apptivity.server.iiop.ow.a25.run(Compiled Code)
at java.lang.Thread.run(Compiled Code)
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: JDBC for 7.0 - Tuple received before MetaData ex ception
@ 2000-05-26 06:29 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Mount @ 2000-05-26 06:29 UTC (permalink / raw)
To: 'Gunnar R|nning' <gunnar@candleweb.no>; pgsql-interfaces
Not sure, but the only way this could happen is what it states: It's
getting tuples before it's expecting to get them.
Are you running multiple threads on the same connection?
Anyhow, the query looks innocent.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Gunnar R|nning [mailto:gunnar@candleweb.no]
Sent: Thursday, May 25, 2000 1:35 PM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] JDBC for 7.0 - Tuple received before MetaData
exception
Hello,
I'm currently going over my log files to search for suspect error
messages. I found one suspicous error message(I only have one instance
of
this exception in my log files). Does anybody know what the reason for
this
error could be ? e.g. something on the database server side, concurrency
problems etc.
Regards,
Gunnar
[abJDBCServer] doQuery(LocationDS) "SELECT LOC_ID , LOC_TYPE , LOC_NAME
, LOC_PARENT FROM LOCATION WHERE LOC_PARENT IS NULL AND NOT LOC_TYPE=0
ORDER BY LOC_NAME"
abJDBCServer: handle open link exception = Tuple received before
MetaData.
Tuple received before MetaData.
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(Compiled Code)
at
org.postgresql.util.PSQLException.<init>(PSQLException.java:22)
at org.postgresql.Connection.ExecSQL(Compiled Code)
at org.postgresql.jdbc2.Statement.execute(Compiled Code)
at org.postgresql.jdbc2.Statement.executeQuery(Compiled Code)
at
progress.apptivity.agent.server.abJDBCServer.doQueryImpl(Compiled Code)
at
progress.apptivity.agent.server.abJDBCServer.doQueryImpl(Compiled Code)
at progress.apptivity.agent.server.abJDBCServer.doQuery(Compiled
Code)
at
progress.apptivity.agent.server.abJDBCServer.serverRequest(Compiled
Code)
at SearchFasterServerEvents.serverRequest(Compiled Code)
at progress.apptivity.server.abServer.serverRequest(Compiled
Code)
at
progress.apptivity.server.abQuerySetImpl.serverRequest(Compiled Code)
at
progress.apptivity.client.iiop._abQuerySetImplBase.invoke(Compiled Code)
at IE.Iona.OrbixWeb.CORBA.ServerDispatcher.dispatch(Compiled
Code)
at
IE.Iona.OrbixWeb.CORBA.ServerDispatcher.system_dispatch(Compiled Code)
at
IE.Iona.OrbixWeb.CORBA.BOAImpl.continueThreadDispatch(Compiled Code)
at IE.Iona.OrbixWeb.CORBA.ORB.continueThreadDispatch(Compiled
Code)
at progress.apptivity.server.iiop.ow.a25.run(Compiled Code)
at java.lang.Thread.run(Compiled Code)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: JDBC for 7.0 - Tuple received before MetaData ex ception
@ 2000-05-26 09:24 Gunnar R|nning <gunnar@candleweb.no>
parent: Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Gunnar R|nning @ 2000-05-26 09:24 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: 'Gunnar R|nning' <gunnar@candleweb.no>; pgsql-interfaces
Peter Mount <petermount@it.maidstone.gov.uk> writes:
> Not sure, but the only way this could happen is what it states: It's
> getting tuples before it's expecting to get them.
>
> Are you running multiple threads on the same connection?
Hopefully not, but we've had concurrency issues with the application at
earlier stages, so I guess this still could be an issue. Guess, I'll have
to back into code review mode to resolve this one...
regards,
Gunnar
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: JDBC for 7.0 - Tuple received before MetaData ex ception
@ 2000-05-30 07:04 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Mount @ 2000-05-30 07:04 UTC (permalink / raw)
To: 'Joseph Shraibman' <jks@selectacast.net>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: 'Gunnar R|nning' <gunnar@candleweb.no>; pgsql-interfaces
No you can run multiple threads, as long as it is one statement per thread.
My thinking at the time was that your code may not have been running one
statement per thread, or that the locking on PG_Stream wasn't working
properly.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Joseph Shraibman [mailto:jks@selectacast.net]
Sent: Friday, May 26, 2000 8:11 PM
To: Peter Mount
Cc: 'Gunnar R|nning'; pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] JDBC for 7.0 - Tuple received before MetaData
exception
Peter Mount wrote:
>
> Not sure, but the only way this could happen is what it states: It's
> getting tuples before it's expecting to get them.
>
> Are you running multiple threads on the same connection?
>
You mean you can't do that? I thought you couldn't on the same
Statement. My code creates one connection object and gets a statement
from it for each thread.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-05-30 07:04 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-25 12:35 JDBC for 7.0 - Tuple received before MetaData exception Gunnar R|nning <gunnar@candleweb.no>
2000-05-26 06:29 RE: JDBC for 7.0 - Tuple received before MetaData ex ception Peter Mount <petermount@it.maidstone.gov.uk>
2000-05-26 09:24 ` Re: JDBC for 7.0 - Tuple received before MetaData ex ception Gunnar R|nning <gunnar@candleweb.no>
2000-05-30 07:04 RE: JDBC for 7.0 - Tuple received before MetaData ex ception Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox