> That is me. I like this feature. Are you thinking about
> just adding an
> empty tag to the cmp-field element. Something like <index/>?
I went through the entity deployment before I asked the original
question and was thinking more along the lines of automatic index
generation, i.e. if the finder is specified and the CMP engine
can generate an index then it should apply it. Being a lazy
developer :-), I would rather the CMP engine did this unless I
had reason to believe that it was too costly.
If it was too costly then I would like an option to switch it off
and, potentially, override the generated indexes.
I was thinking of making some changes to the jbosscmp-jdbc.xml file,
nested within the entity element. Perhaps something like the following?
<entity>
...
<indexes>
<index>
<index-name>XXX</index-name>
<fields>
<field-name>field1</field-name>
...
<field-name>fieldX</field-name>
</fields>
</index>
...
</indexes>
</entity>
If the indexes entry is specified then the CMP engine would not
generate the indexes and would use the ones specified. Does this
sound reasonable?
I was also thinking of adding an entry to the defaults element
which would indicate whether automatic generation was desirable.
Perhaps something like the following?
<defaults>
...
<generate-indexes>true</generate-indexes>
</defaults>
I was going to start with this being false, developing the specified
indexes part first :-) and then moving on to automatic generation.
What do you think?
BTW Which CVS branch should I be using as a base for this? I'm
going to make the changes to our local source initially, which has
drifted from head, and then will look at moving it into CVS. It's
just so that I can try out the changes before updating our version
of jboss.
> You will have to add a template to the db confess like we do with
> foreign key constraints.
Thanks, I know about that. I've recently written a progress db mapping
for the CMP engine. The jboss side was easy but progress jdbc seems
to do something funny with catalogs, it reports a catalog name and
then complains when you use it to check on the table's existence.
I had to write a proxy driver class with a wrapper around the connection
to hide it. The other problem is that it doesn't support the XA stuff :-(.
Thanks,
Kev
Kevin Conner
Orchard Information Systems Limited
Newcastle Technopole, Kings Manor
Newcastle Upon Tyne, NE1 6PA. United Kingdom
Registered in England, Number 1900078
Tel: +44 (0) 191-2032536 Fax: +44 (0) 191 2302515
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
