RE: Changing Orion Generated SQL
well, i wanted to change the SQL used in the ejbStore method due to some problems that i was having. orion-ejb-jar.xml seems to have the SQL only for finder methods other than the findByPrimary key methods. is there any way to change that??? Thanks Aniket At 06:36 PM 12/8/2000, you wrote: Take a look at the documentation for orion-ejb-jar.xml. It's a lot easier if you have a few samples to look at alongside. http://www.orionserver.com/docs/orion-ejb-jar.xml.html What changes you have in mind? Jeff Schnitzer [EMAIL PROTECTED] -Original Message- From: Aniket V U [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 3:59 AM To: Orion-Interest Subject: Changing Orion Generated SQL Hi folks, Is there any way I can change the SQL code generated by Orion for CMP beans?? The J2EE RI allows this by editing one of the deployment config files but i wasnt able to find anything anywhere??? Thanks in advance Aniket
Re: Changing Orion Generated SQL
[Jeff Schnitzer] Take a look at the documentation for orion-ejb-jar.xml. It's a lot easier if you have a few samples to look at alongside. http://www.orionserver.com/docs/orion-ejb-jar.xml.html What changes you have in mind? For more performance-intensive entity beans attached to larger tables, it could be nice to be able add in the "hints" recognized by your particular DB (like specifying degree of parallelism in the use of oracle's parallel query in an ejb finder) This make sense? Seems doable? -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
RE: Changing Orion Generated SQL
Hi everybody, I am also interested in this topic as I have a practical problem. I would like to hook up the application to the legacy database. Therefore, I have to stick with the existing table names, column names and also the data. Is that doable in CMP? Thanks for any guidance Jarek -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeff Schnitzer Sent: 08 December 2000 13:07 To: Orion-Interest Subject: RE: Changing Orion Generated SQL Take a look at the documentation for orion-ejb-jar.xml. It's a lot easier if you have a few samples to look at alongside. http://www.orionserver.com/docs/orion-ejb-jar.xml.html What changes you have in mind? Jeff Schnitzer [EMAIL PROTECTED] -Original Message- From: Aniket V U [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 3:59 AM To: Orion-Interest Subject: Changing Orion Generated SQL Hi folks, Is there any way I can change the SQL code generated by Orion for CMP beans?? The J2EE RI allows this by editing one of the deployment config files but i wasnt able to find anything anywhere??? Thanks in advance Aniket
RE: Changing Orion Generated SQL
Of course. Just modify orion-ejb-jar.xml to reflect your schema. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jarek Skreta Sent: Friday, December 08, 2000 11:14 AM To: Orion-Interest Subject: RE: Changing Orion Generated SQL Hi everybody, I am also interested in this topic as I have a practical problem. I would like to hook up the application to the legacy database. Therefore, I have to stick with the existing table names, column names and also the data. Is that doable in CMP? Thanks for any guidance Jarek -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeff Schnitzer Sent: 08 December 2000 13:07 To: Orion-Interest Subject: RE: Changing Orion Generated SQL Take a look at the documentation for orion-ejb-jar.xml. It's a lot easier if you have a few samples to look at alongside. http://www.orionserver.com/docs/orion-ejb-jar.xml.html What changes you have in mind? Jeff Schnitzer [EMAIL PROTECTED] -Original Message- From: Aniket V U [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 3:59 AM To: Orion-Interest Subject: Changing Orion Generated SQL Hi folks, Is there any way I can change the SQL code generated by Orion for CMP beans?? The J2EE RI allows this by editing one of the deployment config files but i wasnt able to find anything anywhere??? Thanks in advance Aniket
Re: Changing Orion Generated SQL
You can't. ejbStore runs a trivial update statement. If you need to do something special you have to use bean managed persistence. Boris P.S. If you really don't want to write BMP you can try decompile the class Orion generated for your bean and add some jdbc code there. It is possible to do but very ugly. P.P.S May be you can write a trigger on that table which will do the rest of updates if your database support after update triggers. This could work but I wouldn't recommend it for production software. - Original Message - From: "Aniket V U" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 10:08 AM Subject: RE: Changing Orion Generated SQL well, i wanted to change the SQL used in the ejbStore method due to some problems that i was having. orion-ejb-jar.xml seems to have the SQL only for finder methods other than the findByPrimary key methods. is there any way to change that??? Thanks Aniket At 06:36 PM 12/8/2000, you wrote: Take a look at the documentation for orion-ejb-jar.xml. It's a lot easier if you have a few samples to look at alongside. http://www.orionserver.com/docs/orion-ejb-jar.xml.html What changes you have in mind? Jeff Schnitzer [EMAIL PROTECTED] -Original Message- From: Aniket V U [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 3:59 AM To: Orion-Interest Subject: Changing Orion Generated SQL Hi folks, Is there any way I can change the SQL code generated by Orion for CMP beans?? The J2EE RI allows this by editing one of the deployment config files but i wasnt able to find anything anywhere??? Thanks in advance Aniket
Re: Changing Orion Generated SQL
[Boris Gertsberg] You can't. ejbStore runs a trivial update statement. If you need to do something special you have to use bean managed persistence. My understanding was that with EJB 2.0, we write the abstract class with no properties (just getters/setters), Orion makes a concrete java source file, filling in necessary logic, then a final compilation phase to produce a first, initial, working class file. That would seem to provide an opportunity for modifying the source and recompiling to provide tweaks. What about this is wrong? -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
RE: Changing Orion Generated SQL
You can define the finder queries in the orion-ejb-jar.xml. Loads and stores would be more troublesome. You might be able to use database views, or as a last resort you could create a facade for the JDBC driver and manipulate the SQL on the way through. Shouldn't be that hard. Jeff -Original Message- From: James Manning [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 7:08 AM To: Orion-Interest Subject: Re: Changing Orion Generated SQL [Jeff Schnitzer] Take a look at the documentation for orion-ejb-jar.xml. It's a lot easier if you have a few samples to look at alongside. http://www.orionserver.com/docs/orion-ejb-jar.xml.html What changes you have in mind? For more performance-intensive entity beans attached to larger tables, it could be nice to be able add in the "hints" recognized by your particular DB (like specifying degree of parallelism in the use of oracle's parallel query in an ejb finder) This make sense? Seems doable? -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
RE: Changing Orion Generated SQL
Take a look at the documentation for orion-ejb-jar.xml. It's a lot easier if you have a few samples to look at alongside. http://www.orionserver.com/docs/orion-ejb-jar.xml.html What changes you have in mind? Jeff Schnitzer [EMAIL PROTECTED] -Original Message- From: Aniket V U [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 3:59 AM To: Orion-Interest Subject: Changing Orion Generated SQL Hi folks, Is there any way I can change the SQL code generated by Orion for CMP beans?? The J2EE RI allows this by editing one of the deployment config files but i wasnt able to find anything anywhere??? Thanks in advance Aniket