The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

cimakarocimakaro Member Posts: 1 Learner III
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

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee-RapidMiner, 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.