I want to run a particular query in Oracle DB periodically(I dont want to use dbms_job in oracle).How can I run a query in oracle using MBean scheduler?
Take a look at the scheduler-service.xml in the jboss distribution. (in deploy directory). Basically you can reuse the SchedulableMBeanExample found in org/jboss/varia/scheduler/example directory to do the scheduling!!