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.

The entire section on running Groovy in the database is available.

Enjoy!

19 comments:

Anonymous said...

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

Anonymous said...

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

Kuassi Mensah said...

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

Anonymous said...

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

Vehicle Tracking said...

Morally there is an argument to say that you cant patent naturally occurring things.

Recycle Mobile Phones said...

Very nice and helpful information has been given in this article. I like the way you explain the things. Keep posting. Thanks.

Pest control Auckland said...

nice blog...info mantap....mantap blognya,,,tukeran barner ya mas,,,barner mas sudah terpasang di blog saya,,,di blogroll....untuk mempererat persahabatan antar blogger,,,,

Home Furniture And Garden Furniture said...

Good blogs

Instant Hedging said...

Terrific! I overwhelmed it. I have not adequate words in gratitude. Thanks for sharing with me. I will keep stay.

Ayesha said...

You have given a nice preview. Nice ideas. Business Franchise Opportunities

search engine optimization melbourne said...

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.

Religion clothes said...

I was looking for some topics that are enough popular and finally founded your blog, it has superb topics with great popularity. Religion clothes

r4 card said...

Very nice and helpful information has been given in this article. I like the way you explain the things. Keep posting.

Inspection of Work said...

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.

Inspection of Work said...

Kudos for experimenting Groovy in the database.

Construction Safety Coordination said...

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.

Construction Safety Coordination said...

This works, the only problem still is the required manipulation of the SecurityManager to be able to pass the security checks.

Unknown said...

Thanks for the information, your post have solved my many question, thanks for the post and the help as well.
sell online

teguh wibowo said...

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