Unknown Parameter: Unknown Coloumname MyColoumn ERRORCODE=-4460, SQLSTATE=null by entityManager.createNativeQuery ----------------------------------------------------------------------------------------------------------------- Key: HHH-6956 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6956 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.9 Environment: - JDK 1.6 - WebSphere 7.0 (Windows and zLinux) - Hibernate 3.6.9-Final - DB2 OS / 390 Reporter: Thomas Krippner Priority: Critical If I make a native Query to DB2 with org.hibernate.dialect.DB2390Dialect dialect the org.hibernate.loader.custom.CustomLoader.Metadata Class search the Result Column Names in the Lable Column and not in Columnname. Problem is Cant make native Queries on Tables with "Label" description. In line 579 in org.hibernate.loader.custom.CustomLoader is : return factory.getDialect().getColumnAliasExtractor().extractColumnAlias( resultSetMetaData, position ); The dialect Class is now org.hibernate.dialect.Dialect. At Line 1696 the Extractor gets the Label Extractor to the CustomLoader. public ColumnAliasExtractor getColumnAliasExtractor() { return ColumnAliasExtractor.COLUMN_LABEL_EXTRACTOR; } The effect is now, that the extractor get the Label of Tabel as Coloumnname to the rowProcessor. And the JDBC ResultSet can't find the Column. The ColumnAliasExtractor.COLUMN_NAME_EXTRACTOR is never used in this case and that is the Issue. My Test: Persistence.xml <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence_2_0.xsd&q... version="2.0"> <persistence-unit name="TEST" transaction-type="JTA"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <jta-data-source>jdbc/DB2</jta-data-source> <exclude-unlisted-classes>true</exclude-unlisted-classes> <properties> <property name="hibernate.ejb.cfgfile" value="db2_config.xml" /> </properties> </persistence-unit> </persistence> db2_config.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="jta.UserTransaction">java:comp/UserTransaction</property> <property name="current_session_context_class">jta</property> <property name="dialect">org.hibernate.dialect.DB2390Dialect</property> <property name="default_schema">SCHEMA</property> <property name="show_sql">true</property> <property name="format_sql">true</property> <property name="generate_statistics">true</property> </session-factory> </hibernate-configura EntityManager entityManager = JPAUtil.getEntityManager("TEST"); Query query = entityManager.createNativeQuery("select * from MyTable"); List<Object> ts = (List<Object>) query.getResultList(); System.out.println(ts); Database Definition is: CREATE TABLE MyTable ( ID DECIMAL(15) NOT NULL ,A DECIMAL(15) NOT NULL ,B INTEGER NOT NULL ,C INTEGER NOT NULL ,D DECIMAL(11, 8) NOT NULL ) COMMENT ON TABLE MyTable IS 'description'; LABEL ON TABLE MyTable IS 'Description Two'; LABEL ON MyTable ( ID IS 'My Column Description' , A IS 'Description A' , B IS 'Description B' , C IS 'Description C' , D IS 'Description D' ) On My German System StackTrace Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][3.62.56] Ungültiger Parameter: Unbekannter My Column Description. ERRORCODE=-4460, SQLSTATE=null at com.ibm.db2.jcc.am.fd.a(fd.java:660) at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:103) at com.ibm.db2.jcc.am.hb.a(hb.java:1889) at com.ibm.db2.jcc.am.ym.a(ym.java:1803) at com.ibm.db2.jcc.am.ym.getShort(ym.java:1562) at de.mypackage.basis.sql.ResultSet.getShort(ResultSet.java:825) at org.hibernate.type.descriptor.sql.SmallIntTypeDescriptor$2.doExtract(SmallIntTypeDescriptor.java:61) at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:254) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:250) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:235) at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:505) at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:451) at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:348) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:639) at org.hibernate.loader.Loader.doQuery(Loader.java:829) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira