Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Writing to H2 Database (SampleData)

  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Default Writing to H2 Database (SampleData)

    I am newbie to Pentaho and have installed the Data Integration suite (Kettle). Stepping through the "Getting Started with DI" documentation I have used Spoon and created a basic transformation with the Sales Data.

    When I got to the "Load Your Data into a Relational Database" I hit a problem that the test connection to the proposed SampleData H2 database failed with the key message:
    'Error connecting to database (using class org.h2.Driver)
    Connection is broken "session closed" [90067-131]'

    I can potenially get around this by using MS SQL Server, but wanted to check if I can use H2 or am I misreading the documentation which seems to imply H2 is bundled with the Data Integration Server.

    Thanks in advance

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by jimstrebor View Post
    or am I misreading the documentation which seems to imply H2 is bundled with the Data Integration Server.
    The document I think you refer to addresses users of the Enterprise Edition.
    I guess you have installed the Community Edition (CE).
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2013
    Posts
    2

    Default

    Thanks, thought it might be something like that. I will use another database system.

Tags for this Thread

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.