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

cimakarocimakaro MemberPosts:1Contributor I
edited June 2019 inHelp
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

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:949Unicorn
    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

    问候

    Balázs
Sign InorRegisterto comment.