Senin, 20 Juni 2011

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.

1 komentar:

Jaya Dianto mengatakan...

mantap coy.....