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.
The entire section on running Groovy in the database is available.
Enjoy!
The entire section on running Groovy in the database is available.
Enjoy!
posted by Kuassi Mensah at 10:43 AM
21 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
This is really a good stuff, This sounds good. I like it. Photo Recovery
Really i appreciate the effort you made to share the knowledge.The topic here i found was really effective to the topic which i was researching for a long time
Cartoon coloring
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
Post a Comment
Links to this post:
Create a Link
<< Home