Problem with Hql Update

[Sujoy Mukherjee]

hi,
I am very new to hibernate. I am trying my hands on HQL. I am trying Updating a table but facing a problem. I will try to explain it in as much detail I can.
First of all I am using netbeans 7.2, Oracle 10G express edition.

(1)The Table called book and its like this:

create table book
(
bookid varchar2(10) primary key,
bookname varchar2(50),
bookprice number(5)
)

(2)hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
    <property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
    <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
    <property name="hibernate.connection.username">hr</property>
    <property name="hibernate.connection.password">hr</property>
    <property name="hibernate.show_sql">true</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <property name="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</property>
    <property name="hibernate.hbm2ddl.auto">update</property>
    <mapping resource="code/Book.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

(3)hibernate.reveng.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd">
<hibernate-reverse-engineering>
  <schema-selection match-schema="HR"/>
  <table-filter match-name="BOOK"/>
</hibernate-reverse-engineering>

(4)book.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jan 21, 2013 10:01:49 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="code.Book" table="BOOK" schema="HR">
        <id name="bookid" type="string">
            <column name="BOOKID" length="10" />
            <generator class="assigned" />
        </id>
        <property name="bookname" type="string">
            <column name="BOOKNAME" length="50" />
        </property>
        <property name="bookprice" type="java.lang.Integer">
            <column name="BOOKPRICE" precision="5" scale="0" />
        </property>
    </class>
</hibernate-mapping>

(5)The POJO class, book.java

package code;
// Generated Jan 21, 2013 10:01:48 PM by Hibernate Tools 3.2.1.GA



/**
 * Book generated by hbm2java
 */
public class Book  implements java.io.Serializable {


     private String bookid;
     private String bookname;
     private Integer bookprice;

    public Book() {
    }

	
    public Book(String bookid) {
        this.bookid = bookid;
    }
    public Book(String bookid, String bookname, Integer bookprice) {
       this.bookid = bookid;
       this.bookname = bookname;
       this.bookprice = bookprice;
    }
   
    public String getBookid() {
        return this.bookid;
    }
    
    public void setBookid(String bookid) {
        this.bookid = bookid;
    }
    public String getBookname() {
        return this.bookname;
    }
    
    public void setBookname(String bookname) {
        this.bookname = bookname;
    }
    public Integer getBookprice() {
        return this.bookprice;
    }
    
    public void setBookprice(Integer bookprice) {
        this.bookprice = bookprice;
    }

@Override
    public String toString() {
        return "Book {" + "bookId= " + bookid + " "+"bookName= " + bookname + " "+"bookPrice=" + bookprice + " "+'}';
    }

   

}

(6)And finally, HQLUpdate.java, where the problem occurs

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package code;

import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import util.NewHibernateUtil;
/**
 *
 * @author Sujoy
 */
public class HQLUpdate {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
         Transaction tx = null;
        Book b = new Book();
         SessionFactory sf = NewHibernateUtil.getSessionFactory();
        Session s=sf.openSession();
        tx = s.beginTransaction();
        String hql = "update book set bookname :bname where bookid :bid";
        Query query = s.createQuery(hql);
        query.setParameter("bname", "The C Programming Language");
query.setParameter("bid", "");
int result = query.executeUpdate();
        System.out.println("Rows affected: "+result);
        /*List results = query.list();
        System.out.println("Results: "+results);*/
    }
}

[Sujoy Mukherjee]

When I am executing HQLUpdate.java, the following Exception message comes:
Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: expecting EQ, found ':' near line 1, column 26 [update book set bookname :bname where bookid :bid]

The full output looks like this:

run:
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.3.1.GA
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : code/Book.hbm.xml
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: code.Book -> BOOK
Jan 21, 2013 11:51:47 PM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Jan 21, 2013 11:51:47 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
Jan 21, 2013 11:51:47 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
Jan 21, 2013 11:51:47 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
Jan 21, 2013 11:51:48 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:XE
Jan 21, 2013 11:51:48 PM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=hr, password=****}
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: Oracle JDBC driver, version: 11.2.0.3.0
Jan 21, 2013 11:51:48 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.OracleDialect
Jan 21, 2013 11:51:48 PM org.hibernate.dialect.Oracle9Dialect <init>
WARNING: The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
Jan 21, 2013 11:51:48 PM org.hibernate.dialect.OracleDialect <init>
WARNING: The OracleDialect dialect has been deprecated; use Oracle8iDialect instead
Jan 21, 2013 11:51:48 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
Jan 21, 2013 11:51:48 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
Jan 21, 2013 11:51:48 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
Jan 21, 2013 11:51:48 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
Jan 21, 2013 11:51:48 PM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Jan 21, 2013 11:51:48 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: Running hbm2ddl schema update
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: fetching database metadata
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: updating schema
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: table found: HR.BOOK
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: columns: [bookid, bookname, bookprice]
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: foreign keys: []
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: indexes: [sys_c004063]
Jan 21, 2013 11:51:48 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: schema update complete
Jan 21, 2013 11:51:48 PM org.hibernate.hql.ast.ErrorCounter reportError
SEVERE: line 1:26: expecting EQ, found ':'
Jan 21, 2013 11:51:48 PM org.hibernate.hql.ast.ErrorCounter reportError
SEVERE: line 1:46: unexpected token: :
Jan 21, 2013 11:51:48 PM org.hibernate.hql.ast.HqlParser processEqualityExpression
WARNING: processEqualityExpression() : No expression to process!
Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: expecting EQ, found ':' near line 1, column 26 [update book set bookname :bname where bookid :bid]
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
	at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
	at code.HQLUpdate.main(HQLUpdate.java:29)
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)

Can you please tell me where is the problem?
Thanks in advance.

[Salil Vverma]

The problem is with HQL you are using. You are using below query -

update book set bookname :bname where bookid :bid

while it should be as mentioned below (= operator is missing in your query) -

update book set bookname = :bname where bookid :bid

Kindly try it and let us know if you are still facing any issues

[Emanuel Kadziela]

I think the last post is still missing a "=", try this ...

update book set bookname = :bname where bookid = :bid

[Salil Vverma]

Hey Emanuel,

Good catch..
The correct hql would be -

update book set bookname = :bname where bookid = :bid  

[Sujoy Mukherjee]

Extremely sorry for replying so late. Thanks to both Salil and Emanuel for replying.
I tried your solution....but an exception is thrown now.
it is saying....Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: book is not mapped [update book set bookname =:bname where bookid =:bid]
The run window says

run:
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.3.1.GA
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : p1/Book.hbm.xml
Mar 05, 2013 11:34:45 AM org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: p1.Book -> BOOK
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Mar 05, 2013 11:34:46 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
Mar 05, 2013 11:34:46 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
Mar 05, 2013 11:34:46 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
Mar 05, 2013 11:34:46 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@192.168.50.154:1521:orcl
Mar 05, 2013 11:34:46 AM org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=hr, password=****}
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0
Mar 05, 2013 11:34:46 AM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.OracleDialect
Mar 05, 2013 11:34:46 AM org.hibernate.dialect.Oracle9Dialect <init>
WARNING: The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
Mar 05, 2013 11:34:46 AM org.hibernate.dialect.OracleDialect <init>
WARNING: The OracleDialect dialect has been deprecated; use Oracle8iDialect instead
Mar 05, 2013 11:34:46 AM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
Mar 05, 2013 11:34:46 AM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
Mar 05, 2013 11:34:46 AM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
Mar 05, 2013 11:34:46 AM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
Mar 05, 2013 11:34:46 AM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Mar 05, 2013 11:34:47 AM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: book is not mapped [update book set bookname =:bname where bookid =:bid]
	at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
	at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
	at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
	at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.updateStatement(HqlSqlBaseWalker.java:345)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:237)
	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
	at p1.Hq.main(Hq.java:28)
Java Result: 1
BUILD SUCCESSFUL (total time: 6 seconds)

[Sujoy Mukherjee]

Correction. it has been solved. i was using the table name instead of class name.
Thanks for your help.

[Gerald Vormbrock]

In the hbm you wrote name="code.Book", it is the name to use.
You should set name="book" and it should work.