Hibernate newbie - Data sequence

[Padma Priya]

Hi,

I have problem running this hibernate project for Data sequence.

I am providing the details below

I am using Eclipse.

I have created a table in Apache Derby as follows

connect 'jdbc:derby://localhost:1527/BookShopDB;create=true;
user=book;password=book';

CREATE TABLE BOOK
(ISBN VARCHAR(50) NOT NULL,
BOOK_NAME VARCHAR(100) NOT NULL,
PUBLISHER_CODE VARCHAR(4), PUBLISH_DATE DATE,
PRICE integer,
PRIMARY KEY (ISBN), FOREIGN KEY (PUBLISHER_CODE)
REFERENCES PUBLISHER (CODE)
);

My Java file is as follows

import java.util.*;

public class BookCh2 
{
	private String isbn;
	private String name;
	private Date publishDate;
	private int price;
	private Publisher publisher;
	//private List chapters;
	// getters and setters
	
	public String getIsbn() {
		return isbn;
	}
	
	public void setIsbn(String isbn) {
		this.isbn = isbn;
	}
	
	public String getName() {
		return name;
	}
	
	public void setName(String name) {
		this.name = name;
	}
	
	public Date getPublishDate() {
		return publishDate;
	}
	
	public void setPublishDate(Date publishDate) {
		this.publishDate = publishDate;
	}
	
	public int getPrice() {
		return price;
	}
	
	public void setPrice(int price) {
		this.price = price;
	}
	
	public Publisher getPublisher() {
		return publisher;
	}
	
	public void setPublisher(Publisher publisher) {
		this.publisher = publisher;
	}
	
	
}

My book.hbm.xml file is as follows(same directory as Bookch2)

<?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 auto-import="false">
       <class name="BookCh2" table="BOOK">
           <id column="ISBN" type="string">
                  <generator class="sequence">
                       <param name="sequence">BOOK_SEQUENCE</param>
                   </generator>
          </id>
          <property name="name" type="string" column="BOOK_NAME" />
          <property name="publishDate" type="date" column="PUBLISH_DATE" />
          <property name="price" type="int" column="PRICE" />
     </class>
</hibernate-mapping>[/b]

My hibernate.cfg.xml is as follows

<?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 auto-import="false">
<class name="BookCh2" table="BOOK">
<id column="ISBN" type="string">
[u]<generator class="sequence">
<param name="sequence">BOOK_SEQUENCE</param>
</generator>[/u]
</id>
<property name="name" type="string" column="BOOK_NAME" />
<property name="publishDate" type="date" column="PUBLISH_DATE" />
<property name="price" type="int" column="PRICE" />
</class>
</hibernate-mapping>

The client code is as follows

import java.util.Date;
//import java.util.List;
import org.hibernate.cfg.*;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
//import org.hibernate.cfg.Configuration;
import org.hibernate.stat.Statistics;

public class Launch_2_1 
{
	private static SessionFactory sessionFactory;
	public static Session getSession() 
	{
		if(sessionFactory == null)
		{
			sessionFactory = new AnnotationConfiguration().configure().buildSessionFactory();
		}
		Session hibernateSession = sessionFactory.openSession();
		return hibernateSession;
	}
	public static void main(String[] args) 
	{
		Session session = getSession();
		Statistics stats = sessionFactory.getStatistics();
		stats.setStatisticsEnabled(true);
		Transaction tx = session.beginTransaction();
		for(int i =0;i<3;i++)
		{
			BookCh2 book = new BookCh2();
			book.setName("Book Name "+(i+1));
			book.setPrice(39);
			book.setPublishDate(new Date());
			System.out.println("Book object persisting.........");
			session.save(book);
			System.out.println("Book object persisted to the database.");
		}
		tx.commit();
		stats.getSessionOpenCount();
		stats.logSummary();
		session.close();
	}
}

I am getting the following error when i run the Launch_2_1

12:41:32,093  INFO Version:15 - Hibernate Annotations 3.4.0.GA
12:41:32,109  INFO Environment:560 - Hibernate 3.3.2.GA
12:41:32,109  INFO Environment:593 - hibernate.properties not found
12:41:32,109  INFO Environment:771 - Bytecode provider name : javassist
12:41:32,125  INFO Environment:652 - using JDK 1.4 java.sql.Timestamp handling
12:41:32,218  INFO Version:14 - Hibernate Commons Annotations 3.1.0.GA
12:41:32,218  INFO Configuration:1474 - configuring from resource: /hibernate.cfg.xml
12:41:32,218  INFO Configuration:1451 - Configuration resource: /hibernate.cfg.xml
12:41:32,328  INFO Configuration:600 - Reading mappings from resource : book.hbm.xml
12:41:32,421  INFO Configuration:1589 - Configured SessionFactory: null
12:41:32,437  INFO HibernateSearchEventListenerRegister:53 - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
12:41:32,531  INFO HbmBinder:322 - Mapping class: BookCh2 -> BOOK
12:41:32,562  INFO AnnotationConfiguration:369 - Hibernate Validator not found: ignoring
12:41:32,625  INFO DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!)
12:41:32,640  INFO DriverManagerConnectionProvider:65 - Hibernate connection pool size: 20
12:41:32,640  INFO DriverManagerConnectionProvider:68 - autocommit mode: false
12:41:32,984  INFO DriverManagerConnectionProvider:103 - using driver: org.apache.derby.jdbc.EmbeddedDriver at URL: jdbc:derby://localhost:1527/BookShopDB
12:41:32,984  INFO DriverManagerConnectionProvider:109 - connection properties: {user=book, password=****}
12:41:33,359  INFO SettingsFactory:114 - RDBMS: Apache Derby, version: 10.6.1.0 - (938214)
12:41:33,359  INFO SettingsFactory:115 - JDBC driver: Apache Derby Network Client JDBC Driver, version: 10.6.1.0 - (938214)
12:41:33,390  INFO Dialect:175 - Using dialect: org.hibernate.dialect.DerbyDialect
12:41:33,468  INFO TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions)
12:41:33,468  INFO TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
12:41:33,468  INFO SettingsFactory:161 - Automatic flush during beforeCompletion(): disabled
12:41:33,468  INFO SettingsFactory:165 - Automatic session close at end of transaction: disabled
12:41:33,468  INFO SettingsFactory:180 - Scrollable result sets: enabled
12:41:33,468  INFO SettingsFactory:188 - JDBC3 getGeneratedKeys(): disabled
12:41:33,468  INFO SettingsFactory:196 - Connection release mode: auto
12:41:33,468  INFO SettingsFactory:223 - Default batch fetch size: 1
12:41:33,468  INFO SettingsFactory:227 - Generate SQL with comments: disabled
12:41:33,468  INFO SettingsFactory:231 - Order SQL updates by primary key: disabled
12:41:33,468  INFO SettingsFactory:235 - Order SQL inserts for batching: disabled
12:41:33,468  INFO SettingsFactory:397 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
12:41:33,468  INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
12:41:33,468  INFO SettingsFactory:243 - Query language substitutions: {}
12:41:33,468  INFO SettingsFactory:248 - JPA-QL strict compliance: disabled
12:41:33,468  INFO SettingsFactory:253 - Second-level cache: enabled
12:41:33,468  INFO SettingsFactory:257 - Query cache: disabled
12:41:33,468  INFO SettingsFactory:382 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
12:41:33,468  INFO SettingsFactory:267 - Optimize cache for minimal puts: disabled
12:41:33,468  INFO SettingsFactory:276 - Structured second-level cache entries: disabled
12:41:33,484  INFO SettingsFactory:305 - Statistics: disabled
12:41:33,484  INFO SettingsFactory:309 - Deleted entity synthetic identifier rollback: disabled
12:41:33,484  INFO SettingsFactory:324 - Default entity-mode: pojo
12:41:33,484  INFO SettingsFactory:328 - Named query checking : enabled
12:41:33,531  INFO SessionFactoryImpl:193 - building session factory
12:41:33,734  INFO SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
Book object persisting.........
12:41:33,812  WARN JDBCExceptionReporter:100 - SQL Error: -1, SQLState: 42X01
12:41:33,812 ERROR JDBCExceptionReporter:101 - Syntax error: Encountered "hibernate_sequence" at line 1, column 20.
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not get next sequence value
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:119)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:122)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
	at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)
	at Launch_2_1.main(Launch_2_1.java:36)
Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "hibernate_sequence" at line 1, column 20.
	at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
	at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:145)
	at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
	... 10 more
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered "hibernate_sequence" at line 1, column 20.
	at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
	at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
	at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
	at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
	at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
	at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
	at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
	at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
	at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
	at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
	at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
	... 14 more

Could anyone of you all please help me out with this code. What am i doing wrong.

[David Newton]

Please UseCodeTags when posting code or configuration. Unformatted code and configuration is unnecessarily difficult to read. You can edit your post by using the button.

[Charan kumar sarvepalli]

Derby does not support sequences like Oracle, but it supports identity columns.

check this is thread http://www.coderanch.com/t/418835/java-EJB-SCBCD/certification/Apache-Derby-Sql