Oracle JCE, BouncyCastle Provider

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?

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 ...

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 ...

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. ...

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> ...

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 ? ...

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 ...

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 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 ...

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 OLE DB Provider

Any news on adding the OLE DB Provider to the instant client? ...

Oracle Direct Access Provider Library (DAPL) support

i'm looking for information on how to configure oracle10g to use DAPL for networking on linux. documentation talks about Socket Direct Protocol (SDP) but not DAPL.any links/pointers ? ...

Oracle Direct Access Provider Library (DAPL) support

i'm looking for information on how to configure oracle10g to use DAPL for networking on linux. documentation talks about Socket Direct Protocol (SDP) but not DAPL.any links/pointers ? ...

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 OLE DB Provider

ANy news on adding the OLE DB Provider to the intant client? ...

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 ...

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 ...

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 ...

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 ...

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 ...

Oracle Foreign JNDI Provider Configuration

I need to connect to a JMS topic, present on an oc4j server through JDeveloper 11g, so to do that i am unable to use the normal JMS adapter configuration using WebLogic JMS because i need to connect to a oc4j server. So i thought if using Foreign JNDI concept, so is this the correct approach?If yes ...