[GENERAL] JDBC +CIDR

2004-10-12 Thread Johann Robette
Hi, I’ve a table containing a CIDR field. I’m using an EJB to create a new record in this table. I don’t know how to pass the CIDR value. I tried by String but I get this error :     javax.ejb.FinderException: Find failed: java.sql.SQLException: ERROR: operator does not ex

[GENERAL] Problem with boolean type

2004-10-07 Thread Johann Robette
Hi, I'm using Postgres 8.0 beta 3 and the appropriate JDBC Driver. I use EJB to create a record in a table containing a Boolean field "answered". The EJB method expects a Boolean object so I pass new Boolean(false) in order to create it as false. But I get the following error : java.sql.SQLExce

[GENERAL] Postgres 8.0 + JDBC

2004-10-05 Thread Johann Robette
Hello,   I have an application running under JBoss. Up to today, I was using Postgres 7.3 and the appropriate version of the jdbc driver. In my application, I have to call a user-defined function which accept in parameters 2 arrays. Here is the header of my function :    

RE : [GENERAL] Function array_to_string(text[], text) does not exist ???

2004-10-05 Thread Johann Robette
04 15:06 À : Johann Robette Cc : [EMAIL PROTECTED] Objet : Re: [GENERAL] Function array_to_string(text[], text) does not exist ??? On Tue, Oct 05, 2004 at 12:07:11PM +0200, Johann Robette wrote: > I'm trying to call the array_to_string function like this : > SELECT array_to

[GENERAL] Function array_to_string(text[], text) does not exist ???

2004-10-05 Thread Johann Robette
Hi,   I’m trying to call the array_to_string function like this :     SELECT array_to_string(array[1, 2, 3], '~^~') à it comes directly from the doc. I get this error msg :     ERROR:  parser: parse error at or near "[" at character 24   So I tried this way