Topics

1

General Asterisk configuration / Setup Wizard - AsteriskRealtime PostgreSQL

« on: September 15, 2010, 16:04:15 »

Hi Everyone,
I've got PostgreSQL on my Asterisk host and i'm trying to get the configuration from my DB with the Setup Wizard and the AsteriskRealtime mode.

I installed the JDBC Version for PostgreSQL and changed the configuration.properties   

default.autoconf.realtimedrv=org.postgresql.Driver
default.autoconf.realtimeuri=jdbc:postgresql://192.168.0.6/asterisk?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=test&password=testpw

My queuemetrics host connects succesfully to the asterisk host, but i get an exception

Code: [Select]

Errore DB: org.postgresql.util.PSQLException:Fetch size must be a value greater to or equal to 0.
I write a java application to test it. it works fine
   
     

Code: [Select]

Statement st = connection.createStatement();
st.setFetchSize(10);
ResultSet rs = st.executeQuery("SELECT * FROM ast_phone");
        while (rs.next()) {
       System.out.println("   a row was returned.   ");
         }
       rs.close();
but if i  change st.setFetchSize(-1)
     
 

Code: [Select]

Statement st = connection.createStatement();
st.setFetchSize(-1);
ResultSet rs = st.executeQuery("SELECT * FROM ast_phone");
        while (rs.next()) {
       System.out.println("   a row was returned.   ");
         }
       rs.close();
i've got exatly the exeption.

My questions are now:
can i fix it?
how can i fix it?
is that an error of my postgresql configuration?
is it possible to connect to a postgresql asterisk host with queuemetrics?

Thank you and regards,
Bauair