Hi,

I am using Hibernate to get the data from oracle. I am creating a Query as follows..

Query myQuery = session.createQuery("select p.partMasterKey , p.partMasterKeyDisplay ,p.partMasterKeyDesc from Parts p, PartsService si where p.partMasterKey=si.partMasterKey and si.nsqKey="+gsqNumber);

orderList = (ArrayList)myQuery.list();

Whre gsqNumber is comming from page.

I tried to execute the query generated by Hibernate in oracle it looks fine but when i am trying it from front end (java) it is giving following exception....

org.hibernate.util.JDBCExceptionReporter SQL Error: 17059, SQLState: null
org.hibernate.util.JDBCExceptionReporter Fail to convert to internal representation

Full stack trace is...

Caused by: java.sql.SQLException: Fail to convert to internal representation
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at oracle.jdbc.driver.OracleStatement.getIntValue(OracleStatement.java:4479)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:536)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:1528)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getInt(WSJdbcResultSet.java:1341)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.type.IntegerType.get(IntegerType.java:26)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.loader.hql.QueryLoader.getResultColumnOrRow(QueryLoader.java:357)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:329)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.loader.Loader.doQuery(Loader.java:412)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R at org.hibernate.loader.Loader.doList(Loader.java:1593)
[6/25/08 15:30:58:795 IST] 10c0da7 SystemErr R ... 221 more

Change and replace your query by following

Query myQuery = session.createQuery("select p.partMasterKey , p.partMasterKeyDisplay ,p.partMasterKeyDesc from Parts p where p.partsService.nsqKey ="+gsqNumber);

You don't need to mention PartsService in from clause as you are not retrieving any data from PartsService. When you write p.partsService.nsqKey, hibernate automatically does equijoin between Parts and ParstService.

Thanks for valuable help.

Do we need any PartsService object in Parts class?

Query myQuery = session.createQuery("select p.partMasterKey , p.partMasterKeyDisplay ,p.partMasterKeyDesc from Parts p where p.partsService.nsqKey ="+gsqNumber);

Here partsService is property of class or class name.

we have created PartsService Object in Parts class. And tried the above query.

The query generated by Hibernate.....

select p.partMasterKey , p.partMasterKeyDisplay ,p.partMasterKeyDesc from Parts p where p.partService.nsqKey=1024

But getting Exception

could not resolve property: partService of: Parts

My parts.hbm contents join as :

<join table ="ZGSQ_SERVICE_ITEMS_VW" >
<key column="PARTMSTR_KEY"></key>
</join>

Please let me what should we modify to get proper results.

In "p.partsService.nsqKey", partsService is property of class Parts. Kindly check spelling and case sensitivity.

In "p.partsService.nsqKey", partsService is property of class Parts. Look at the instance variable name of PartService in "Parts" class. use that variable name exactly in place of "partsService". e.g. if you have structure of you parts class as follows;
public class Parts{
private PartsService partsService;
// other code

}

then partsService should be used in query.

In "p.partsService.nsqKey", partsService is property of class Parts. Look at the instance variable name of PartService in "Parts" class. use that variable name exactly in place of "partsService". e.g. if you have structure of you parts class as follows;
public class Parts{
private PartsService partsService;
// other code

}

then partsService should be used in query.