Sybase ASE is.
----- Original Message -----
From: "danch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 8:17 PM
Subject: Re: [JBoss-dev] [ jboss-Bugs-438115 ] JAWS lower-cases custom
finder SQL text
> 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
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
