Bugs item #438115, was opened at 2001-07-02 19:50
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=438115&group_id=22866
Category: JBossCMP
Group: v2.4 BETA (stable)
Status: Open
Resolution: None
Priority: 5
Submitted By: Michael Jara (mjara)
Assigned to: Nobody/Anonymous (nobody)
Summary: JAWS lower-cases custom finder SQL text
Initial Comment:
JAWS is now lower-casing all custom finder SQL text
specified in jaws.xml. Most database drivers seem to
ignore case, but some (such as JConnect5.2/SybaseASE)
do not.
For example, if I have this in my jaws.xml file:
<entity>
<ejb-name>EventDescription</ejb-name>
<finder>
<name>findByEventType</name>
<query>, TypeDescriptionPair,
EventType WHERE EventType.description={0} AND
EventType.enumerationIndex=TypeDescriptionPair.eventTyp
eKey AND
TypeDescriptionPair.eventDescriptionKey=EventDescriptio
n.enumerationIndex</query>
<order>EventDescription.description</order>
</finder>
</entity>
All table and field names are lower-cased on
execution. This is the trace logged in Beta 2.4:
2001-07-02 20:39:22,195 [RMI TCP Connection(8)-
161.218.184.161] DEBUG JAWS - findByEventType command
executing: SELECT EventDescription.enumerationIndex,
EventDescription.description FROM EventDescription,
typedescriptionpair, eventtype where
eventtype.description=? and
eventtype.enumerationindex=typedescriptionpair.eventtyp
ekey and
typedescriptionpair.eventdescriptionkey=eventdescriptio
n.enumerationindex ORDER BY
EventDescription.description
2001-07-02 20:39:22,195 [RMI TCP Connection(8)-
161.218.184.161] DEBUG JAWS - Set parameter: idx=1,
jdbcType=VARCHAR, value=Construction
2001-07-02 20:39:22,285 [RMI TCP Connection(8)-
161.218.184.161] DEBUG JAWS -
com.sybase.jdbc2.jdbc.SybSQLException: The column
prefix 'eventdescription' does not match with a table
name or alias name used in the query. Either the table
is not specified in the FROM clause or it has a
correlation name which must be used instead.
This DOES work properly in release 2.2 (maintaining
case as entered in jaws.xml.)
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=438115&group_id=22866
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
