Does anybody know what databases are case sensitive WRT column and table
names (or even keywords). I've never run into case sensitive SQL
databases before.
[EMAIL PROTECTED] wrote:
> 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
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development