tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dain Sundstrom <d...@iq80.com>
Subject Re: Qeury a boolean column?(using postgresql)
Date Thu, 22 Nov 2007 22:14:36 GMT
Sorry, been traveling, and just got back to my email.  I hope to have  
time to look at this tomorrow, but it is a bit busy for me around  
Thanksgiving.

-dain

On Nov 16, 2007, at 10:25 AM, dycharles wrote:

>
> hello,
>
>    thanks for the reply...
>
>    I am new to this ejb or persistence.... Please help me understand.
> thanks.....
>
>    Now i just followed this tutorial from netbeans
> (http://www.netbeans.org/kb/55/persistence-j2se.html) because i'm  
> using the
> netbeansIDE, then that is my persistence and ejb used... i don't  
> know what
> version i'm using in persistence and in ejb i don't know also if it is
> openEJB or ejb alone, what is the difference between the two?
>
>    Regarding with my posrgresql version i used the recent version.  
> i know
> this will support the boolean data type. in my schema in  
> postgresql, it is
> really simple i create the boolean column with boolean data type  
> and primary
> key... then thats it. And also in java i used the java6.
>
>    So, i suspect my mistake is in the persistence and ejb used...
>
> thanks,
> dycharles
>
>
> Dain Sundstrom wrote:
>>
>> Hi,
>>
>> I'm not sure why this isn't working, so I'm gonna have to attempt to
>> reproduce this problem, but I'm going to need a bit more information.
>>
>> Are you using CMP or JPA?
>> Are you using an existing database TABLE or generating one?  If
>> existing, can you share the schema for the table?
>> Can you share your CMP or JPA bean?
>> What version of Postgresql are you using? driver version?
>> What version of OpenEJB?
>>
>> In the mean time, I'll try to hack something up.
>>
>> BTW, if you're not on Java 6, give it a try.  We use OpenJPA for
>> persistence of CMP and JPA beans, and due to the new instrumentation
>> apis in Java 6, OpenJPA works a bit better.
>>
>> -dain
>>
>> On Nov 14, 2007, at 4:50 PM, dycharles wrote:
>>
>>>
>>> hello,
>>>
>>>    i have a database in postgresql that have a column boolean, then
>>> when i
>>> create a query in ejb like this(SELECT e.letsaythisisboolean FROM
>>> sample e),
>>> now problem is that when i query the database, it will return all
>>> the false
>>> value in the column boolean, and the true value will not return...
>>> How can i
>>> make the true value appear in my query result? Any suggestion or
>>> help...
>>>
>>> thanks,
>>> dychalres
>>> -- 
>>> View this message in context: http://www.nabble.com/Qeury-a-boolean-
>>> column-%28using-postgresql%29-tf4808272.html#a13757336
>>> Sent from the OpenEJB User mailing list archive at Nabble.com.
>>>
>>
>>
>>
>
> -- 
> View this message in context: http://www.nabble.com/Qeury-a-boolean- 
> column-%28using-postgresql%29-tf4808272.html#a13796483
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>


Mime
View raw message