Converting SQL update based application to java rule based application

I have an data centric & data sensitive application, which is written using java, but almost all the business logic is maintained in a .sql files.

These sql files are executed 1 by 1 , temporary table is created and updated by these sql files.

Internally these sql files fire update queries on temporary table with available data values on various conditions.

finally the temporary table is dumped into a physical table.

We are planning to move this to java rule based application as sql scripts are getting huge and hard to understand as well as maintain.

Planning to have all the data in memory using Lucene & its RAMDiirectory, what would be the preferred choice for building rules (these are nothing but update queries in sql)

Was looking @ s开发者_开发问答cripting languages to have dynamic rules, but scripts (rhino / groovy) have same characteristics as that of sql files (hard to write & maintain)

Please post your suggestions.

Thanks in advance!!

---

Our company uses Drools. Works really great for us. Drools normally has you write your rules in an XML-based format, but we just extended some of their classes so we could write our rules in Java (allows us to debug the rules at runtime).

---

We also use JBoss Rules / Drools.The newer version (> 4.0.0) has a nice DSL that is perfectly readable and maintainable.No more XML is needed.