Oracle Database Integration with Java, JavaScript, Hadoop, Spark
I - Java in the database, JDBC, UCP, DRCP, Application Continuity, Transaction Guard
II - Oracle Datasource for Hadoop (OD4H), In-Database Container for
Hadoop, Orale Datasource for Spark
III - JavaScript Stored Procedures using Nashorn
All topics discussed here represent my own opinions and speculations.
Sunday, November 16, 2008
Read parts of my book on Google Books
I just found out that parts of my book (fragments ranging from page 224 to page 374) has been scanned and available online.
Hi Kuassi, I found the chapter on running Groovy Scripts in the database very useful. Unfortunately I encounter some additional issues with java security using current release 1.5.7. I write the experience down ad post it on www.db-nemec.com/groovy/Running_Groovy_Scripts_in_the_Database.html. I’d enjoy if you could review it and possible propose some better solution how to deal with the security exceptions. I general I thing that Groovy can be very handy in Oracle database especially for leveraging templates and builder – I add some basic examples in my post.
Kudos for experimenting Groovy in the database. It look like the root cause is that the Permission (java.lang.RuntimePermission accessDeclaredMembers) has not been granted to /appl/home/oracle/groovy/groovy-all-1.5.7.jar. Can you: 1) grant the permission (look for this article http://www.oracle.com/technology/oramag/oracle/03-jul/o43devjvm.html) 2) replace SQL> select dbms_java.runjava () by SQL>set serveroutput on SQL>call dbms_output.put_line(dbms_java.runjava(...));
Hi Kuassi, Thanks for the valuable comments. I add the privilege as proposed exec dbms_java.grant_permission( 'GROOVY', 'SYS:java.lang.RuntimePermission', 'accessDeclaredMembers', 'file:/appl/home/oracle/groovy/groovy-all-1.5.7.jar' );
Unfortunately I got a java.lang.ExceptionInInitializerError running dbms_output.put_line(dbms_java.runjava(...)); with GROOVY user Connected with SYS was the run OK.
This is not really a problem as I see much more perspective the way of loading the groovy jar in DB and running the scripts using TestGroovyShell – as you proposed in your book. This works, the only problem still is the required manipulation of the SecurityManager to be able to pass the security checks.
My current problems are:
1) I’m not able to javaload the groovy all jar successfully. Even using –genmissing the load fails with some ORA-29534: referenced object xxx could not be resolved. The problem is that some referenced classes that are missing in the jar are not generated. Actually I manage a successful complete load once, but I can’t repeat it. Are there some hidden parameters such a classpath, resolver, priviledes etc. that can influence the result?
2) I’m not able to dump the loaded classes. This will at least workaround the problem 1 and speed up the installation. I found three possibilities of class dumping in your book but neither works for me in 11.1.0.6.
Despite those problems it works and I complete some promising examples. There are some home works still to be done such a support for CLOB – I crashed on a VARCHAR2 boundary while generating a script for a long partitioned table.
nice blog...info mantap....mantap blognya,,,tukeran barner ya mas,,,barner mas sudah terpasang di blog saya,,,di blogroll....untuk mempererat persahabatan antar blogger,,,,
I general I thing that Groovy can be very handy in Oracle database especially for leveraging templates and builder – I add some basic examples in my post.
I found the chapter on running Groovy Scripts in the database very useful. Unfortunately I encounter some additional issues with java security using current release 1.5.7.
Despite those problems it works and I complete some promising examples. There are some home works still to be done such a support for CLOB – I crashed on a VARCHAR2 boundary while generating a script for a long partitioned table.
19 comments:
kuassi,
i want to start off this blog by saying ur book was very interesting. I read it from cover to cover in one sitting. keep on the great work!!!
Hi Kuassi,
I found the chapter on running Groovy Scripts in the database very useful. Unfortunately I encounter some additional issues with java security using current release 1.5.7. I write the experience down ad post it on www.db-nemec.com/groovy/Running_Groovy_Scripts_in_the_Database.html. I’d enjoy if you could review it and possible propose some better solution how to deal with the security exceptions.
I general I thing that Groovy can be very handy in Oracle database especially for leveraging templates and builder – I add some basic examples in my post.
Great book that save me lot of time!
Regards,
Jaromir D.B. Nemec
Hi Jaromir,
Kudos for experimenting Groovy in the database.
It look like the root cause is that the Permission
(java.lang.RuntimePermission accessDeclaredMembers) has not been granted to /appl/home/oracle/groovy/groovy-all-1.5.7.jar.
Can you:
1) grant the permission (look for this article http://www.oracle.com/technology/oramag/oracle/03-jul/o43devjvm.html)
2) replace
SQL> select dbms_java.runjava ()
by
SQL>set serveroutput on
SQL>call dbms_output.put_line(dbms_java.runjava(...));
Kuassi
Hi Kuassi,
Thanks for the valuable comments. I add the privilege as proposed
exec dbms_java.grant_permission( 'GROOVY', 'SYS:java.lang.RuntimePermission', 'accessDeclaredMembers', 'file:/appl/home/oracle/groovy/groovy-all-1.5.7.jar' );
Unfortunately I got a java.lang.ExceptionInInitializerError running dbms_output.put_line(dbms_java.runjava(...)); with GROOVY user
Connected with SYS was the run OK.
This is not really a problem as I see much more perspective the way of loading the groovy jar in DB and running the scripts using TestGroovyShell – as you proposed in your book. This works, the only problem still is the required manipulation of the SecurityManager to be able to pass the security checks.
My current problems are:
1) I’m not able to javaload the groovy all jar successfully. Even using –genmissing the load fails with some ORA-29534: referenced object xxx could not be resolved.
The problem is that some referenced classes that are missing in the jar are not generated. Actually I manage a successful complete load once, but I can’t repeat it. Are there some hidden parameters such a classpath, resolver, priviledes etc. that can influence the result?
2) I’m not able to dump the loaded classes. This will at least workaround the problem 1 and speed up the installation. I found three possibilities of class dumping in your book but neither works for me in 11.1.0.6.
Despite those problems it works and I complete some promising examples. There are some home works still to be done such a support for CLOB – I crashed on a VARCHAR2 boundary while generating a script for a long partitioned table.
Regards,
Jaromir D.B. Nemec
Morally there is an argument to say that you cant patent naturally occurring things.
Very nice and helpful information has been given in this article. I like the way you explain the things. Keep posting. Thanks.
nice blog...info mantap....mantap blognya,,,tukeran barner ya mas,,,barner mas sudah terpasang di blog saya,,,di blogroll....untuk mempererat persahabatan antar blogger,,,,
Good blogs
Terrific! I overwhelmed it. I have not adequate words in gratitude. Thanks for sharing with me. I will keep stay.
You have given a nice preview. Nice ideas. Business Franchise Opportunities
I general I thing that Groovy can be very handy in Oracle database especially for leveraging templates and builder – I add some basic examples in my post.
I was looking for some topics that are enough popular and finally founded your blog, it has superb topics with great popularity. Religion clothes
Very nice and helpful information has been given in this article. I like the way you explain the things. Keep posting.
I found the chapter on running Groovy Scripts in the database very useful. Unfortunately I encounter some additional issues with java security using current release 1.5.7.
Kudos for experimenting Groovy in the database.
Despite those problems it works and I complete some promising examples. There are some home works still to be done such a support for CLOB – I crashed on a VARCHAR2 boundary while generating a script for a long partitioned table.
This works, the only problem still is the required manipulation of the SecurityManager to be able to pass the security checks.
Thanks for the information, your post have solved my many question, thanks for the post and the help as well.
sell online
obat kutil kelamin kaskus
lama pengobatan kutil kelamin
obat kutil kelamin mujarab
obat kutil kelamin medis
mengobati kutil kelamin secara medis
obat kutil kelamin paling murah
jual obat kutil kelamin murah
kutil kelamin dan pengobatan nya
obat kutil kelamin tanpa operasi
pengobatan setelah operasi kutil kelamin
pengobatan penyakit kutil kelamin wanita
cara mengobati kutil kelamin pria
mengobati kutil pada kelamin pria
mengobati kutil kelamin dengan propolis
pengobatan kutil pada kelamin
obat kutil kelamin resep dokter
obat kutil kelamin salep
Cara mengobati herpes di kemaluan pri dan wanita
Pengobatan herpes kelamin atau herpes genital ampuh
Obat herpes kulit
Obat herpes simplex
Obat herpes genital
Obat herpes di apotik
Obat herpes kulit di apotik
Obat herpes genital di apotik
Obat herpes untuk bayi
Obat herpes untuk ibu hamil
Obat herpes ampuh
Obat herpes untuk anak
Obat herpes mulut
Post a Comment