Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Error when creating a new connection to Hypersonic database?

  1. #1
    Join Date
    May 2008
    Posts
    4

    Default Error when creating a new connection to Hypersonic database?

    I have downloaded PME and installed it successfully. But when I setting up the database connections with: below informations:
    + Connection name: HySampleData
    + Connection Type: Hypersonic
    + Mothod of access: JNDI
    + Database Name: SampleData

    Click to Test button, I get error:
    Error connecting to database [HySampleData] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Invalid JNDI connection SampleData : socket creation error


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Invalid JNDI connection SampleData : socket creation error


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:317)
    at org.pentaho.di.core.database.Database.connect(Database.java:266)
    at org.pentaho.di.core.database.Database.connect(Database.java:228)
    at org.pentaho.di.core.database.Database.connect(Database.java:218)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:54)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2474)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1919)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1901)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:311)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:386)
    at org.pentaho.pms.editor.MetaEditor.editConnection(MetaEditor.java:2598)
    at org.pentaho.pms.editor.MetaEditor.doubleClickedMain(MetaEditor.java:2450)
    at org.pentaho.pms.editor.MetaEditor.widgetDefaultSelected(MetaEditor.java:3962)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.pms.editor.MetaEditor.readAndDispatch(MetaEditor.java:810)
    at org.pentaho.pms.editor.MetaEditor.main(MetaEditor.java:3587)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Invalid JNDI connection SampleData : socket creation error

    at org.pentaho.di.core.database.Database.initWithJNDI(Database.java:335)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:350)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:301)
    ... 23 more

    Hostname : localhost
    Port :
    Database name : SampleData
    This is my jdbc.properties file:
    SampleData/type=javax.sql.DataSource
    SampleData/driver=org.hsqldb.jdbcDriver
    SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
    SampleData/user=pentaho_user
    SampleData/password=password
    Quartz/type=javax.sql.DataSource
    Quartz/driver=org.hsqldb.jdbcDriver
    Quartz/url=jdbc:hsqldb:hsql://localhost/quartz
    Quartz/user=pentaho_user
    Quartz/password=password
    Hibernate/type=javax.sql.DataSource
    Hibernate/driver=org.hsqldb.jdbcDriver
    Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate
    Hibernate/user=hibuser
    Hibernate/password=password
    Shark/type=javax.sql.DataSource
    Shark/driver=org.hsqldb.jdbcDriver
    Shark/url=jdbc:hsqldb:hsql://localhost/shark
    Shark/user=sa
    Shark/password=
    Can anyone help me to create a new connection? Thanks in advance.

  2. #2
    Join Date
    May 2008
    Posts
    4

    Default

    Oh, sorry for my hastily previous post. I have not run start_hypersonic.sh in pentaho-demo folder.

    Now, everything is OK.

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.