Ok, I found out how to add the patch to hibernate (ouf!!).
The initial problem is resolved but now, I have new problem that seems to be worse.
Here is my actual hibernate configuration file for informix :
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name="hibernate.dialect">net.sf.hibernate.dialect.Informix9Dialect</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">XXX</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>
<mapping resource="com/logis/proyecto/data/Aduana.hbm.xml" />
</session-factory>
</hibernate-configuration>
And I get the following message :
Quote:
14-nov-2003 17:24:30 net.sf.hibernate.cfg.Environment <clinit>
INFO: Hibernate 2.0.3
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Environment <clinit>
INFO: loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=sa, hibernate.connection.url=jdbc:hsqldb:test, hibernate.show_sql=false, hibernate.connection.password=, hibernate.statement_cache.size=25, hibernate.connection.pool_size=1}
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Environment <clinit>
INFO: using java.io streams to persist binary types
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Environment <clinit>
INFO: using CGLIB reflection optimizer
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Environment <clinit>
INFO: JVM proxy support: true
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration addResource
INFO: Mapping resource: com/logis/proyecto/data/Aduana.hbm.xml
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Binder bindRootClass
INFO: Mapping class: com.logis.proyecto.data.Aduana -> aduana
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration configure
INFO: Configured SessionFactory: null
14-nov-2003 17:24:31 net.sf.hibernate.dialect.Dialect <init>
INFO: Using dialect: net.sf.hibernate.dialect.Informix9Dialect
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing one-to-many association mappings
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing foreign key constraints
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing one-to-many association mappings
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing foreign key constraints
14-nov-2003 17:24:31 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
14-nov-2003 17:24:31 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.informix.jdbc.IfxDriver at URL: jdbc:informix-sqli://192.168.0.89:1527/proyecto3:INFORMIXSERVER=ol_sistemas2;
14-nov-2003 17:24:31 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=XXXX, password=XXXX}
drop table aduana
Unsuccessful: The specified table (aduana) is not in the database.
create table aduana (
ADUANAID SERIAL8 NOT NULL,
ABREVIACION ,
CLAVE not null unique,
DESCRIPCION ,
primary key (ADUANAID)
)
Unsuccessful: A syntax error has occurred.
14-nov-2003 17:24:31 net.sf.hibernate.util.JDBCExceptionReporter logWarnings
ADVERTENCIA: SQL Warning: 0, SQLState: 01I01
14-nov-2003 17:24:31 net.sf.hibernate.util.JDBCExceptionReporter logWarnings
ADVERTENCIA: Database has transactions
14-nov-2003 17:24:31 net.sf.hibernate.util.JDBCExceptionReporter logWarnings
ADVERTENCIA: SQL Warning: 0, SQLState: 01I04
14-nov-2003 17:24:31 net.sf.hibernate.util.JDBCExceptionReporter logWarnings
ADVERTENCIA: Database selected
14-nov-2003 17:24:31 net.sf.hibernate.connection.DriverManagerConnectionProvider close
INFO: cleaning up connection pool: jdbc:informix-sqli://192.168.0.89:1527/proyecto3:INFORMIXSERVER=ol_sistemas2;
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing one-to-many association mappings
14-nov-2003 17:24:31 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing foreign key constraints
14-nov-2003 17:24:32 net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
14-nov-2003 17:24:32 net.sf.hibernate.dialect.Dialect <init>
INFO: Using dialect: net.sf.hibernate.dialect.Informix9Dialect
14-nov-2003 17:24:32 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
14-nov-2003 17:24:32 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.informix.jdbc.IfxDriver at URL: jdbc:informix-sqli://192.168.0.89:1527/proyecto3:INFORMIXSERVER=ol_sistemas2;
14-nov-2003 17:24:32 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=XXXX, password=XXXX}
14-nov-2003 17:24:32 net.sf.hibernate.ps.PreparedStatementCache <init>
INFO: prepared statement cache size: 25
14-nov-2003 17:24:32 net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: Use outer join fetching: false
14-nov-2003 17:24:32 net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: Use scrollable result sets: true
14-nov-2003 17:24:32 net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: echoing all SQL to stdout
YA
14-nov-2003 17:24:32 net.sf.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: no JDNI name configured
14-nov-2003 17:24:32 net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: Query language substitutions: {no='N', true=1, yes='Y', false=0}
I didn't make any change to my mapping file Aduana.xml ... as you can see the type for my fields isn't generated anymore.
Has anybody the same probleme ?
Sylvain