Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Kitchen on 64 bit Vista

  1. #1
    Join Date
    Oct 2007
    Posts
    8

    Default Kitchen on 64 bit Vista

    There appears to be a problem with Kitchen on 64 bit Vista. I say this because I have seen the problem with a few other java apps.

    Spoon works fine. I use the 32 bit JVM. I use the JdbcOdbc bridge. I have an ODBC connection set up in ODBC WOW64. The whole process runs perfectly. (Thank you BTW.)

    When I go to run the .kjb file in Kitchen it fails with:
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    If I set up a similarly named connection in 64 bit ODBC it recognizes the connection now, but I get:
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] Invalid string or buffer length

    So, having seen this before, I would suggest that Kitchen is using a different, and incorrect, process to use ODBC, and you should change to what Spoon uses - which works.

    Thanks
    Alex

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Kettle uses the ODBC-to-JDBC bridge in the Java Runtime Environment.
    Perhaps you can try to install a 64-bit JRE and see if that helps your issue?
    If not, I would google for it, perhaps other people found a solution.

    Matt

  3. #3
    Join Date
    Oct 2007
    Posts
    8

    Default Spoon Works, Kitchen Does Not

    Thanks Matt, but you have a solution. Spoon works. So the request is that you do the same in Kitchen that you do in Spoon.

    Thanks,
    Alex

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Ah yes, I missed that bit.
    Mmm, perhaps the difference is in the batch files.

    The only thing I can see is that Spoon launches using "start javaw ..." and Kitchen using "java ..."
    I would surprised it would make a difference, but I can't think of anything else at the moment.

    Matt

  5. #5
    Join Date
    Oct 2007
    Posts
    8

    Default The Fix for Other 64 bit Users

    Just for those that follow in this path --
    the change to javaw (from java) is all it takes to make it work

  6. #6
    Join Date
    Nov 2008
    Posts
    1

    Default

    The problem is fixed replacing, inside kitchen.bat, last line by this one:


    start %WINDIR%\SysWoW64\java ...

    Original line is: java ...

    Hope this help.

  7. #7

    Default Getting a database connectivity error while running a kettle job on 64 bit windows 7

    Hello,

    I am trying to run a kettle job which requires connection to both Mysql database set up on my local host and DB2 database on the clients server. But while running the loader I get following error:

    ERROR 16-08 11:19:31,671 (LogWriter.javarintln:436) -Database join.0 - A database error occurred, stopping everything:
    Error occured while trying to connect to the database

    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] Invalid string or buffer length


    I did read this thread and see that there are suggestions to change java to javaw.

    Can some one direct me to the file in which I need to make this change or I would really appreciate if anyone could guide me in this matter.

    Thanks,
    Ayaz

  8. #8

    Default

    User mgalanme mentioned is was in kitchen.bat.

  9. #9

    Default

    Anybody faced this problem on Pentaho 4.2.1? I have faced this problem on kettle 4.2.1 and seen in spoon.bat, its already javaw there.
    Anyone can please help on this?
    Prashant D Shelke.

  10. #10
    Join Date
    Sep 2010
    Posts
    2

    Default

    I've the same problem on Pentaho 4.2.1 but I haven't that problem on Pentaho 4.1.2.1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.