Обсуждение: boolean problem

Hello again =:-D

Postgresql 7.3.2 Mac OSX
Tomcat 4.1 Mac OSX

My webapp is asking for a boolean and Postgresql is returning "t"
interpreted as a string by the application... I though that the JDBC
driver took care of little things like that?

TIA

Tony Grant


--
www.tgds.net Library management software toolkit

On Mon, 18 Oct 2004, Tony Grant wrote:

> Hello again =:-D
>
> Postgresql 7.3.2 Mac OSX
> Tomcat 4.1 Mac OSX
>
> My webapp is asking for a boolean and Postgresql is returning "t"
> interpreted as a string by the application... I though that the JDBC
> driver took care of little things like that?
>

It is entirely unclear what you are actually doing?  What ResultSet method
are you using?  getBoolean, getString, getObject?  How about a couple
lines of sample code that show what you are doing, what the result is, and
what you expect the result to be?

Kris Jurka

Le lun 18/10/2004 à 21:18, Kris Jurka a écrit :

> > Postgresql 7.3.2 Mac OSX
> > Tomcat 4.1 Mac OSX
> >
> > My webapp is asking for a boolean and Postgresql is returning "t"
> > interpreted as a string by the application... I though that the JDBC
> > driver took care of little things like that?
> >
>
> It is entirely unclear what you are actually doing?  What ResultSet method
> are you using?  getBoolean, getString, getObject?  How about a couple
> lines of sample code that show what you are doing, what the result is, and
> what you expect the result to be?

<%
Driver Driverhowmanyworks =
(Driver)Class.forName(MM_frac_DRIVER).newInstance();
Connection Connhowmanyworks =
DriverManager.getConnection(MM_frac_STRING,MM_frac_USERNAME,MM_frac_PASSWORD);
PreparedStatement Statementhowmanyworks =
Connhowmanyworks.prepareStatement("SELECT count(*)=1 as works  FROM
oeuvre, cree_par, collection  WHERE oeuvre.oeuvre_id =
cree_par.oeuvre_id  AND cree_par.artiste_id = collection.individu_id AND
collection.nom ILIKE '%" + howmanyworks__varNom + "%'");
ResultSet howmanyworks = Statementhowmanyworks.executeQuery();
boolean howmanyworks_isEmpty = !howmanyworks.next();
boolean howmanyworks_hasData = !howmanyworks_isEmpty;
Object howmanyworks_data;
int howmanyworks_numRows = 0;
%>

And in the page

<% if ((((howmanyworks_data = howmanyworks.getObject("works"))==null ||
howmanyworks.wasNull())?"":howmanyworks_data)) { // Adv Conditional
Region %>

incompatible types
found   : java.lang.String
required: boolean

I have tried with boolean but to no avail

operator == cannot be applied to boolean,

Cheers

Tony Grant

--
www.tgds.net Library management software toolkit

On Tue, 19 Oct 2004, Tony Grant wrote:

> <% if ((((howmanyworks_data = howmanyworks.getObject("works"))==null ||
> howmanyworks.wasNull())?"":howmanyworks_data)) { // Adv Conditional
> Region %>
>
> incompatible types
> found   : java.lang.String
> required: boolean
>

This is a Java error, not a postgresql error.  The following statement is
being used as a boolean value, but one half returns a String and the other
an Object, neither is a boolean.

if ( (<null check>)?"":howmanyworks_data) {

Kris Jurka