From: "Brendan Caylor: Forgecom" <Brendan(at)forgecom(dot)co(dot)uk>
To: pgsql-jdbc(at)postgresql(dot)org
Subject:
Date: 2003-09-03 10:54:35
Message-ID: 5.1.0.14.0.20030903115145.00a88e20@10.10.10.16
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

To whom ever it may concern,

We are having trouble with what we think is the JDBC driver.

We can query a PostgreSQL database without problems except for when a query
that contains a field with a data type of decimal. When running a script,
the following runtime error occurs:

Message: General SQL Error
Tag Context: CFQUERY: Line=1; Column=1
Detail: Database reported: Bad Integer 1.95

It seems that its trying to interpret the value of the field, which in this
case is 1.95, as an integer and of course it isn't so bombs.

It would be interesting to know if anyone else has reported a similar
problem and if so what was the resulting fix to the bug.

What is going wrong here, any help would be much appreciated.

With many thanks in advance,

Brendan Caylor
Forgecom.

Responses

  • Re: at 2003-09-04 22:15:10 from Nick Fankhauser

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-09-03 11:26:56 Re: A JDBC bug or problem relating to string length in Java
Previous Message dipak pal 2003-09-03 10:26:21 A question?