2007 - 05 - 29   16 : 03 : 42 , 531  ERROR [org.hibernate.util.JDBCExceptionReporter] - ERROR: column personal0_.cathegoryid does not exist
org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java: 67 )
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java: 43 )
	at org.hibernate.loader.Loader.doList(Loader.java: 2148 )
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java: 2029 )
	at org.hibernate.loader.Loader.list(Loader.java: 2024 )
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java: 375 )
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: 308 )
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java: 153 )
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java: 1106 )
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java: 79 )
	at kz.kbtu.dit.model.PersonalManager.getPersonal(PersonalManager.java: 56 )
	at kz.kbtu.dit.MainWindow.getData(MainWindow.java: 112 )
	at kz.kbtu.dit.MainWindow.open(MainWindow.java: 87 )
	at kz.kbtu.dit.MainWindow.main(MainWindow.java: 72 )
Caused by: org.postgresql.util.PSQLException: ERROR: column personal0_.cathegoryid does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java: 1548 )
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: 1316 )
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 191 )
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java: 452 )
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java: 351 )
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java: 255 )
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java: 76 )
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: 139 )
	at org.hibernate.loader.Loader.getResultSet(Loader.java: 1669 )
	at org.hibernate.loader.Loader.doQuery(Loader.java: 662 )
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java: 224 )
	at org.hibernate.loader.Loader.doList(Loader.java: 2145 )
	...  11  more

 public  List getPersonal() {
		List personal =  null ;
		Session session = HibernateUtil.getCurrentSession();
		Transaction transaction = session.beginTransaction();
		 try  {
			personal = ( List ) session.createQuery(
					"FROM Personal").list();
			transaction.commit();
		}  catch  ( HibernateException ex ) {
			 throw  ex;
		}
		 return  personal;
	}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping  PUBLIC  "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping schema="public"  package ="kz.kbtu.dit.model"> 
  < class  name="Personal" table="personal" optimistic-lock="none"> 
    <id name="id" type="long" unsaved-value="null">
      <column name="id" not- null ="true" unique="true"/>
      <generator  class ="native"/>
    </id>
    <property name="name" type="string" column="name" length="30" not- null ="true"/>
    <property name="surname" type="string" column="surname" length="50" not- null ="true"/>
    <property name="email" type="string" column="email" length="70" not- null ="true"/>
    <property name="phone" type="string" column="phone" length="25" not- null ="true"/>
    <property name="mobilePhone" type="string" column="mobile_phone" length="15" not- null ="true"/>
    <many-to-one name="cathegoryId" entity-name="kz.kbtu.dit.model.Cathegory" cascade="none" foreign-key="dit_personal_fk" column="cathegoryId" not- null ="false"/>
    <many-to-one name="postId" entity-name="kz.kbtu.dit.model.Post" cascade="none" foreign-key="dit_personal_fk2" column="postId" not- null ="false"/>
    <many-to-one name="departmentId" entity-name="kz.kbtu.dit.model.Department" cascade="none" foreign-key="dit_personal_fk1" column="departmentId" not- null ="false"/>
    <bag name="container" inverse="true" cascade="none"> 
      <key foreign-key="dit_container_fk1" column="personalId"/>
      <one-to-many entity-name="kz.kbtu.dit.model.Container"/>
    </bag>
  </ class >
</hibernate-mapping>

CREATE TABLE "public"."personal" (
  "id" BIGINT NOT  NULL , 
  "name" VARCHAR( 30 ) NOT  NULL , 
  "surname" VARCHAR( 50 ) NOT  NULL , 
  "email" VARCHAR( 70 ) NOT  NULL , 
  "phone" VARCHAR( 25 ) NOT  NULL , 
  "mobile_phone" VARCHAR( 15 ) NOT  NULL , 
  "cathegoryId" SMALLINT NOT  NULL , 
  "departmentId" SMALLINT NOT  NULL , 
  "postId" SMALLINT NOT  NULL , 
  CONSTRAINT "dit_personal_pkey" PRIMARY KEY("id"), 
  CONSTRAINT "dit_personal_fk" FOREIGN KEY ("cathegoryId")
    REFERENCES "public"."cathegory"("id")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "dit_personal_fk1" FOREIGN KEY ("departmentId")
    REFERENCES "public"."department"("id")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "dit_personal_fk2" FOREIGN KEY ("postId")
    REFERENCES "public"."post"("id")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITH OIDS;

Hibernate: select personal0_.id as id6_, personal0_.name as name6_, personal0_.surname as surname6_, personal0_.email as email6_, personal0_.phone as phone6_, personal0_.mobile_phone as mobile6_6_, personal0_.cathegoryId as cathegor7_6_, personal0_.postId as postId6_, personal0_.departmentId as departme9_6_ from  public .personal personal0_
 2007 - 05 - 29   17 : 55 : 49 , 375  WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error:  0 , SQLState:  42703 
 2007 - 05 - 29   17 : 55 : 49 , 375  ERROR [org.hibernate.util.JDBCExceptionReporter] - ERROR: column personal0_.cathegoryid does not exist