AW: setting-up scarab 0.21 for oracle 10g

>Quartz is not an integral part of scarab. It was a recent addition to 
enable scheduling specifically for notifications. Notifications use to be 
"live" and five subsequent edits on an issue resulted in 5 separate 
emails. Now with the scheduling in place, edits (and their notifications) 
are queued and sent in bundles. really a very nice feature. i'm unsure 
how to go about disabling it. (Jorge is the man here). Maybe try 
commenting out the quartz section in componentConfiguration.xml ...

Well, in my Struts app I have a small build-in Scheduler doing exactly this.
Our dicussion board element  and the newsletter element dealing with this
issues.
We made a simple solution: all mails are stored in a database table. The
mail-scheduler looks every five minutes if there a mails not successfully send
and sends theses. 
The only thing I have to to is putting the mail in the mail-queue table ...
Bundling several emails in one is not yet implemented but could be done quite
easily.
Thanks for the hint - I will habve a look there.

>> Make it simple and stupid is my credo. 

>Sure. i agree. use mysql.

I´m using mysql on our local file server for years.
Twice I had a crash of the tables and hat to recover from backup.
Upgrading to a new version provided incompatibilities - 2 days work to sort it
out.
Using mySql as a persistence box storing java objects seems to be ok, but I love
the triggers, jobs and other database-bound tools Oracle has to offer. And I´m
using Oracle 10 years now without any data loss.


>Really, mysql is amazing simple to set up. and what is the necessity in 
having all your databases in one installation? run mysql on the same box 
as scarab and add a cronjob to take db dumps and store them somewhere 
that is regularly backed up. 
I´m an admirer of dedicated machines: a tomcat memory leak cannot bring down my
database server.
We have 9 servers - several of them using the database server and retrieving and
storing data.
One of our apps generates about 30 queries - every second. A shared server would
be dead in minutes ...

>Sure oracle is the best database out there, 
>but what benefit is it going to offer you against scarab? it seems 
nothing but a headache for you. scarab's use is standard sql AFAIK so you 
wont be finding yourself in a vendor-lock-in, or drifting away from the 
oracle world...

I don´t have any problem with the vendor-lock because the alternative means
sloooowwww performance. Not using Oracles connect-by when you could and replace
it with standard sql means a lousy implementation. With a Java-centric view
looking at the database just as a persistence storage it´ok - but a data-centric
application (all my apps are data-centric  and scarab too as you stated above)
should squeeze every quint of performance out of the database. With a
vendor-independent approach that is simply not possible.

And as I said in some mails back: I need to autoregister people already
registered in my webapp. The simpliest way would be to write a pl/sql-procedure
and call it by trigger or every half an hour by the oracle job-scheduler.

But well, If it´s to complicated the alternative is to setup a mysql/scarab box
and write a service class to transfer the user data from oracle to scarab.

>i'm not trying to convert you, just keep you to your creed.

>... but it'd also be great if you stick with oracle and iron out these 
>hurdles :-)

I´m a little annoyed about the velocity errors. Can I ignore them ?

Regards,
Norbert