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.
