Call Javacode from Pl/SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • beenanic
    New Member
    • Aug 2008
    • 8

    Call Javacode from Pl/SQL

    I want to call JavaScript/Java Code from a PL/SQL
    If any one has idea, pl share
    Thanks in advance
    Beena
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Javascript != Java.
    Which one do you want to call?

    Comment

    • beenanic
      New Member
      • Aug 2008
      • 8

      #3
      Originally posted by r035198x
      Javascript != Java.
      Which one do you want to call?
      First preferance - java script if not possible then java class

      Comment

      • r035198x
        MVP
        • Sep 2006
        • 13225

        #4
        Originally posted by beenanic
        First preferance - java script if not possible then java class
        Are we talking about Java stored procedures here?

        Comment

        • beenanic
          New Member
          • Aug 2008
          • 8

          #5
          I have a java script& javacodes to generate Barcode. I want to call it from a SQL query.
          when I load the java class using loadjava errors coming...
          Is it possible to call javascript from PL/SQL

          Comment

          • r035198x
            MVP
            • Sep 2006
            • 13225

            #6
            Originally posted by beenanic
            I have a java script& javacodes to generate Barcode. I want to call it from a SQL query.
            when I load the java class using loadjava errors coming...
            Is it possible to call javascript from PL/SQL
            Why don't you explain what your application set up is like? Are you creating a web application using JSPs? How are you mixing the Java and Javascript?

            Comment

            • beenanic
              New Member
              • Aug 2008
              • 8

              #7
              Originally posted by r035198x
              Why don't you explain what your application set up is like? Are you creating a web application using JSPs? How are you mixing the Java and Javascript?
              It is a J2EE based web application with oracle 10g as data base.
              From one of my JSP, i am calling a Jasper report to print bills. in that bill i want to include barcodes also. I have java script and java code to generate barcodes.
              without saving into databse , i have to print it while calling reports.

              Comment

              • r035198x
                MVP
                • Sep 2006
                • 13225

                #8
                Originally posted by beenanic
                It is a J2EE based web application with oracle 10g as data base.
                From one of my JSP, i am calling a Jasper report to print bills. in that bill i want to include barcodes also. I have java script and java code to generate barcodes.
                without saving into databse , i have to print it while calling reports.
                So you know want to save the generated bar codes in the database? Into a column of what type?

                Comment

                • beenanic
                  New Member
                  • Aug 2008
                  • 8

                  #9
                  Originally posted by r035198x
                  So you know want to save the generated bar codes in the database? Into a column of what type?
                  I don't want to save it into database, while calling report for every bill_no, i want to generate the corresponding barcode of billno.

                  My requirement is this.

                  If i have a function barcodegen with input as billno(number) and output as corresponding barcode (as image type), i can call it in the query as
                  select bill_no,barcode gen(bill_no) ---> this is my requirement, i can place the
                  image in my report without saving into database.
                  any idea?

                  Comment

                  • r035198x
                    MVP
                    • Sep 2006
                    • 13225

                    #10
                    See if this
                    helps.

                    Comment

                    • beenanic
                      New Member
                      • Aug 2008
                      • 8

                      #11
                      Originally posted by r035198x
                      See if this
                      helps.
                      I have refered that site.. follwed the steps
                      1. Creates Class files
                      2. While loading class files into database, the following errors coming
                      (My oracle user is kwa and class file is Area.class , which is working fine in java)

                      D:\oracle\produ ct\10.2.0\db_1\ BIN>loadjava -user kwa/kwa Area.class

                      Unexpected Signal : EXCEPTION_ACCES S_VIOLATION (0xc0000005) occurred at PC=0x807
                      7E76
                      Function=[Unknown.]
                      Library=D:\orac le\product\10.2 .0\db_1\jdk\jre \bin\client\jvm .dll

                      NOTE: We are unable to locate the function name symbol for the error
                      just occurred. Please refer to release documentation for possible
                      reason and solutions.


                      Current Java thread:
                      at oracle.jdbc.dri ver.T2CConnecti on.t2cCreateSta te(Native Method)
                      at oracle.jdbc.dri ver.T2CConnecti on.logon(T2CCon nection.java:34 6)
                      at oracle.jdbc.dri ver.PhysicalCon nection.<init>( PhysicalConnect ion.java:
                      413)
                      at oracle.jdbc.dri ver.T2CConnecti on.<init>(T2CCo nnection.java:1 31)
                      at oracle.jdbc.dri ver.T2CDriverEx tension.getConn ection(T2CDrive rExtensio
                      n.java:77)
                      at oracle.jdbc.dri ver.OracleDrive r.connect(Oracl eDriver.java:75 2)
                      at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
                      - locked <0x141ae178> (a java.lang.Class )
                      at java.sql.Driver Manager.getConn ection(DriverMa nager.java:140)
                      - locked <0x141ae178> (a java.lang.Class )
                      at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.getConne ction(Dat
                      abaseOptions.ja va:180)
                      at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.connect( DatabaseO
                      ptions.java:123 )
                      at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getConnect ion(LoadJ
                      avaState.java:4 09)
                      at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getOldMD5( LoadJavaS
                      tate.java:696)
                      at oracle.aurora.s erver.tools.loa djava.ClientSch emaObject.getOl dMD5(Clie
                      ntSchemaObject. java:52)
                      at oracle.aurora.s erver.tools.loa djava.SchemaObj ect.doCreate(Sc hemaObjec
                      t.java:172)



                      D:\oracle\produ ct\10.2.0\db_1\ BIN>loadjava -user kwa/kwa Area.class

                      Unexpected Signal : EXCEPTION_ACCES S_VIOLATION (0xc0000005) occurred at PC=0x807
                      7E76
                      Function=[Unknown.]
                      Library=D:\orac le\product\10.2 .0\db_1\jdk\jre \bin\client\jvm .dll

                      NOTE: We are unable to locate the function name symbol for the error
                      just occurred. Please refer to release documentation for possible
                      reason and solutions.


                      Current Java thread:
                      at oracle.jdbc.dri ver.T2CConnecti on.t2cCreateSta te(Native Method)
                      at oracle.jdbc.dri ver.T2CConnecti on.logon(T2CCon nection.java:34 6)
                      at oracle.jdbc.dri ver.PhysicalCon nection.<init>( PhysicalConnect ion.java:
                      413)
                      at oracle.jdbc.dri ver.T2CConnecti on.<init>(T2CCo nnection.java:1 31)
                      at oracle.jdbc.dri ver.T2CDriverEx tension.getConn ection(T2CDrive rExtensio
                      n.java:77)
                      at oracle.jdbc.dri ver.OracleDrive r.connect(Oracl eDriver.java:75 2)
                      at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
                      - locked <0x141ae178> (a java.lang.Class )
                      at java.sql.Driver Manager.getConn ection(DriverMa nager.java:140)
                      - locked <0x141ae178> (a java.lang.Class )
                      at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.getConne ction(Dat
                      abaseOptions.ja va:180)
                      at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.connect( DatabaseO
                      ptions.java:123 )
                      at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getConnect ion(LoadJ
                      avaState.java:4 09)
                      at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getOldMD5( LoadJavaS
                      tate.java:696)
                      at oracle.aurora.s erver.tools.loa djava.ClientSch emaObject.getOl dMD5(Clie
                      ntSchemaObject. java:52)
                      at oracle.aurora.s erver.tools.loa djava.SchemaObj ect.doCreate(Sc hemaObjec
                      t.java:172)
                      at oracle.aurora.s erver.tools.loa djava.SchemaObj ect.process1(Sc hemaObjec
                      t.java:215)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:532)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. addClass(LoadJa va.java:5
                      86)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:436)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:380)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:349)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:652)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. processDeferred Files(Loa
                      dJava.java:617)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. process(LoadJav a.java:81
                      8)
                      at oracle.aurora.s erver.tools.loa djava.LoadJava. command(LoadJav a.java:25
                      1)
                      at oracle.aurora.s erver.tools.loa djava.LoadJavaM ain.run(LoadJav aMain.jav
                      a:103)
                      at oracle.aurora.s erver.tools.loa djava.LoadJavaM ain.main(LoadJa vaMain.ja
                      va:28)

                      Dynamic libraries:
                      0x00400000 - 0x0040B000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\jav a.e
                      xe
                      0x7C900000 - 0x7C9B0000 C:\WINDOWS\syst em32\ntdll.dll
                      0x7C800000 - 0x7C8F5000 C:\WINDOWS\syst em32\kernel32.d ll
                      0x77DD0000 - 0x77E6B000 C:\WINDOWS\syst em32\ADVAPI32.d ll
                      0x77E70000 - 0x77F01000 C:\WINDOWS\syst em32\RPCRT4.dll
                      0x77C10000 - 0x77C68000 C:\WINDOWS\syst em32\MSVCRT.dll
                      0x08000000 - 0x08138000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\cli ent
                      \jvm.dll
                      0x7E410000 - 0x7E4A0000 C:\WINDOWS\syst em32\USER32.dll
                      0x77F10000 - 0x77F57000 C:\WINDOWS\syst em32\GDI32.dll
                      0x76B40000 - 0x76B6D000 C:\WINDOWS\syst em32\WINMM.dll
                      0x76390000 - 0x763AD000 C:\WINDOWS\syst em32\IMM32.DLL
                      0x10000000 - 0x10007000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\hpi .dl
                      l
                      0x00390000 - 0x0039E000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\ver ify
                      .dll
                      0x003B0000 - 0x003C9000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\jav a.d
                      ll
                      0x003D0000 - 0x003DE000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\zip .dl
                      l
                      0x62F00000 - 0x62F13000 D:\oracle\produ ct\10.2.0\db_1\ BIN\ocijdbc10.d ll
                      0x02E70000 - 0x02EC7000 D:\oracle\produ ct\10.2.0\db_1\ BIN\OCI.dll
                      0x7C340000 - 0x7C396000 D:\oracle\produ ct\10.2.0\db_1\ BIN\MSVCR71.dll
                      0x76C90000 - 0x76CB8000 C:\WINDOWS\syst em32\imagehlp.d ll
                      0x59A60000 - 0x59B01000 C:\WINDOWS\syst em32\DBGHELP.dl l
                      0x77C00000 - 0x77C08000 C:\WINDOWS\syst em32\VERSION.dl l
                      0x76BF0000 - 0x76BFB000 C:\WINDOWS\syst em32\PSAPI.DLL

                      Heap at VM Abort:
                      Heap
                      def new generation total 576K, used 77K [0x10010000, 0x100b0000, 0x104f0000)
                      eden space 512K, 13% used [0x10010000, 0x10021b20, 0x10090000)
                      from space 64K, 11% used [0x10090000, 0x10091cd0, 0x100a0000)
                      to space 64K, 0% used [0x100a0000, 0x100a0000, 0x100b0000)
                      tenured generation total 1408K, used 243K [0x104f0000, 0x10650000, 0x14010000
                      )
                      the space 1408K, 17% used [0x104f0000, 0x1052cdd0, 0x1052ce00, 0x10650000)
                      compacting perm gen total 4096K, used 2414K [0x14010000, 0x14410000, 0x1801000
                      0)
                      the space 4096K, 58% used [0x14010000, 0x1426b810, 0x1426ba00, 0x14410000)

                      Local Time = Mon Aug 11 12:18:03 2008
                      Elapsed Time = 0
                      #
                      # HotSpot Virtual Machine Error : EXCEPTION_ACCES S_VIOLATION
                      # Error ID : 4F530E43505002E F
                      # Please report this error at
                      # http://java.sun.com/cgi-bin/bugreport.cgi
                      #
                      # Java VM: Java HotSpot(TM) Client VM (1.4.2_08-b03 interpreted mode)
                      #
                      # An error report file has been saved as hs_err_pid2940. log.
                      # Please refer to the file for further information.
                      #

                      D:\oracle\produ ct\10.2.0\db_1\ BIN>

                      Comment

                      • beenanic
                        New Member
                        • Aug 2008
                        • 8

                        #12
                        Originally posted by beenanic
                        I have refered that site.. follwed the steps
                        1. Creates Class files
                        2. While loading class files into database, the following errors coming
                        (My oracle user is kwa and class file is Area.class , which is working fine in java)

                        D:\oracle\produ ct\10.2.0\db_1\ BIN>loadjava -user kwa/kwa Area.class

                        Unexpected Signal : EXCEPTION_ACCES S_VIOLATION (0xc0000005) occurred at PC=0x807
                        7E76
                        Function=[Unknown.]
                        Library=D:\orac le\product\10.2 .0\db_1\jdk\jre \bin\client\jvm .dll

                        NOTE: We are unable to locate the function name symbol for the error
                        just occurred. Please refer to release documentation for possible
                        reason and solutions.


                        Current Java thread:
                        at oracle.jdbc.dri ver.T2CConnecti on.t2cCreateSta te(Native Method)
                        at oracle.jdbc.dri ver.T2CConnecti on.logon(T2CCon nection.java:34 6)
                        at oracle.jdbc.dri ver.PhysicalCon nection.<init>( PhysicalConnect ion.java:
                        413)
                        at oracle.jdbc.dri ver.T2CConnecti on.<init>(T2CCo nnection.java:1 31)
                        at oracle.jdbc.dri ver.T2CDriverEx tension.getConn ection(T2CDrive rExtensio
                        n.java:77)
                        at oracle.jdbc.dri ver.OracleDrive r.connect(Oracl eDriver.java:75 2)
                        at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
                        - locked <0x141ae178> (a java.lang.Class )
                        at java.sql.Driver Manager.getConn ection(DriverMa nager.java:140)
                        - locked <0x141ae178> (a java.lang.Class )
                        at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.getConne ction(Dat
                        abaseOptions.ja va:180)
                        at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.connect( DatabaseO
                        ptions.java:123 )
                        at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getConnect ion(LoadJ
                        avaState.java:4 09)
                        at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getOldMD5( LoadJavaS
                        tate.java:696)
                        at oracle.aurora.s erver.tools.loa djava.ClientSch emaObject.getOl dMD5(Clie
                        ntSchemaObject. java:52)
                        at oracle.aurora.s erver.tools.loa djava.SchemaObj ect.doCreate(Sc hemaObjec
                        t.java:172)



                        D:\oracle\produ ct\10.2.0\db_1\ BIN>loadjava -user kwa/kwa Area.class

                        Unexpected Signal : EXCEPTION_ACCES S_VIOLATION (0xc0000005) occurred at PC=0x807
                        7E76
                        Function=[Unknown.]
                        Library=D:\orac le\product\10.2 .0\db_1\jdk\jre \bin\client\jvm .dll

                        NOTE: We are unable to locate the function name symbol for the error
                        just occurred. Please refer to release documentation for possible
                        reason and solutions.


                        Current Java thread:
                        at oracle.jdbc.dri ver.T2CConnecti on.t2cCreateSta te(Native Method)
                        at oracle.jdbc.dri ver.T2CConnecti on.logon(T2CCon nection.java:34 6)
                        at oracle.jdbc.dri ver.PhysicalCon nection.<init>( PhysicalConnect ion.java:
                        413)
                        at oracle.jdbc.dri ver.T2CConnecti on.<init>(T2CCo nnection.java:1 31)
                        at oracle.jdbc.dri ver.T2CDriverEx tension.getConn ection(T2CDrive rExtensio
                        n.java:77)
                        at oracle.jdbc.dri ver.OracleDrive r.connect(Oracl eDriver.java:75 2)
                        at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
                        - locked <0x141ae178> (a java.lang.Class )
                        at java.sql.Driver Manager.getConn ection(DriverMa nager.java:140)
                        - locked <0x141ae178> (a java.lang.Class )
                        at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.getConne ction(Dat
                        abaseOptions.ja va:180)
                        at oracle.aurora.s erver.tools.loa djava.DatabaseO ptions.connect( DatabaseO
                        ptions.java:123 )
                        at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getConnect ion(LoadJ
                        avaState.java:4 09)
                        at oracle.aurora.s erver.tools.loa djava.LoadJavaS tate.getOldMD5( LoadJavaS
                        tate.java:696)
                        at oracle.aurora.s erver.tools.loa djava.ClientSch emaObject.getOl dMD5(Clie
                        ntSchemaObject. java:52)
                        at oracle.aurora.s erver.tools.loa djava.SchemaObj ect.doCreate(Sc hemaObjec
                        t.java:172)
                        at oracle.aurora.s erver.tools.loa djava.SchemaObj ect.process1(Sc hemaObjec
                        t.java:215)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:532)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. addClass(LoadJa va.java:5
                        86)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:436)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:380)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:349)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. add(LoadJava.ja va:652)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. processDeferred Files(Loa
                        dJava.java:617)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. process(LoadJav a.java:81
                        8)
                        at oracle.aurora.s erver.tools.loa djava.LoadJava. command(LoadJav a.java:25
                        1)
                        at oracle.aurora.s erver.tools.loa djava.LoadJavaM ain.run(LoadJav aMain.jav
                        a:103)
                        at oracle.aurora.s erver.tools.loa djava.LoadJavaM ain.main(LoadJa vaMain.ja
                        va:28)

                        Dynamic libraries:
                        0x00400000 - 0x0040B000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\jav a.e
                        xe
                        0x7C900000 - 0x7C9B0000 C:\WINDOWS\syst em32\ntdll.dll
                        0x7C800000 - 0x7C8F5000 C:\WINDOWS\syst em32\kernel32.d ll
                        0x77DD0000 - 0x77E6B000 C:\WINDOWS\syst em32\ADVAPI32.d ll
                        0x77E70000 - 0x77F01000 C:\WINDOWS\syst em32\RPCRT4.dll
                        0x77C10000 - 0x77C68000 C:\WINDOWS\syst em32\MSVCRT.dll
                        0x08000000 - 0x08138000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\cli ent
                        \jvm.dll
                        0x7E410000 - 0x7E4A0000 C:\WINDOWS\syst em32\USER32.dll
                        0x77F10000 - 0x77F57000 C:\WINDOWS\syst em32\GDI32.dll
                        0x76B40000 - 0x76B6D000 C:\WINDOWS\syst em32\WINMM.dll
                        0x76390000 - 0x763AD000 C:\WINDOWS\syst em32\IMM32.DLL
                        0x10000000 - 0x10007000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\hpi .dl
                        l
                        0x00390000 - 0x0039E000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\ver ify
                        .dll
                        0x003B0000 - 0x003C9000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\jav a.d
                        ll
                        0x003D0000 - 0x003DE000 D:\oracle\produ ct\10.2.0\db_1\ jdk\jre\bin\zip .dl
                        l
                        0x62F00000 - 0x62F13000 D:\oracle\produ ct\10.2.0\db_1\ BIN\ocijdbc10.d ll
                        0x02E70000 - 0x02EC7000 D:\oracle\produ ct\10.2.0\db_1\ BIN\OCI.dll
                        0x7C340000 - 0x7C396000 D:\oracle\produ ct\10.2.0\db_1\ BIN\MSVCR71.dll
                        0x76C90000 - 0x76CB8000 C:\WINDOWS\syst em32\imagehlp.d ll
                        0x59A60000 - 0x59B01000 C:\WINDOWS\syst em32\DBGHELP.dl l
                        0x77C00000 - 0x77C08000 C:\WINDOWS\syst em32\VERSION.dl l
                        0x76BF0000 - 0x76BFB000 C:\WINDOWS\syst em32\PSAPI.DLL

                        Heap at VM Abort:
                        Heap
                        def new generation total 576K, used 77K [0x10010000, 0x100b0000, 0x104f0000)
                        eden space 512K, 13% used [0x10010000, 0x10021b20, 0x10090000)
                        from space 64K, 11% used [0x10090000, 0x10091cd0, 0x100a0000)
                        to space 64K, 0% used [0x100a0000, 0x100a0000, 0x100b0000)
                        tenured generation total 1408K, used 243K [0x104f0000, 0x10650000, 0x14010000
                        )
                        the space 1408K, 17% used [0x104f0000, 0x1052cdd0, 0x1052ce00, 0x10650000)
                        compacting perm gen total 4096K, used 2414K [0x14010000, 0x14410000, 0x1801000
                        0)
                        the space 4096K, 58% used [0x14010000, 0x1426b810, 0x1426ba00, 0x14410000)

                        Local Time = Mon Aug 11 12:18:03 2008
                        Elapsed Time = 0
                        #
                        # HotSpot Virtual Machine Error : EXCEPTION_ACCES S_VIOLATION
                        # Error ID : 4F530E43505002E F
                        # Please report this error at
                        # http://java.sun.com/cgi-bin/bugreport.cgi
                        #
                        # Java VM: Java HotSpot(TM) Client VM (1.4.2_08-b03 interpreted mode)
                        #
                        # An error report file has been saved as hs_err_pid2940. log.
                        # Please refer to the file for further information.
                        #

                        D:\oracle\produ ct\10.2.0\db_1\ BIN>
                        If any one face this error, pl respond....

                        Comment

                        Working...