Hi there,
I have an applet which is using a JDBC thin client and it is working
fine. Now I would like to change it so it is using secure JDBC
instead.
- from the OTN site ---
You can use Oracle Advanced Security data encryption and integrity
features in your Java database applications, depending on related
settings in the server. When using an OCI driver in a thick-client
setting, the parameters are set as in any Oracle client situation.
When using the Thin driver, the parameters are set through a Java
properties file.
- from the OTN site ---
The setup server is done similar to the description of the sample
described at this url:
http://otn.oracle.com/sample_code/deploy/security/files/secure_thin_driver/Readme.html#descsamples
The code, where I'm using a property to describe the encryption I want
to use, looks like the one pasted below.
Can some one please tell me why I get the exception below and more
important how do I fix it. I have a strange feeling that it is because
the client doesn't know the algorigthms, but where do I find these
algorithms if that is the reason?
I hope for som help soon.
Thanks in regards,
Jess
- code snip ---
java.util.Properties prop = new java.util.Properties();
prop.put("oracle.net.encryption_client", "REQUIRED");
prop.put("oracle.net.encryption_types_client", "DES40");
prop.put("oracle.net.crypto_checksum_client", "REQUESTED");
prop.put("oracle.net.crypto_checksum_types_client", "MD5");
prop.put("user", Session.DBUSR);
prop.put("password", Session.DBPWD);
String url = "jdbc:oracle:thin:@dknt4302:1521:MVJPRO";
Class.forName("oracle.jdbc.driver.OracleDriver");
java.sql.DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver())con =
java.sql.DriverManager.getConnection(url, prop);
- StackTrace ---
java.sql.SQLException: Io-undtagelse: Unknown Encryption or Data
Integrity algorithm
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at CacheTask.getConnection(CacheTask.java:39)
at CacheTask.<init>(CacheTask.java:15)
at RapportTypeTask.<init>(RapportTypeTask.java:8)
at RapporterForm.cacheRapporter(RapporterForm.java:3440)
at RapporterForm.init(RapporterForm.java:2594)
at Rapporter.init(Rapporter.java:38)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Received on Mon Nov 11 2002 - 10:07:36 CST
