Topic
  • 14 replies
  • Latest Post - ‏2012-05-15T12:58:09Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts

Pinned topic oracle jdbc connection prolem. Please see console output

‏2011-06-25T12:01:55Z |
"oracle jdbc connection prolem. Please see console output"
I'm getting the above error when i'm trying to connect in Oracle Express 10g using the IBM data movement tool. I have included the xdb.jar, xdb_g.jar, ojdbc14.jar, ojdb14_g.jar which were in the oracle server folders. What must be the issue?? What can i do to rectify this
Updated on 2012-05-15T12:58:09Z at 2012-05-15T12:58:09Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T12:27:21Z  
    There might be several issues involved here like port not open or firewall issues. The tool's console might be hiding behind the GUI and it will have the exception. Look for the SQL error code in the exception and that will hold the clue why connection is not taking place.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T12:56:10Z  
    There might be several issues involved here like port not open or firewall issues. The tool's console might be hiding behind the GUI and it will have the exception. Look for the SQL error code in the exception and that will hold the clue why connection is not taking place.
    Well thats one of the problem i have. i cant find the console? do u know how i can visualize it so i can look for the sql error?
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T13:21:43Z  
    There might be several issues involved here like port not open or firewall issues. The tool's console might be hiding behind the GUI and it will have the exception. Look for the SQL error code in the exception and that will hold the clue why connection is not taking place.
    Hi Anabas,.....thanks again for your reply...to give a bit more background about my problem. I am using DB2 9.7 and Oracle Express 10g. In the IBM data movement tool I connected to DB2 sucessfully. But I cannot connect to Oracle. I am very sure my settings are correct. The Error message that I got for oracle is ""oracle jdbc connection prolem. Please see console output"". I used the following combination of jars http://ojdbc14.jar, ojdb14_g.jar,xmlparserv2.jar,xdb.jar, xdb_g.jar, http://ojdbc5.jar,xmlparserv2.jar,xdb.jar , http://ojdbc6.jar, xmlparserv2.jar,xdb.jar. IF there are firewall issues can I rectify them on the IBM data movement tool side? .....Additionaly like i mentioned before ....how can I get the console to show up? :)
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T13:46:53Z  
    Hi Anabas,.....thanks again for your reply...to give a bit more background about my problem. I am using DB2 9.7 and Oracle Express 10g. In the IBM data movement tool I connected to DB2 sucessfully. But I cannot connect to Oracle. I am very sure my settings are correct. The Error message that I got for oracle is ""oracle jdbc connection prolem. Please see console output"". I used the following combination of jars http://ojdbc14.jar, ojdb14_g.jar,xmlparserv2.jar,xdb.jar, xdb_g.jar, http://ojdbc5.jar,xmlparserv2.jar,xdb.jar , http://ojdbc6.jar, xmlparserv2.jar,xdb.jar. IF there are firewall issues can I rectify them on the IBM data movement tool side? .....Additionaly like i mentioned before ....how can I get the console to show up? :)
    It will be a good idea to go through the article.

    If you do not see a console, chances are that you are double clicking the JAR file and that is not the way to run the tool.

    Double check above and run the tool again and you will see the error message in the console.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T14:51:30Z  
    It will be a good idea to go through the article.

    If you do not see a console, chances are that you are double clicking the JAR file and that is not the way to run the tool.

    Double check above and run the tool again and you will see the error message in the console.
    I was in a rush and apparently i was using the jar file to open the IBM Data Movement Tool. Now I opened it the proper way and I have the console . Below is the SQL error i am receiving.Again I am at a loss on how to rectify this error. Any suggestions would be greatly welcome :)

    http://2011-06-25 19.35.58.468 All input parameters are saved in 'C:\Users\niranogoledi\Do
    wnloads\IBM data movement tool\migr\IDMTConfig.properties' file.
    JAR file 'C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar' fou
    nd
    JAR file 'C:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\jlib\xdb.jar' found

    JAR file 'C:\Users\nirandi\Downloads\xmlparserv2.jar' found
    http://2011-06-25 19.41.31.268 Driver oracle.jdbc.driver.OracleDriver loaded
    http://2011-06-25 19.41.38.175 Error connecting : oracle.jdbc.driver.OracleDriver for
    oracle Error Message :Io exception: Got minus one from a read call
    http://2011-06-25 19.41.38.178 oracle JDBC connection problem. Please see console's o
    utput.
    java.sql.SQLException: Io exception: Got minus one from a read call
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
    414)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
    n.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at ibm.DBData.getConnection(DBData.java:330)
    at ibm.IBMExtractUtilities.TestConnection(IBMExtractUtilities.java:1770)

    at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:850)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
    ce)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
    JAR file 'C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar' fou
    nd
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T15:06:08Z  
    I was in a rush and apparently i was using the jar file to open the IBM Data Movement Tool. Now I opened it the proper way and I have the console . Below is the SQL error i am receiving.Again I am at a loss on how to rectify this error. Any suggestions would be greatly welcome :)

    http://2011-06-25 19.35.58.468 All input parameters are saved in 'C:\Users\niranogoledi\Do
    wnloads\IBM data movement tool\migr\IDMTConfig.properties' file.
    JAR file 'C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar' fou
    nd
    JAR file 'C:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\jlib\xdb.jar' found

    JAR file 'C:\Users\nirandi\Downloads\xmlparserv2.jar' found
    http://2011-06-25 19.41.31.268 Driver oracle.jdbc.driver.OracleDriver loaded
    http://2011-06-25 19.41.38.175 Error connecting : oracle.jdbc.driver.OracleDriver for
    oracle Error Message :Io exception: Got minus one from a read call
    http://2011-06-25 19.41.38.178 oracle JDBC connection problem. Please see console's o
    utput.
    java.sql.SQLException: Io exception: Got minus one from a read call
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
    414)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
    n.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at ibm.DBData.getConnection(DBData.java:330)
    at ibm.IBMExtractUtilities.TestConnection(IBMExtractUtilities.java:1770)

    at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:850)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
    ce)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
    JAR file 'C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar' fou
    nd
    I am also seeing this error for the first time.

    Try downloading latest jdbc driver from oracle ojdbc6.jar and just use that file for the time being. Xdb and xmlparser are required if you xml data in oracle.

    If you still see the problem with latest driver, let me know.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T15:34:52Z  
    I am also seeing this error for the first time.

    Try downloading latest jdbc driver from oracle ojdbc6.jar and just use that file for the time being. Xdb and xmlparser are required if you xml data in oracle.

    If you still see the problem with latest driver, let me know.
    I used the latest ojdbc6.jar as you suggested. But unfortunately I still receive the same error. I'm wondering if it is a issue with my oracle express database. Any feedback for me to overcome this issue is welcome.
    Additionally i tried it with , ojdbc5.jar, ojdbc14.jar seperatly from oracle as well but it resulted in the same error.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T15:47:29Z  
    I used the latest ojdbc6.jar as you suggested. But unfortunately I still receive the same error. I'm wondering if it is a issue with my oracle express database. Any feedback for me to overcome this issue is welcome.
    Additionally i tried it with , ojdbc5.jar, ojdbc14.jar seperatly from oracle as well but it resulted in the same error.
    Do a google search on ioexception got minus one oracle and you will see several hits giving possible solutions. You seem to have too many jar files on your path and remove not required jdbc drivers.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T17:58:09Z  
    Do a google search on ioexception got minus one oracle and you will see several hits giving possible solutions. You seem to have too many jar files on your path and remove not required jdbc drivers.
    I managed to resolve the oracle jdbc connection problem. how ever now I get the error "No user schema in you database". Where as when i deployed oracle express 10g i know it definitely has two schema s SYSTEM, and HR. i logged in as system and hr. but for neither users a schema is identified. the sql error is given below. I would really appreciate any suggestions to move forward in this situation. Thanks a lot in advance
    http://2011-06-25 23.23.27.854 Database Minor Version :2
    java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
    java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
    dStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
    nt.java:1038)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
    redStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
    nt.java:1133)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
    aredStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
    dStatement.java:3329)
    at ibm.IBMExtractUtilities.GetSchemaList(IBMExtractUtilities.java:2116)
    at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:856)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
    ce)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T18:11:52Z  
    I managed to resolve the oracle jdbc connection problem. how ever now I get the error "No user schema in you database". Where as when i deployed oracle express 10g i know it definitely has two schema s SYSTEM, and HR. i logged in as system and hr. but for neither users a schema is identified. the sql error is given below. I would really appreciate any suggestions to move forward in this situation. Thanks a lot in advance
    http://2011-06-25 23.23.27.854 Database Minor Version :2
    java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
    java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
    dStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
    nt.java:1038)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
    redStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
    nt.java:1133)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
    aredStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
    dStatement.java:3329)
    at ibm.IBMExtractUtilities.GetSchemaList(IBMExtractUtilities.java:2116)
    at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:856)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
    ce)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
    Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
    Glad that you were able to solve the connection problem. In the interest of the community, it will be good to say how this particular problem was solved.

    The tool hides all the oracle defined default schemas and it has been defined per requests of the user community.

    Create your own schema and run the tool again.

    If you really need HR schema, search this forum for how to get excluded schema back.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-07-02T10:41:45Z  
    Glad that you were able to solve the connection problem. In the interest of the community, it will be good to say how this particular problem was solved.

    The tool hides all the oracle defined default schemas and it has been defined per requests of the user community.

    Create your own schema and run the tool again.

    If you really need HR schema, search this forum for how to get excluded schema back.
    Hi ,

    Thanks for your help. Actually the problem was related to the port number not being properly defined. The oracle runs on port 8081 on my local machine. But somehow during configuration I had to specify port number 1521 for Oracle in the Data Moving Tool. I figured this out by examining some logs in the Data Moving Tool directory.
  • ramakrishnamanu
    ramakrishnamanu
    2 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2012-05-15T10:59:45Z  
    Hi ,

    Thanks for your help. Actually the problem was related to the port number not being properly defined. The oracle runs on port 8081 on my local machine. But somehow during configuration I had to specify port number 1521 for Oracle in the Data Moving Tool. I figured this out by examining some logs in the Data Moving Tool directory.
    Hi Prashan,

    I am facing the same issue like when I am using IBM Data Movement Tool to migrate to DB2.I am able to connect to IBM DB2 database.but there is issue with source database Oracle 10g.the issue is "no user schema is found in your database".when I check in the console the error printed as

    http://2012-05-15 16.26.02.015 Database Minor Version :2
    java.sql.SQLException: ORA-00942: table or view does not exist
    Thanks

    RamaKrishna
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2012-05-15T12:57:11Z  
    The console is a CMD or Windows Command window that is hiding behind the GUI. Look for the exception there and it will hold the clue. It is most likely firewall or port issue.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: oracle jdbc connection prolem. Please see console output

    ‏2012-05-15T12:58:09Z  
    The console is a CMD or Windows Command window that is hiding behind the GUI. Look for the exception there and it will hold the clue. It is most likely firewall or port issue.
    The table or view not found issue is related to the your user id not having sufficient privileges on the Oracle database.