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

4.2 DatabaseExampleSource problem

haddockhaddock Member Posts: 849 Maven
edited November 2018 in Help
Hi!

I've just upgraded to 4.2 and find that a DatabaseExampleSource that worked fine under 4.1 now produces the following error..

P Jul 16, 2008 2:43:53 PM: [Fatal] UserError occured in 1st application of DatabaseExampleSource  (DatabaseExampleSource)
P Jul 16, 2008 2:43:53 PM: [Fatal] Process failed: Database error occured: The fetch size cannot be negative.

Furthermore if I use the configuration wizard no tables get picked up. I've tried both the MS and JTDS  SQL drivers and get the same result. Does anybody know what causes this behaviour?

Answers

  • alxalx Member Posts: 1 Learner III
    Which database are you using?

    I hit the same problem with PostgreSQL today. Obviously, a MySQL specific hack leaked into the DatabaseHandler class. The fetch size is set to Integer.MIN_VALUE unconditionally. However, this is a very MySQL specific way to tell the JDBC driver not to fetch the entire result set and I would suspect DatabaseExampleSource to break on anything but MySQL.
  • haddockhaddock Member Posts: 849 Maven
    Hi Aix,

    I'm using MS SQL 2005  :( All very strange...

  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Yip. This accidentally slipped in - working on MySQL most of our time and somebody (probably myself) accidentally checked in this hack. We are currently working on a workaround and will release it as soon as possible. Sorry for the inconvenience.

    Cheers,
    Ingo
  • haddockhaddock Member Posts: 849 Maven
    Thanks Ingo and Aix, another bout of sanity doubting avoided  ;D
  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Hi,

    we just exchanged the files of the 4.2 release. Please download the release again from SourceForge (links are available on our web site - just use the normal download links).

    Sorry again for the inconvenience.

    Cheers,
    Ingo
  • haddockhaddock Member Posts: 849 Maven
    NIce one Ingo - all runs fine now. Many thanks for such a quick remake.
  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    You are welcom. And thanks for the response - good to know that it works on at least one another system  ;)

    Cheers,
    Ingo
Sign In or Register to comment.