Hi,

I have written a Java stored procedure (for Oracle 9i which I believe
uses JDK 1.3) that uses javax.crypto for RSA decryption. Having loaded
the jce_1_2_2.jar using loadjava as a resource, I can load my stored
procedure into the database with no errors using loadjava. However
when I try to run it, I get a java.lang.ExceptionInInitializerError. I
know that the lines in the stored procedure making use of javax.crypto
are causing the problem as it runs fine without them.

So two questions:

1) are there any other Java RSA decryption libraries that Oracle 9i
likes?

2) Does Oracle 9i have any built-in features for RSA decryption?

Thanks,
(a frustrated) Pouria

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Pouria wrote:
> Hi,
>
> I have written a Java stored procedure (for Oracle 9i which I believe
> uses JDK 1.3) that uses javax.crypto for RSA decryption. Having loaded
> the jce_1_2_2.jar using loadjava as a resource, I can load my stored
> procedure into the database with no errors using loadjava. However
> when I try to run it, I get a java.lang.ExceptionInInitializerError. I
> know that the lines in the stored procedure making use of javax.crypto
> are causing the problem as it runs fine without them.
>
> So two questions:
>
> 1) are there any other Java RSA decryption libraries that Oracle 9i
> likes?
>
> 2) Does Oracle 9i have any built-in features for RSA decryption?
>
> Thanks,
> (a frustrated) Pouria
>
You owe me a cup of coffee:

http://download-uk.oracle.com/docs/c...04.htm#1004955

- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGfOr+Lw8L4IAs830RAh6YAJ94LH7udc49qV62zD6oEy 0GB7/EGQCfQN+Q
C0/qYZ+IR35lLIS7n8cHhPU=
=AYHj
-----END PGP SIGNATURE-----

Hi Frank,

Thanks for the reply. My understanding is that
DBMS_OBFUSCATION_TOOLKIT supports DES encryption only (and not RSA).
Am I correct in saying this? If so are you aware of any alternatives?

Thanks,
Pouria

On Jun 23, 5:42 am, Frank van Bortel <frank.van.bor...@gmail.com>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>
> Pouria wrote:
> > Hi,
>
> > I have written a Java stored procedure (for Oracle 9i which I believe
> > uses JDK 1.3) that uses javax.crypto for RSA decryption. Having loaded
> > the jce_1_2_2.jar using loadjava as a resource, I can load my stored
> > procedure into the database with no errors using loadjava. However
> > when I try to run it, I get a java.lang.ExceptionInInitializerError. I
> > know that the lines in the stored procedure making use of javax.crypto
> > are causing the problem as it runs fine without them.
>
> > So two questions:
>
> > 1) are there any other Java RSA decryption libraries that Oracle 9i
> > likes?
>
> > 2) Does Oracle 9i have any built-in features for RSA decryption?
>
> > Thanks,
> > (a frustrated) Pouria
>
> You owe me a cup of coffee:
>
> http://download-uk.oracle.com/docs/c...920/a96590/adg...
>
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFGfOr+Lw8L4IAs830RAh6YAJ94LH7udc49qV62zD6oEy 0GB7/EGQCfQN+Q
> C0/qYZ+IR35lLIS7n8cHhPU=
> =AYHj
> -----END PGP SIGNATURE-----

Pouria wrote:
> Hi Frank,
>
> Thanks for the reply. My understanding is that
> DBMS_OBFUSCATION_TOOLKIT supports DES encryption only (and not RSA).
> Am I correct in saying this? If so are you aware of any alternatives?
>
> Thanks,
> Pouria

It does support more than DES, but does not support RSA. Any reason why
this is the encryption scheme that you must use? Personally, I could
care less how the data is encrypted so long as it is secure. Triple DES
should do that nicely.

The DBMS_CRYPTO package in Oracle 10g does offer more encryption options
than what is previously available. You will need to upgrade though. Here
is more information on DBMS_CRYPTO:

http://download-east.oracle.com/docs...o.htm#i1005082

HTH,
Brian


--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

Pouria wrote:
> Hi Frank,
>
> Thanks for the reply. My understanding is that
> DBMS_OBFUSCATION_TOOLKIT supports DES encryption only (and not RSA).
> Am I correct in saying this? If so are you aware of any alternatives?
>
> Thanks,
> Pouria
>
> On Jun 23, 5:42 am, Frank van Bortel <frank.van.bor...@gmail.com>
> wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>>
>>
>> Pouria wrote:
>>> Hi,
>>> I have written a Java stored procedure (for Oracle 9i which I believe
>>> uses JDK 1.3) that uses javax.crypto for RSA decryption. Having loaded
>>> the jce_1_2_2.jar using loadjava as a resource, I can load my stored
>>> procedure into the database with no errors using loadjava. However
>>> when I try to run it, I get a java.lang.ExceptionInInitializerError. I
>>> know that the lines in the stored procedure making use of javax.crypto
>>> are causing the problem as it runs fine without them.
>>> So two questions:
>>> 1) are there any other Java RSA decryption libraries that Oracle 9i
>>> likes?
>>> 2) Does Oracle 9i have any built-in features for RSA decryption?
>>> Thanks,
>>> (a frustrated) Pouria
>> You owe me a cup of coffee:
>>
>> http://download-uk.oracle.com/docs/c...920/a96590/adg...
>>
>> - --
>> Regards,
>> Frank van Bortel
>>
>> Top-posting is one way to shut me up...
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.1 (MingW32)
>>
>> iD8DBQFGfOr+Lw8L4IAs830RAh6YAJ94LH7udc49qV62zD6oEy 0GB7/EGQCfQN+Q
>> C0/qYZ+IR35lLIS7n8cHhPU=
>> =AYHj
>> -----END PGP SIGNATURE-----

You are correct.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

thanks for the links. it seems the DBMS_OBFUSCATION_TOOLKIT and
DBMS_CRYPTO support symmetric cryptographic algorithms. Do you know of
any support for asymmetric algorithms such as RSA?

On Jun 25, 10:50 am, Brian Peasland <d...@nospam.peasland.net> wrote:
> Pouria wrote:
> > Hi Frank,
>
> > Thanks for the reply. My understanding is that
> > DBMS_OBFUSCATION_TOOLKIT supports DES encryption only (and not RSA).
> > Am I correct in saying this? If so are you aware of any alternatives?
>
> > Thanks,
> > Pouria
>
> It does support more than DES, but does not support RSA. Any reason why
> this is the encryption scheme that you must use? Personally, I could
> care less how the data is encrypted so long as it is secure. Triple DES
> should do that nicely.
>
> The DBMS_CRYPTO package in Oracle 10g does offer more encryption options
> than what is previously available. You will need to upgrade though. Here
> is more information on DBMS_CRYPTO:
>
> http://download-east.oracle.com/docs...v.102/b14258/d...
>
> HTH,
> Brian
>
> --
> ================================================== =================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com

Pouria wrote:
> thanks for the links. it seems the DBMS_OBFUSCATION_TOOLKIT and
> DBMS_CRYPTO support symmetric cryptographic algorithms. Do you know of
> any support for asymmetric algorithms such as RSA?

Recheck DBMS_CRYPTO with respect to AES. But in answer to your question
.... no.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Pouria wrote:
> thanks for the links. it seems the DBMS_OBFUSCATION_TOOLKIT and
> DBMS_CRYPTO support symmetric cryptographic algorithms. Do you know of
> any support for asymmetric algorithms such as RSA?

Not from Oracle. You'll have to implement your own or find some 3rd
party solution. But then I ask again...any reason why you can't use what
is available?

HTH,
Brian



--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com