一百分求解，初写的一个HIBERNATE问题
总是错误提示
net.sf.hibernate.QueryException: undefined alias: id [select id from meis.hibern
ate.BULLETIN as BULLETIN ]

代码
代码
SessionFactory sf = new Configuration().configure().buildSessionFactory();
//打开一个Session
Session session = sf.openSession();
//开始一个事务
Transaction tx = session.beginTransaction();

Query query=session.createQuery("select id from BULLETIN as BULLETIN ");

query.list();



映射类
package meis.hibernate;

public class BULLETIN
{
//发布日期

private String id;

private String issuedate;
private String title;

public String getId()
{
return id;
}
public void setId(String id)
{
this.id = id;
}

public String getIssuedate()
{
return issuedate;
}
public void setIssuedate(String issuedate)
{
this.issuedate = issuedate;
}

public String getTitle()
{
return title;
}
public void setTitle(String title)
{
this.title = title;
}

}


配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="meis.hibernate.BULLETIN" table="BULLETIN">
<id name="id">
<generator class="assigned" />
</id>
<property name="issuedate" />
<property name="title" />
</class>

</hibernate-mapping>


[解决办法]
Query query=session.createQuery("select id from BULLETIN");

不用as，否则的话，必须是：
select BULLETIN.id from BULLETIN as BULLETIN
[解决办法]
select id from BULLETIN as BULLETIN
改为:
select BULLETIN.id from BULLETIN as BULLETIN
最好不要用与类相同的别名，
建议改成以下的方式：
select bull.id from BULLETIN as bull
[解决办法]
好像你语句都已经正常了，还报错，奇怪

试一试
Query query=session.createQuery("select bull　from Bulletin as bull");
[解决办法]
Query query=session.createQuery("from Bulletin ");

但我只想取几个字段啊，不想全取啊

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

select b.id from meis.hibernate.BULLETIN b

试试完整的类名~~~~
[解决办法]
select b.id from meis.hibernate.BULLETIN b