Changes in version 2.1.2 (4.2.2004)
* queries with "select new" now cacheable
===============================
my code:
----------------------------------------
Query query=ss.createQuery(
select new ClassName({tableName}.x}) from TableName as {tableName} where ...
);

my code break on

Iterator iter = query.list().iterator();

error message is about something wrong on sql server...........


================================
what's wrong with my code using "select new ClassName(...

/**
* Demonstrates HQL projection/aggregation
*/
public void viewAllAuctionsFast() throws Exception {
System.out.println("Viewing all auction item info");

Session s = factory.openSession();
Transaction tx=null;
try {
tx = s.beginTransaction();

List auctions = s.createQuery(
"select new AuctionInfo( item.id, item.description, item.ends, max(bid.amount) ) "
+ "from AuctionItem item "
+ "left join item.bids bid "
+ "group by item.id, item.description, item.ends "
+ "order by item.ends desc"
)
.setMaxResults(100)
.list();

Iterator iter = auctions.iterator();
while ( iter.hasNext() ) {
AuctionInfo ai = (AuctionInfo) iter.next();
System.out.println(
"Auction: " + ai.getId() + " - " + ai.getDescription() +
", ends: " + ai.getEnds() +
", highest bid: " + ai.getMaxAmount()
);
}
System.out.println();

tx.commit();
}
catch (Exception e) {
if (tx!=null) tx.rollback();
throw e;
}
finally {
s.close();
}
}

This {tableName}.x} stuff is surely not a legal HQL query. What is the error message besides, and take a look at the generate SQL.

System.out.println ("11111111111111");
Query query2 = session.createQuery("select {wsHdzsSp}.spjgDm from WsHdzsSp as {wsHdzsSp} where {wsHdzsSp}.nsrsbh=:nsrsbh and {wsHdzsSp}.wspzxh=:wspzxh" );
query2.setString("nsrsbh", nsrsbh);
query2.setString("wspzxh", wspzxh);
Iterator iter2 = query2.list().iterator();
System.out.print("2222222222");
while (iter2.hasNext()) {
VTest row = (VTest) iter2.next();
System.out.println(row.getSpjgDm());
}
System.out.println ("success...........");

============================================
11111111111111
08:47:21,676 WARN JDBCExceptionReporter:20 - SQL Warning: 0, SQLState:
08:47:21,676 WARN JDBCExceptionReporter:28 - [Microsoft][SQLServer 2000 Driver
for JDBC]Database changed to ctais_oracle
08:47:21,676 WARN JDBCExceptionReporter:20 - SQL Warning: 0, SQLState:
08:47:21,676 WARN JDBCExceptionReporter:28 - [Microsoft][SQLServer 2000 Driver
for JDBC][SQLServer]已将数据库上下文改为 'ctais_oracle'。
08:47:21,686 WARN JDBCExceptionReporter:20 - SQL Warning: 0, SQLState:
08:47:21,686 WARN JDBCExceptionReporter:28 - [Microsoft][SQLServer 2000 Driver
for JDBC]Language changed to 简体中文
08:47:21,696 WARN JDBCExceptionReporter:20 - SQL Warning: 0, SQLState:
08:47:21,696 WARN JDBCExceptionReporter:28 - [Microsoft][SQLServer 2000 Driver
for JDBC][SQLServer]已将语言设置改为 简体中文。

What the hell is all this {foo} stuff?? That is not HQL. Please read the Hibernate documentation.

queries with "select new" now cacheable
---------- it can't using in more than one table?

====================================

i want do :
Query query = ss.createQuery("select new SectionalFields(a.x,b.y) from A a, B b");

============================

problem 1:

For using Class "SectionalFields", we must write codes "<import class="SectionalFields"/>" in *.hbm.xml

if i only do "select new SectionalField2(a.x) from A a", it has no problem.
but i want select fields from more than 1 table.
so i write "<import class="SectionalFields"/>" in A.hbm.xml and B.hbm.xml

error: duplicable import class SectionalFields

==========

problem 2:

because of problem 1, i only write "<import class="SectionalFields"/>"
in A.hbm.xml or B.hbm.xml
but it can's pass!!!!

==================================
what's the problem? for queries with "select new" can't using in more than 1 table? Or i've done some wrong??