Options

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

cimakarocimakaro Member Posts: 1 Contributor I
edited June 2019 in Help
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.
Tagged:

Answers

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    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
Sign In or Register to comment.