Hello Alex,
Thursday, August 22, 2002, 4:28:14 AM, you wrote:
AL> if I understand you right, you let JBossCMP to create and name fields
AL> and tables. In this case there is no gaurantee your
AL> query will be portable across different servers.
AL> To have database schema the same using different app servers you need
AL> to name all the fields and tables yourself and configure appropriate
AL> DD file ( jbosscmp-jdbc.xml for JBoss ). Equivalent files should be
AL> present in other app servers.
On the moment I am letting JBoss CMP create name fields and tables.
But if this will increse portability I can name them and gerate the DD
file for the target application server.
If I can map the relationships too in the same way I have no problem.
AL> And another issue with dynamic queries. The implementation of dynamic
AL> queries may differ form server to server. The following is a WL's
AL> code. Compare it to JBoss approach:
But note I do not want to use dynamic queries. Just because of that,
different approachs. What I want to do is make direct SQL (not EJB-QL)
queries to the database. As David Jencks noted this will limit it to
work on relational databases but I can accept that.
I want this to implement the Value List Handler pattern, so I can
make a dynamic query of a large number os record without the overhead
of a finder method.
AL> InitialContext ic=new InitialContext();
AL> FooHome fh=(FooHome)ic.lookup("fooHome");
AL> QueryHome qh=(QueryHome)fh;
AL> Sring ejbql="SELECT OBJECT(e)FROM EmployeeBean e WHERE e.name='rob'"
AL> Query query=qh.createQuery();
AL> query.setMaxElements(10)
AL> Collection results=query.find(ejbql);
DLR>> On another mail Dain Sundstrom says the spec does not say anything
DLR>> about mapping of CMR to database tables.
--
Best regards,
Danilo mailto:[EMAIL PROTECTED]
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
