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
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?
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.
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?
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?
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)
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)
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)
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.
#
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)
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)
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)
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.
#
Comment