Menu
▾
▴
#282 Indexing of finders, identifier lengths and quoting
This patch allows a developer to specify an index
on container generated tables. The patch is based
on the source in the 3.0.2 download (our current
version)
The patch includes configuration for automatic
index generation although the supporting code is
not yet written. I will complete this at a later date.
An example jbosscmp-jdbc.xml file: -
<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD
JBOSSCMP-JDBC 3.0//EN"
"http://www.jboss.org/j2ee/dtd/jbosscm
p-jdbc_3_0.dtd">
<jbosscmp-jdbc>
<enterprise-beans>
<entity>
<ejb-name>TestEntity</ejb-name>
<indexes>
<index>
<index-name>nameindex</index-name>
<fields>
<field-name>name</field-name>
</fields>
</index>
</indexes>
</entity>
</enterprise-beans>
</jbosscmp-jdbc>
diffs for 3.0.2
Logged In: YES
user_id=598569
Sorry, I've been sending an out of date patch.
I've attached the correct one below.
The only difference is in JDBCStartCommand, I had to
move the tableExists call from createTable into execute.
diffs for 3.0.2
Logged In: YES
user_id=598569
I tried to delete the previous version of the diffs but the
system would not allow me. The correct one is the
entry with file_id 31463.
Sorry about the confusion.
Kev
Logged In: YES
user_id=598569
There was a simple bug in the patch I sent, I forgot to
add the tableExists check to the CMR create table.
I'm about to update the patch to 3.0.4 so that we can
move over to the latest source, I'll post an updated
patch next week.
Kev
New set of diffs for CMP modifications
Logged In: YES
user_id=598569
The following patch is a rollup of all the CMP changes I
have made to our version of jboss-3.0.2.
This patch contains the original index configuration, a
check for maximum identifier length and quoting.
The metadata stored in jboss-3.0.2 was inconsistent
and the majority of the changes required for the
identifier modifications are to rectify this situation.
Kev
Logged In: YES
user_id=598569
Please do not use the last patch. We have just had a
developer move back to hypersonic, using a slightly
newer patch, and it has fallen over.
Initial investigation shows what can best be described
as an inconsistency in the handling of the quotes. I will
have another look at it over the weekend and provide an
update when fixed and tested with hypersonic.
Kev
Logged In: YES
user_id=251431
I am no no longer a JBoss committer, so I am unable to apply
any patches.