[GENERAL] JDBC +CIDR

2004-10-12 Thread Johann Robette
Hi, Ive a table containing a CIDR field. Im using an EJB to create a new record in this table. I dont 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 exist: cidr = text

[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 :

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

2004-10-05 Thread Johann Robette
 : 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_string(array[1, 2, 3

[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 : CREATE OR