Oracle Database Discussions

Hi all,

I am trying to call java class method from oracle function, but getting below exception, while creating connection.



SQL> select charge_calculation(1,'2011-06-01', 'E') from dual;
select charge_calculation(1,'2011-06-01', 'E') from dual
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.ExceptionInInitializerError


inside main method
inside main method1
inside main method2
inside main method3
inside main method3
Exception in thread "Root Thread" java.lang.ExceptionInInitializerError
at javax.crypto.Cipher.getInstance(DashoA12275)
at oracle.security.o5logon.O5LoginClientHelper.decryptAES(Unknown Source
)
at oracle.security.o5logon.O5LoginClientHelper.generateOAuthResponse(Unk
nown
Source)
at
oracle.jdbc.driver.T4CTTIoauthenticate.marshalOauth(T4CTTIoauthenticate.java)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:367)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
501)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at SPEodPricing.spEodPricing(SPEODPRICING:98)
at SPEodPricing.main1(SPEODPRICING:47)
Caused by: java.lang.SecurityException: Cannot set up certs for trusted CAs
at javax.crypto.SunJCE_b.<clinit>(DashoA12275)
... 13 more
Caused by: java.security.PrivilegedActionException: java.io.IOException
at java.security.AccessController.doPrivileged(Native Method)
... 14 more
Caused by: java.io.IOException
at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(FileOutputStream.java)
at sun.net.www.protocol.jar.URLJarFile$1.run(URLJarFile.java:177)
at java.security.AccessController.doPrivileged(Native Method)
at sun.net.www.protocol.jar.URLJarFile.retrieve(URLJarFile.java:165)
at sun.net.www.protocol.jar.URLJarFile.getJarFile(URLJarFile.java:43)
at sun.net.www.protocol.jar.JarFileFactory.get(JarFileFactory.java:70)
at sun.net.www.protocol.jar.JarURLConnection.connect(JarURLConnection.ja
va:102)
at
sun.net.www.protocol.jar.JarURLConnection.getInputStream(JarURLConnection.java:1

24)
at javax.crypto.SunJCE_d.a(DashoA12275)
at javax.crypto.SunJCE_b.g(DashoA12275)
at javax.crypto.SunJCE_b.e(DashoA12275)
at javax.crypto.SunJCE_q.run(DashoA12275)
... 15 more
SQL> select charge_calculation(1,'2011-06-01', 'E') from dual;
select charge_calculation(1,'2011-06-01', 'E') from dual
*
ERROR at line 1:
ORA-29549: class BBVA_MERGED.SPEodPricing has changed, Java session state
cleared


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64
bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

JAVA Sample code:-

public String method1(int pi_ctry_id,String pi_cur_busi_date ,String pi_eod_bod_flag)
{
System.out.println("inside main method1");
CachedRowSet tmplcrs = null;
HashMap resMap = new HashMap();
Double ln_candidate_extra = 0.0;
Double ln_calculate_on_val = 0.0;
int lv_calculate_on = 0;
int lv_cand_attribute = 0;

// int pi_ctry_id = 0;
// String pi_cur_busi_date = null;
int pi_bch_id = 0;
// String pi_eod_bod_flag = null;
Date ldt_cur_busi_date = null;
Date lstr_next_calc_date = null;
int li_bch_id = 0;
int li_chg_ac_branch = 0;
int calFrequency = 0;
DbUtils dbObj = new DbUtils();
Map reqMap = new HashMap();

CachedRowSet updtcrs = null;

Connection conn = null;

try
{
System.out.println("inside main method2");
reqMap.put("pi_ctry_id", ""+pi_ctry_id);
reqMap.put("pi_cur_busi_date", ""+pi_cur_busi_date);
reqMap.put("pi_eod_bod_flag", ""+pi_eod_bod_flag);

System.out.println("inside main method3");
Class.forName("oracle.jdbc.driver.OracleDriver");
// Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.1.56.85:1521:orcl", "bbva_merged", "bbva_merged");
// conn = DriverManager.getConnection("jdbc:oracle:thin:@10.1.50.104:1521:cmsdb6", "bbva_base", "bbva_base");
System.out.println("inside main method3");
conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.50.129)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.50.130)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = BBVASIT)))", "BBVA_MERGED", "BBVA_MERGED");
conn.setAutoCommit(false);
System.out.println("inside main method4");

}