PDA

View Full Version : Error when creating a new connection to Hypersonic database?



quanta
05-13-2008, 12:32 AM
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.

quanta
05-13-2008, 03:28 AM
Oh, sorry for my hastily previous post. I have not run start_hypersonic.sh in pentaho-demo folder.

Now, everything is OK.