Forum Stats

  • 3,814,142 Users
  • 2,258,826 Discussions
  • 7,892,587 Comments

Discussions

Cannot display table's data

649787
649787 Member Posts: 5
edited Nov 19, 2008 5:45PM in Data Integrator
Hi,

I am new to ODI. Started practicing the tutorial.
After launching the Desinger, I am not able to see the table data
Below is the exception.
I am following the steps according to the documentataion.

Am I missing any thing?.

java.sql.SQLException: socket creation error
at org.hsqldb.jdbc.jdbcUtil.sqlException(jdbcUtil.java:67)
at org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2451)
at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:188)
at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:166)
at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java)
at com.sunopsis.graphical.frame.a.jd.bE(jd.java)
at com.sunopsis.graphical.frame.bn.bz(bn.java)
at com.sunopsis.graphical.frame.a.jb.dj(jb.java)
at com.sunopsis.graphical.frame.a.jb.<init>(jb.java)
at com.sunopsis.graphical.frame.a.jd.<init>(jd.java)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.sunopsis.graphical.frame.bb.b(bb.java)
at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)
at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Unknown Source)
Tagged:

Answers

  • 649787
    649787 Member Posts: 5
    Hi,

    I got the solution.
    I have done the mistake before by closing the running command line windows for the Source Data server and Target Data server.

    What I have learned is --

    Keep open all the windows until finish the work.
This discussion has been closed.