Oracle JCE, BouncyCastle Provider


Advertisements

Hi, here is my problem:

I'm writing stored java procedure which should send signed and encrypted email.

I've created my classes and after adding bcprov.jar to lib/ext, modifying java.security and using Unlimited Strength Jurisdiction Policy Files everything works fine and emails comes to me signed and encrypted.

Now I'm trying to load all my classes to oracle.
I'm loading jars:
activation-1.0.2.jar
junit-3.8.1.jar
mailapi-1.3.2.jar
smtp-1.3.2.jar
bcprov-jdk14-126.jar
bcmail-jdk14-126.jar
javamail-crypto-0.4.jar
javamail-crypto-bouncy.jar
smime-1.0.jar -- my classes

Everything works fine and when I check for invalid java classes there are none.

Now I'm trying to call my procedure from sql.
I got error:
call sendHamster()
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.io.IOException: error constructing MAC:
java.security.NoSuchProviderException: JCE cannot authenticate the provider BC

When I do not load bcprov.jar then I have:
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.security.NoSuchProviderException: No provider configured for S/MIME /* in real it is ClassNotFoundException */

Standard solution for this problem is to add bcprov.jar to lib/ext, add policy files, add provider to java.security and everything should work.

Problem is that in Oracle there are 3 java vm. This one which is used when i call java function in sql session is $ORACLE_HOME/javavm. I've tried to add all that files there but it does not work. I think that it does not work because bcprov.jar loaded by java is first in classpath before bcprov.jar from $ORACLE_HOME/javavm. Although when i check System.getProperty('java.class.path') I get null. When i tried System.getProperty('java.lib.path') i got $ORACLE_HOME/lib.

I've been also trying to sign bcprov and add certificates to cacerts from lib/security. But there are 3 or 5 cacerts files in $ORACLE_HOME.

Can anyone help me?

Question is: can I add some jar to $ORACLE_HOME/{???} which will be used during compilation/resolving when I call loadjava? Where should it be?

Has anyone added security provider and used it in java stored procedure?

Smilar Topics

  • Poor Performance with BouncyCastle provider in Oracle JVM

    When I run the BouncyCastle provider with Oracle JVM in the database, it runs poorly on the first call, but second and subsequent calls aren't so bad. What options do I have:1. Ncomp? If I go this route, does someone have the necessary scripts and suggestions for using an open source/free C compiler ...

  • Adding Third Party JCE security provider in WAS 6.1 JDK 1.5

    everyone, can i still add third party jce security provider eg jcrypto or bouncycastle in WAS6.1 ND JDK 1.5 ? Will i run into any issue? What is the industry practise ? Do they use solely jce security provider that comes with the jdk or third party ? ...

  • Unable to download ORACLE OLE DB provider 8.1.7.3

    I can not connect to web18-115.us.oracle.com to download the oracle ole db provider for 8.1.7.3.Is this down?I need this ASAP. ...

  • Oracle OLE DB provider ?

    Can the Oracle OLE DB Provider be used with the 10g Instant Client? ...

  • Oracle OLE DB provider truncates LONG field's data

    I am using Visual Basic 6, Oracle 8.1, and use ADO to connect to the Oracle database.I have a problem with OLE DB provider OraOLEDB.Oracle reading a LONG field (MEMO field in Access).When I tried to get the value of the LONG field, it truncates it to 100 characters.I do not have the problem using Mi ...

  • Error initializing the Oracle JMS Resource provider for Queues: JMS-190

    I have changed the user from owner of the queues to new user and I have granted the following grants to the new user but still I am getting this error while deploying.I can deploy with the owner of the queue without any problem.(Error initializing the Oracle JMS Resource provider for Queues: JMS-190 ...

  • download Oracle OLE DB Provider

    I cannot download Oracle OLE DB Providerhttp://www.oracle.com/technology/software/tech/windows/ole_db/htdocs/utilsoft.htmI get the message: "We're sorry, the page you requested was not found. "I have tried with serveral versions (but I want to have one for version 10)Do anyone know where else I can ...

  • Questions about public key encryption using Oracle JCE provider

    Hi, I am testing the following code from Oracle® Security Developer Tools Reference 10g (10.1.4.0.1) at http://download.oracle.com/docs/cd/B28196_01/idmanage.1014/b28165/crypto.htm#sthref100 I got the following exception "Message too long" when the message size is 128. Can anyone let me know what i ...

  • Oracle JCE 1.2.1 problem "NoSuchProviderException"

    I am executing my java stored procedures and receiving the following exception:java.security.NoSuchProviderException: no such provider: <my jce provider here>The code runs outside of Oracle fine.I have loaded the following classes with loadjava -resolve -force <classes> -user Scott/<p ...

  • License for Oracle JCE?

    I found out that Oracle Security Developer tool has provided the JCE provider and set of crypto library. Can it be used in commercial product without any cost? I could not find the related license info on it.I also noticed the way Oracle distribute the osdt.jar is via Oracle Application server as we ...

  • String array parameter to oracle function using Oracle .NET Data Provider

    I need to pass a string array parameter to oracle 8.1.7 function from .NET that returns a cursor. Can I use Oracle Data Provider for .NET with oracle 8? How efficient the driver is (they say it loops through array doing a query at a time). Can anybody share the syntax? ...

  • Oracle JCE double length DES

    i read many times regarding the cryptographic algorithm for Double DES having length of 16 bytes.I have a query regarding SunJCE provider. please see below codeKeyGenerator keygen = KeyGenerator.getInstance("DESede", "BC"); // or "SunJCE"keygen.init(112);Key key = keygen.generateKey();i tried the ab ...

  • Oracle jce (JavaCryptographicExtension) & JavaVM

    I try to encrypt some data from an ejb via jce. My example works as a standalone java program. To get get it work inside the JavaVM in loaded all 4 JCE jar files (US_export_policy.jar jce1_2_1.jar local_policy.jar sunjce_provider.jar) using the following commandloadjava -user sys/<syspassword> ...

  • Oracle Client OLEDB Provider Installation

    I need to call Oracle OLEDB Provider "setup.exe" once I complete installing our product (using Installshield). I tried all different ways to do this and I have absolutely no luck.1. I tried calling LaunchaAppAndWait(SRCDIR^"disk1\\install\\win32setup.exe", "", WAIT) in OnFirstUIAfter event before Sd ...

  • Oracle ODP.NET provider hangs up while fetching data

    Netters,Client Environment: Windows 2000, .NET 1.1, ODP.NET 9.2, Oracle OLEDB 9.2.The .NET application I am developing lets one access Oracle databases using any of the following four drivers:1. ODP .NET Client2. Microsoft ADO .NET3. Oracle OLEDB Provider4. Microsoft OLEDB Provider for OracleAs all ...

  • Oracle Using JASS Provider- jazn-data.xml versus LDAP/OID

    We are planning to develop a Ecommerce Web site Using jdeveloper (9.0.5.2) using ADF/Struts and Couple of Web Service to interact with another web-site.As we know Oracle JAAS provider implements JAAS to support user authentication, authorization and JAAS policies. We have two choices :1. XML based p ...

  • Oracle Using JASS Provider- jazn-data.xml versus LDAP/OID

    We are planning to develop a Ecommerce Web site Using jdeveloper (9.0.5.2) using ADF/Struts and Couple of Web Service to interact with another web-site.As we know Oracle JAAS provider implements JAAS to support user authentication, authorization and JAAS policies. We have two choices :1. XML based p ...

  • Oracle ODP.NET - Provider not compatible to 10g XE?

    Hi, i tried connection to the 10g XE database using the odp.net provider but i always get: "The provider is not compatible with the version of Oracle client".The funny thing is i only have two lines,DbProviderFactory factory = DbProviderFactories.GetFactory( "Oracle.DataAccess.Client" );DbConnection ...

  • Oracle OLE DB Provider Error

    I am using Macromedia Dreamweaver and VBSCRIPT language to retrieve data from an Oracle9i Database Release 9.2.0.1.0. However during test run error occurs;Microsoft OLE DB Provider for Oracle error '80004005':"Oracle client and networking components were not found. These components are supplied by O ...

  • Oracle JCE Error

    I am using JCE in an Oracle 9i environment. I loaded all four jars into Oracle, but still I get an ExceptionInInitializerError when trying to execute KeyStore.getInstance("PKCS12"). Does anybody know how to solve this problem?Any help would be very much appreciated.greetings, Jean-Pierre. ...

  • Oracle External map provider and transparent png

    i have a problem with an external map provider and oracle maps.My map provider queries an external wms, the answer is a transparent png. But the resulting basemap is not displayed transparent in oracle maps.When i query the wms myself in my browser, i can see the transparent png. When i look at the ...

  • Oracle OLE DB Provider Error

    I developed a program using ADO to connect to an Oracle 8i database. My development environment is VB6 on Win2000 Professional. On my system and most of the other PCs the program works. When I install the program on other Win2000 sytems - Prof or Server - it doesn't always won't to work, I haven't h ...

  • Oracle about bouncycastle

    Has anybody tried to load bouncycastle cryprotgraphy API's into oracle database? thanks, Muhammet partnera ...

  • Oracle 11g data provider install question

    I am trying to ready a server to host a VS.Net 2005 application that I wrote. On this server (Windows 2003), I had to install Framework 2.0. When I went to install the 11g Oracle data provider I was asked a question about the install. Being new to this I was not sure how to answer the question. It a ...

  • Oracle OLE DB Provider

    Does anyone know if the Oracle Provider for OLE DB was added to Intstant CLient in Release 2? ...

  • Entity Data Model Wizard not showing Oracle's Data Provider in New Conn

    Not sure where the problem lies - with Visual Studio or with Oracle or with me.I have Visual Studio 2010 and Oracle Client installed on a 64 bit Windows 7 machine. In the Server Explorer, I can add a new connection using ODP.NET data provider, and test it successfully. I can also use the query windo ...

  • Oracle Entity Framework provider should do UPPER_CASE to PascalCase conversion

    The current EF tools don't attempt to do any case conversion when going from database to model (or vice versa). This means either:- you're doing database-first, and wasting hours PascalCasing your entities and attributes- you're doing model-first, and wasting hours UPPER_CASING the generated EDMX st ...

  • Oracle java.naming.provider.url

    I am writing a java program to export objects from OIM (instead of using deployment manager). I have setup a batch file on OIM server and call my java class after setting classpath like this; java -Djava.naming.provider.url=t3://1.2.3.4:7011/nz.ac.vuw.oim.utils.OIMTest -DXL.HomeDir=E:\oracle\xlclien ...

  • Using Oracle OLE Db Provider within Excel 2010 VBA Macro (Windows 7 64 bit)

    i'm trying to connect within my Excel-Sheet (Windows 7 64 bit, Oracle client 10.2.0 32 bit, Excel 2010, VBA 7.0) to Oracle Database (oracle 10.2.0).1. If i try to open the connection (ADO.Connection) i always get the following error:ORA-01804: failure to initialize timezone information 2. Then i tri ...