Skip site navigation (1) Skip section navigation (2)

RE: can't parse "f"

From: "Skidmore, Walt" <walt(dot)skidmore(at)medinex(dot)com>
To: "'Adam Haberlach'" <adam(at)newsnipple(dot)com>
Cc: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: RE: can't parse "f"
Date: 2001-03-08 18:23:30
Message-ID: 965AEE931EB1D411BB0B00B0D0207AB90E1A3B@EXCH01 (view raw or flat)
Thread:
Lists: pgsql-jdbc
I was using the bit type, which resulted in a different error, but then I
switched to the bool type...  Here's the way I'm setting up the field:

-------
create table MDXProvider ( . . . outsideProvider bool not null . . . )
-------

Is there another way to set it up?  Should I be saying "outsideProvider
boolean not null"?

-----Original Message-----
From: Adam Haberlach [mailto:adam(at)newsnipple(dot)com]
Sent: Thursday, March 08, 2001 10:15 AM
To: Skidmore, Walt
Cc: 'pgsql-jdbc(at)postgresql(dot)org'
Subject: Re: [JDBC] can't parse "f"


On Thu, Mar 08, 2001 at 09:40:44AM -0800, Skidmore, Walt wrote:
> Does anybody know why I might be getting the following error?
> 
>
----------------------------------------------------------------------------
> --------
> java.sql.SQLException: ERROR:  pg_atoi: error in "f": can't parse "f"
>         at org.postgresql.Connection.ExecSQL(Connection.java:393)
>         at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
>         at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
>         at
>
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:
> 126)
>         at
>
medinex.server.entitybean.JOnASMDXProviderBean.ejbCreate(JOnASMDXProviderBea
> n.java:366)
>         at
>
medinex.server.entitybean.JOnASMDXProviderHome.create(JOnASMDXProviderHome.j
> ava:147)
>         at
>
medinex.server.entitybean.JOnASMDXProviderHome_Skel.dispatch(JOnASMDXProvide
> rHome_Skel.java:71)
>         at
> sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:319)
>         at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:187)
>         at sun.rmi.transport.Transport$1.run(Transport.java:142)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
>         at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
>         at
>
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:6
> 43)
>         at java.lang.Thread.run(Thread.java:484)
>
----------------------------------------------------------------------------
> ------------
> I looked in the offending code (which is generated by JOnAS
> <http://www.objectweb.org/jonas>), and it's using the setBoolean method to
> try to set a boolean.  I am using the bool data type in the table.
> According to the documentation, the bool type accepts 'f'.

	Is the field type actually boolean in the table?  It is using
pg_atoi,
which would seem to indicate that it is trying to deal with an integer
value...

-- 
Adam Haberlach            | "Having a smoking section in a restaurant is
adam(at)newsnipple(dot)com       | like having a peeing section in a swimming pool"
http://www.newsnipple.com |
'88 EX500    '00 >^<      |

pgsql-jdbc by date

Next:From: Gunnar R|nningDate: 2001-03-09 03:50:05
Subject: Re: Re: connection pooling in JDBC driver
Previous:From: Adam HaberlachDate: 2001-03-08 18:15:11
Subject: Re: can't parse "f"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group