Oracle does not grok "true" or "false" . It does not have a boolean data 
type.

According to my "SQL in a Nutshell", neither does Microsoft SQL Server 
or MySQL. Postgres on the other hand does.

Consequently standardjbosscmp-jdbc.xml maps booleans in Oracle:

          <mapping>
             <java-type>java.lang.Boolean</java-type>
             <jdbc-type>BIT</jdbc-type>
             <sql-type>NUMBER(1)</sql-type>
          </mapping>



On Tuesday, May 14, 2002, at 01:50  PM, Dain Sundstrom wrote:

> I don't get this. The log says it is executing this query:
>
> SELECT DISTINCT
>     t0_bean.a_Boolean, t0_bean.an_Int, t0_bean.a_Long,
>     t0_bean.a_Double, t0_bean.a_String
> FROM CMP2ENTITY t0_bean
> WHERE t0_bean.a_Boolean = true
>
> So what is wrong with that where clause?  Are there any Oracle DBAs out 
> there that can shed some light on to why this query is rejected.
>
> -dain
>
> Stephen Coy wrote:
>
>> Reposted here at Dain's request...
>> Begin forwarded message:
>>  Hi All,
>>  I think I have found a bug when specifying your own finder method 
>> with EJB QL and Oracle.
>>  The problem is that in EJB QL any comparisons to a boolean field must 
>> be made using the keywords TRUE or FALSE.  When I do this I get an 
>> exception come back fromOracle telling me it doesn't know the field 
>> name.  It seems that JBoss is not converting the TRUE or FALSE to a 1 
>> or 0 when it sends the SQL to Oracle, that is, "...wheremyBoolean = 
>> true" is being sent to Oracle.
>>  I have tried all possible sensible <jdbc-type> to <sql-type> tags in 
>> the XML files.
>>  Anyway,I have created a unit test package for this - it is attached.  
>> It plugs into the JBoss testsuite. To compile the test, you will need 
>> to add the following to the jboss-all/testsuite/build.xml:
>>    <target name="jars" description="Builds all jar files." 
>> depends="compile,
>>                    ...
>>                    _jars-dbtest,
>>                    _jars-findWhereBoolean,
>>                    ...
>>                    _jars-bankiiop">
>>   </target>
>>   <!-- findWhereBoolean test -->
>>   <target name="_jars-findWhereBoolean">
>>     <mkdir dir="${build.lib}"/>
>>     <!-- build findWhereBooleanTestClient.jar -->
>>     <jar jarfile="${build.lib}/findWhereBooleanTestClient.jar" 
>> manifest="${build.etc}/manifest.mf">
>>       <fileset dir="${build.classes}">
>>         <patternset refid="common.test.client.classes"/>
>>         <include name="org/jboss/test/findWhereBoolean/interfaces/**"/>
>>         <include name="org/jboss/test/findWhereBoolean/test/**"/>
>>       </fileset>
>>       <fileset dir="${build.resources}/findWhereBoolean">
>>         <include name="*.*"/>
>>       </fileset>
>>     </jar>
>>     <!-- build findWhereBoolean.jar -->
>>     <jar jarfile="${build.lib}/findWhereBoolean.jar">
>>       <fileset dir="${build.classes}">
>>         <patternset refid="common.test.application.classes"/>
>>         <include name="org/jboss/test/findWhereBoolean/interfaces/**"/>
>>         <include name="org/jboss/test/findWhereBoolean/bean/**"/>
>>       </fileset>
>>       <fileset dir="${build.resources}/findWhereBoolean">
>>         <include name="**/*.xml"/>
>>       </fileset>
>>     </jar>
>>   </target>
>>  If you're interested, the actual JBoss server.log error message and 
>> stack trace is:
>>  2002-05-13 18:18:45,506 DEBUG 
>> [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CMP2Entity.findAllWhereBooleanIsTrue]
>>  Executing SQL: SELECT DISTINCT t0_bean.a_Boolean, t0_bean.an_Int, 
>> t0_bean.a_Long, t0_bean.a_Double, t0_bean.a_String FROM CMP2ENTITY 
>> t0_bean WHERE t0_bean.a_Boolean = true
>> 2002-05-13 18:18:45,516 DEBUG 
>> [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.CMP2Entity.findAllWhereBooleanIsTrue]
>>  Find failed
>> java.sql.SQLException: ORA-00904: invalid column name
>>  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
>>  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
>>  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
>>  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
>>  at 
>> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
>>  at 
>> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
>>   at 
>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
>> (OracleStatement.java:2331)  at 
>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
>> (OraclePreparedStatement.java:422)  at 
>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery
>> (OraclePreparedStatement.java:366)  at 
>> org.jboss.resource.adapter.jdbc.local.PreparedStatementInPool.executeQuery(
>> PreparedStatementInPool.java:862)  at 
>> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
>> (JDBCAbstractQueryCommand.java:107)  at 
>> org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute
>> (JDBCFindEntitiesCommand.java:40)  at 
>> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities
>> (JDBCStoreManager.java:466)  at 
>> org.jboss.ejb.plugins.CMPPersistenceManager.findEntities
>> (CMPPersistenceManager.java:348)  at 
>> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(
>> CachedConnectionInterceptor.java:284)  at 
>> org.jboss.ejb.EntityContainer.find(EntityContainer.java:662)
>>  at java.lang.reflect.Method.invoke(Native Method)
>>  at 
>> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
>> (EntityContainer.java:1111)  at 
>> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
>> (AbstractInterceptor.java:73)  at 
>> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome
>> (EntitySynchronizationInterceptor.java:230)  at 
>> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(
>> CachedConnectionInterceptor.java:176)  at 
>> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome
>> (EntityInstanceInterceptor.java:134)  at 
>> org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome
>> (EntityLockInterceptor.java:79)  at 
>> org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome
>> (EntityCreationInterceptor.java:44)  at 
>> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
>> (AbstractTxInterceptor.java:98)  at 
>> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions
>> (TxInterceptorCMT.java:167)  at 
>> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:
>> 52)
>>  at 
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
>> (SecurityInterceptor.java:104)  at 
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:109)
>>  at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
>>  at org.jboss.ejb.Container.invoke(Container.java:727)
>>  at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
>>  at 
>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>  at 
>> org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:364)
>>  at java.lang.reflect.Method.invoke(Native Method)
>>  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
>>  at sun.rmi.transport.Transport$1.run(Transport.java:152)
>>  at java.security.AccessController.doPrivileged(Native Method)
>>  at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
>>  at 
>> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
>>  at 
>> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
>> 706)  at java.lang.Thread.run(Thread.java:484)
>>  I would appreciate any fix or workaround.
>> Thanks,
>> Evan.
>>  Evan Toliopoulos
>> Whitesmiths Australia Pty Ltd
>> Level 6, 44 Miller Street
>> North Sydney, 2060, Australia
>> Tel: + 61 2 8912 1728
>> Fax: + 61 2 8912 1701
>> Web: http://www.whitesmiths.com.au
>>
>
>
> -- xxxxxxxxxxxxxxxxxxxxxxxxx
> Dain Sundstrom
> Chief Architect, JBossCMP
> JBoss Group, LLC
> xxxxxxxxxxxxxxxxxxxxxxxxx
>


_______________________________________________________________

Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: [EMAIL PROTECTED]
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to