ok , i'll try to explain why i need working from persistence layer, and don't want bulk operations,
1.i wrote so large EJB Application, i have distributed transactions and distributed databases, i have 4 ejb applications which are working each other, and also i have two database : 1 - oracle 10g database for billing operations and 2 - oracle timesten database for live operations, my collaborator developers wrote one application using Threads and Oracle Timesten and this application send me Messages by Tibco Rendezvous (This is Network Application for Changing messages between some application, wrote different languages), my program must be catch all messages and persist them into oracle database (also write oracle timesten database) 1. my entity persist operation is not so dummy (there is some selects, then some business logic, some validations and after all persist them) , if i choose bulk insert using stored procedures, then stored procedure must be contain this business logic which i have into java ( This is not good - this is not simple business logic !!!!!! on this case i will have two application : one - into java and second into oracle); 2, The second problem is that i want write sonme data into multiple database (one of them is oracle and second one is timesten into one transaction) , how is it possible using stored procedures..... and maybe my first request 10,000 per second maybe is so many for persistence layer, but 1000 insert into oracle database without any business logic (only dummy insert), It is not possible ? it is not good, i don't thing that it is not impossible (maybe my database need some performance), i am trying to do this like oskar.carlstedt tald me anonymous wrote : | The data files are normally not optimized for either reading and/or writing. | i hear about optimization for this operation into Operation system, i will talk with my system and database administrators. Regards, Paata View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039874#4039874 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4039874 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
