Re: "No results were returned by the query" exceptions
От | Tim Lewis |
---|---|
Тема | Re: "No results were returned by the query" exceptions |
Дата | |
Msg-id | 3C9806A1.C5298F0C@hitwise.com обсуждение исходный текст |
Ответ на | Re: "No results were returned by the query" exceptions ("Dave Cramer" <Dave@micro-automation.net>) |
Ответы |
Re: "No results were returned by the query" exceptions
("Dave Cramer" <Dave@micro-automation.net>)
|
Список | pgsql-jdbc |
It doesn't appear to have anything to do with the locking. I have had it throw the same exception on a "select nextval ('my_sequence')" query which doesn't make any sense at all.
The machine is running an SMP kernel with two processes accessing the database (two database connections / driver instances etc). I have been running the same code for about a month in development using the previous driver with no problems. The development server was a single processor machine running a non-SMP kernel.
Tim.
Dave Cramer wrote:
Tim,The latest driver which is experimental doesn't throw an exception and I copied your lock as wellcan you try it, it is the dev driver on the jdbc site.let me know what else you find, if anythingDave-----Original Message-----For what its worth Dave, there are two places in my code where it the exception occurs and with both of them there is a prior statement to lock the table in share row exclusive mode. ie:
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tim Lewis
Sent: Tuesday, March 19, 2002 9:45 PM
To: Dave@micro-automation.net
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] "No results were returned by the query" exceptionsStatement st = db.createStatement();
st.executeUpdate("lock table tablex in share row exclusive mode");String statment = "select col1 from tablex where col2 = ?";
PreparedStatement ps = db.prepareStatement(statement);
ps.setString(1, col2text);
ResultSet rs = ps.executeQuery(); // <- Exception thrown here
It may be coincidental but I thought it would be remiss of me to leave it out.
Tim.
Dave Cramer wrote:
Yes,I can confirm that it does indeed throw an exception. I will have a look
at this shortly.Thanks,
Dave
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tim Lewis
> Sent: Tuesday, March 19, 2002 7:01 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] "No results were returned by the query" exceptions
>
>
> Hi people,
>
> Am I correct in assuming that the new driver now throws an
> exception when a "No results were returned by the query"
> occurs for a prepared sql statement. I have recently
> upgraded the driver from 7.1 to 7.2 and my application now
> throws this exception when a query returns no rows in the result set.
>
> Could someone clarify this with me.
>
> Thanks,
>
> Tim Lewis
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
В списке pgsql-jdbc по дате отправления:
Предыдущее
От: "Dave Cramer"Дата:
Сообщение: Re: "No results were returned by the query" exceptions