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

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
    ACCEPTED ANSWER

    Re: oracle jdbc connection prolem. Please see console output

    ‏2011-06-25T12:27:21Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: oracle jdbc connection prolem. Please see console output

      ‏2011-06-25T12:56:10Z  in response to SystemAdmin
      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
      ACCEPTED ANSWER

      Re: oracle jdbc connection prolem. Please see console output

      ‏2011-06-25T13:21:43Z  in response to SystemAdmin
      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
        ACCEPTED ANSWER

        Re: oracle jdbc connection prolem. Please see console output

        ‏2011-06-25T13:46:53Z  in response to SystemAdmin
        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
          ACCEPTED ANSWER

          Re: oracle jdbc connection prolem. Please see console output

          ‏2011-06-25T14:51:30Z  in response to SystemAdmin
          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
            ACCEPTED ANSWER

            Re: oracle jdbc connection prolem. Please see console output

            ‏2011-06-25T15:06:08Z  in response to SystemAdmin
            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
              ACCEPTED ANSWER

              Re: oracle jdbc connection prolem. Please see console output

              ‏2011-06-25T15:34:52Z  in response to SystemAdmin
              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
                ACCEPTED ANSWER

                Re: oracle jdbc connection prolem. Please see console output

                ‏2011-06-25T15:47:29Z  in response to SystemAdmin
                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
                  ACCEPTED ANSWER

                  Re: oracle jdbc connection prolem. Please see console output

                  ‏2011-06-25T17:58:09Z  in response to SystemAdmin
                  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
                    ACCEPTED ANSWER

                    Re: oracle jdbc connection prolem. Please see console output

                    ‏2011-06-25T18:11:52Z  in response to SystemAdmin
                    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
                      ACCEPTED ANSWER

                      Re: oracle jdbc connection prolem. Please see console output

                      ‏2011-07-02T10:41:45Z  in response to SystemAdmin
                      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
                        ACCEPTED ANSWER

                        Re: oracle jdbc connection prolem. Please see console output

                        ‏2012-05-15T10:59:45Z  in response to SystemAdmin
                        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
    ACCEPTED ANSWER

    Re: oracle jdbc connection prolem. Please see console output

    ‏2012-05-15T12:57:11Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: oracle jdbc connection prolem. Please see console output

      ‏2012-05-15T12:58:09Z  in response to SystemAdmin
      The table or view not found issue is related to the your user id not having sufficient privileges on the Oracle database.