This query works outside my tomcat container:

list = session.createQuery("from Zipcode").setString("zip", zipcode).list();

This one does not:

List results = session.createCriteria(Zipcode.class).list();

Any ideas why a criteriaQuery would not? It doesn't show any generated sql either.


Hibernate version:

3

Code between sessionFactory.openSession() and session.close():

Name and version of the database you are using:

mysql 5

Can you post your mapping document?

<hibernate-mapping>
<class name="Zipcode" table="zipcode" mutable="false" lazy="false">
<id name="zip" column="zip"/>
<property name="city" column="city"/>
<property name="state" column="state"/>
<property name="stateCode" column="state_code"/>
<property name="areaCode" column="area_code"/>
<property name="type" column="type"/>
<property name="cityType" column="city_type"/>
<property name="lat" column="latitude"/>
<property name="lon" column="longitude"/>
</class>
</hibernate-mapping>