Re: resultset.first() untrappable error

Поиск
Список
Период
Сортировка
От Nick Fankhauser
Тема Re: resultset.first() untrappable error
Дата
Msg-id NEBBLAAHGLEEPCGOBHDGEEDIIAAA.nickf@ontko.com
обсуждение исходный текст
Ответ на resultset.first() untrappable error  (kevin@mtel.co.uk (kevin))
Список pgsql-jdbc
By "bombing", do you mean no error message at all? What behavior lets you
know that it has failed? Especially if the code once worked and wasn't
changed when it started failing, we'll need a description of what you're
seeing (or not seeing) when it fails.

-Nick

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of kevin
> Sent: Friday, August 15, 2003 9:12 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] resultset.first() untrappable error
>
>
> the following code frag has recently started bombing in a bean. It
> produces no trappable error I can see (SQLException, Exception,
> RuntimeException all fail) and is bombing at the ResultSet.first()
> function call. Its using redhat 7.3 postgres jdbc pg73b1jdbcX jars.
> The db is 7.3.2. jdk is sun
> hotspot 1.41-b21. The sql works in a file with hard coded customer id.
>
>         query = "SELECT TO_CHAR(break,'MI9999990D99') as value," +
>                     "       TO_CHAR(discount,'MI9999990D99') " +
>                     "  FROM customer " +
>                     " WHERE id='" + custid + "'" +
>                     "   AND discount > 0 " +
>                     " UNION " +
>                     "SELECT TO_CHAR(value,'MI9999990D99')," +
>                     "       TO_CHAR(discount,'MI9999990D99') " +
>                     "  FROM discountbyvalue " +
>                     " WHERE account='" + custid + "' " +
>                     " ORDER BY value";
>
>         results = stmt.executeQuery(query);
>
>              // only output discounts if there are some */
>             if( ! results.first() ){
>         results.close();
>         stmt.close();
>         return "";
>         }
>
> Anybody got an idea why?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: kevin@mtel.co.uk (kevin)
Дата:
Сообщение: resultset.first() untrappable error
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [BUGS] Bug #926: if old postgresql.jar in CLASSPATH, ant fails