Setting Databases jbilling with postgres

Default setting from jbilling-database.xml :

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

        <property name="driverClass" value="org.hsqldb.jdbcDriver"/>

        <property name="jdbcUrl" value="jdbc:hsqldb:file:hsql/localDB" />

        <property name="driverClass" value="org.hsqldb.jdbcDriver"/>

        <property name="jdbcUrl" value="jdbc:hsqldb:file:hsql/localDB" />

        <property name="user" value="sa" />

        <property name="password" value="" />

        <property name="acquireIncrement" value="2"/>

        <property name="initialPoolSize" value="5"/>

        <property name="maxPoolSize" value="20" />

        <property name="maxIdleTime" value="300" />

        <property name="minPoolSize" value="2" />

        <property name="checkoutTimeout" value="10000" />

    </bean>

Now you can change like this :

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

        <property name="driverClass" value="com.postgresql.Driver"/>

        <property name="jdbcUrl" value="jdbc:postgresql://localhost:5432/jbilling" />

        <property name="user" value="jbilling" />

        <property name="password" value="jbilling" />

        <property name="acquireIncrement" value="2"/>

        <property name="initialPoolSize" value="5"/>

        <property name="maxPoolSize" value="20" />

        <property name="maxIdleTime" value="300" />

        <property name="minPoolSize" value="2" />

        <property name="checkoutTimeout" value="10000" />

    </bean> 

Dont forget set your dialect:

org.hibernate.dialect.PostgreSQLDialect

Next time i will post about how to set up postgres on your server.