"Database error occurred: Bad value for type int: 3509662254"

cimakaro

I have connected to a postgres database and in the connection have a simple query that just says "select state from tablename".  When I hit the execute button to execute the query: I receive this error:
Database error occurred: Bad value for type int: 3509662254. The JDBC driver has thrown an SQLException.  This may because of a lack of priveleges, wrong table name or url or similar problems.  Please note that some databases are case sensitive.  Details are given in the message.  Reason: Bad value for type int: 3509662254

I am running Rapid Miner on Windows 7 and connecting to a 9.1 postgres database running on Linux.  Any ideas what this error means?

Thanks.

BalazsBaranyRM

Which data type is the state field?

Maybe its data type is wrongly identified by the JDBC driver.

Try casting the value to a defined type:

SELECT state::bigint FROM tablename

Regards

Balázs