[hibernate-dev] Problem with db2/400 and hibernate

[Savazzini Giovanni Battista]

Hi,
I've a problem with Mapping SQL native with AS/400:

File PCKLft.hbm.xml
<?xml version="1.0"?> 

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping schema="IB_DAT1">

<class name="prove.PCKLft" table="PCKLFT"> 

<composite-id>

<key-property name="idn" column="IDN" type="integer" />

<key-property name="vrs" column="VRS" type="short" />

</composite-id>

<property name="crtpot" column="CRTPOT" type="timestamp" />

<property name="crtsbj" column="CRTSBJ" type="integer" />

<property name="updpot" column="UPDPOT" type="timestamp" />

<property name="updsbj" column="UPDSBJ" type="integer" />

<property name="dsc" column="DSC" type="string" length="50" /> 

<loader query-ref="avanti" />

</class> 

<sql-query name="avanti">

<return alias="p" class="prove.PCKLft" />

SELECT DSC AS {p.dsc} FROM IB_DAT1.PCKLFT p

</sql-query>

</hibernate-mapping>

File hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration PUBLIC

"-//Hibernate/Hibernate Configuration DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

<property name="hibernate.connection.driver_class">com.ibm.as400.access.AS400JDBCDriver</property>

<property name="hibernate.connection.url">jdbc:as400://192.168.101.4</property>

<property name="hibernate.connection.username">qsecofr</property>

<property name="hibernate.connection.password">u348ds</property>

<property name="dialect">org.hibernate.dialect.DB2400Dialect</property>

<property name="show_sql">true</property>

<property name="transaction.factory_class">

org.hibernate.transaction.JDBCTransactionFactory

</property>

<property name="hibernate.cache.provider_class">

org.hibernate.cache.HashtableCacheProvider

</property>

<property name="hibernate.hbm2ddl.auto">update</property>

<mapping resource="prove/PCKLft.hbm.xml"/>

</session-factory>

</hibernate-configuration>

And the code for the Sql instruction is:

List result = session.getNamedQuery("avanti")
    .setMaxResults(6)    
    .list();

But the result is:

Hibernate: SELECT DSC FROM IB_DAT1.PCKLFT fetch first 5 rows only
WARN  - SQL Error: -99999, SQLState: 42703
ERROR - An undefined column name was detected.

The file PCKLft in the library IB_DAT1 was created with:

CREATE TABLE IB_DAT1/PCKLFT (   
IDN INT NOT NULL ,              
VRS SMALLINT NOT NULL ,         
CRTPOT TIMESTAMP ,              
CRTSBJ INT ,                    
UPDPOT TIMESTAMP ,              
UPDSBJ INT ,                    
DSC VARCHAR(50) ,               
PRIMARY KEY (IDN, VRS))         

And the SQL with the code:

Query q = session.createQuery("from PCKLft");     
q.setMaxResults(25);
List result = q.list();  

runs very well. The class runs in a PC with hibernate3.jar
I've used 2 AS/400, both with OS version V5R2.
It's the first time I don't see the solution with java and AS/400.
I hope you give to me some solutions.
THANK YOU!

Giovanni Battista Savazzini
Idrosanitaria Beltrami S.p.A.
-----------------------------------------------------
Tel.  0522/221729 - 0522/221711
Fax  0522/221730
areaelaborazionedati at beltrami.sm
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-dev/attachments/20070727/3617f4e5/attachment.html