Hi all.

I consider myself a total novice about configuring databases and database access. I mean massive noob ;) i've searched in the forums here, and around the website, and I couldn't find an answer for such stupid doubt as mine, and as I'm running out of time with this I really had to post this.

I have an Informix database stored, in another system. As I was following that tiny script about how to install hibernate (http://www.hibernate.org/152.html) i got stuck editing etc/hibernate.properties. And this is because i don't know how to configure Informix database access.

I have a couple of files with some configurations but i need a template like all those in that hibernate.propreties file to even imagine how could i configure it.

Anyone could give me some lights here? Thanks in advance.

I found this on the hibernate user forum:

http://forum.hibernate.org/viewtopic.php?t=943465&view=previous&sid=0148b7cad04e2a4a269c84f5f6e145e3

for v3 change net.sf to org.hibernate.

<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name="hibernate.dialect">net.sf.hibernate.dialect.InformixDialect</property>
<property name="connection.driver_class">com.informix.jdbc.IfxDriver</property>
<property name="connection.url">jdbc:informix-sqli://192.168.0.89:1527/proyecto3:INFORMIXSERVER=ol_sistemas2;</property>
<property name="connection.username">XXXX</property>
<property name="connection.password">XXXX</property>
<property name="connection.pool_size">1</property>
<property name="statement_cache.size">25</property>
<property name="proxool.pool_alias">pool1</property>
<property name="hibernate.show_sql">true</property>
<property name="jdbc.batch_size">0</property>
<property name="jdbc.use_streams_for_binary">true</property>

I Couldn't find that anywhere. That did the trick. Thanks.

glad it helped.