6 Replies Latest reply: Jan 23, 2013 9:02 PM by 871977 RSS

    Unable to call java script!

    871977
      Hi all,

      I'm sorry if i post in the wrong place.

      I have a question. When i run the below script, nothing happened (normally it would display graphic)


      C:\demo\odi11g>set JAVADIR=C:\java
      C:\demo\odi11g>set DEMOCLIENTDIR=C:\demo\DB_CDC_Client

      C:\demo\odi11g>"C:\java\bin\javaw" -cp ".;.;C:\Program Files (x86)\Java\jre7\lib
      \ext\QTJava.zip;C:\demo\DB_CDC_Client\dist\TableFTFEditDemo.jar;C:\demo\DB_CDC_C
      lient\ojdbc14.jar" components.CDCEditDemo
      C:\demo\odi11g>

      Please help!

      Thank you.
        • 1. Re: Unable to call java script!
          EJP
          Try it with java instead of javaw. Maybe there's an exception.
          • 2. Re: Unable to call java script!
            871977
            Thanks EJP!

            I changed as you suggested. This time it got errors:


            ORA-12505, TNS:listener does not currently know of SID given in connect descript
            or
            The Connection descriptor used by the client was:
            localhost:1521:XE

            details:

            C:\demo\odi11g>client1.bat

            C:\demo\odi11g>set JAVADIR=C:\java

            C:\demo\odi11g>set DEMOCLIENTDIR=C:\demo\DB_CDC_Client

            C:\demo\odi11g>"C:\java\bin\java" -cp ".;.;C:\Program Files (x86)\Java\jre7\lib\
            ext\QTJava.zip;C:\demo\DB_CDC_Client\dist\TableFTFEditDemo.jar;C:\demo\DB_CDC_Cl
            ient\ojdbc14.jar" components.CDCEditDemo
            Loading data for SYSTEM, CUST_DW_DEV.SRC_CUSTOMER
            java.sql.SQLException: Listener refused the connection with the following error:

            ORA-12505, TNS:listener does not currently know of SID given in connect descript
            or
            The Connection descriptor used by the client was:
            localhost:1521:XE

            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
            :125)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
            :280)
            at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328)
            at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
            361)
            at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
            at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
            n.java:32)
            at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
            at java.sql.DriverManager.getConnection(DriverManager.java:582)
            at java.sql.DriverManager.getConnection(DriverManager.java:185)
            at components.CDCTableGroup$CDCTableModel.loadDBData(CDCTableGroup.java:
            422)
            at components.CDCTableGroup$CDCTableModel.<init>(CDCTableGroup.java:243)

            at components.CDCTableGroup.<init>(CDCTableGroup.java:86)
            at components.CDCEditDemo.<init>(CDCEditDemo.java:138)
            at components.CDCEditDemo.createAndShowGUI(CDCEditDemo.java:166)
            at components.CDCEditDemo.access$000(CDCEditDemo.java:80)
            at components.CDCEditDemo$1.run(CDCEditDemo.java:180)
            at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
            at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646)
            at java.awt.EventQueue.access$000(EventQueue.java:84)
            at java.awt.EventQueue$1.run(EventQueue.java:607)
            at java.awt.EventQueue$1.run(EventQueue.java:605)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
            ntrolContext.java:87)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:616)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
            ad.java:269)
            at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
            java:184)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
            ad.java:174)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

            at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
            SQL Exception:
            State : null
            Message: Listener refused the connection with the following error:
            ORA-12505, TNS:listener does not currently know of SID given in connect descript
            or
            The Connection descriptor used by the client was:
            localhost:1521:XE

            Error : 0
            Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
            at components.CDCTableGroup$CDCTableModel.getColumnCount(CDCTableGroup.j
            ava:552)
            at components.CDCTableGroup$CDCTableModel.addInsertRowToData(CDCTableGro
            up.java:543)
            at components.CDCTableGroup$CDCTableModel.loadDBData(CDCTableGroup.java:
            535)
            at components.CDCTableGroup$CDCTableModel.<init>(CDCTableGroup.java:243)

            at components.CDCTableGroup.<init>(CDCTableGroup.java:86)
            at components.CDCEditDemo.<init>(CDCEditDemo.java:138)
            at components.CDCEditDemo.createAndShowGUI(CDCEditDemo.java:166)
            at components.CDCEditDemo.access$000(CDCEditDemo.java:80)
            at components.CDCEditDemo$1.run(CDCEditDemo.java:180)
            at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
            at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646)
            at java.awt.EventQueue.access$000(EventQueue.java:84)
            at java.awt.EventQueue$1.run(EventQueue.java:607)
            at java.awt.EventQueue$1.run(EventQueue.java:605)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
            ntrolContext.java:87)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:616)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
            ad.java:269)
            at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
            java:184)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
            ad.java:174)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

            at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
            C:\demo\odi11g>

            Best regards,
            Dan.
            • 3. Re: Unable to call java script!
              gimbal2
              ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
              Great, now you've got something to Google. What's stopping you?
              • 4. Re: Unable to call java script!
                871977
                Yes, i'd like to change localhost:1521:XE to 100.100.100.10:1521:orcl but i really don't know where i can change it.

                I'm using ODI and no tnsnames.ora available.

                Best regards,
                Dan.

                Edited by: Dan on 01:40 21-01-2013
                • 5. Re: Unable to call java script!
                  +... thread moved from the JRE forum (posted there for some unfathomable reason)+
                  to the ODI forum, where most all of your other post happen to be
                  for closer topic alignment...
                  • 6. Re: Unable to call java script!
                    871977
                    Thanks EJP,

                    I found the way of changing this localhost:1521:XE to 100.100.100.10:1521:orcl and it work for me.

                    Best regards,
                    Quốc Trí.