I have use ehcache...
but i dont find any improvement... with compare to normal ejb application which is doing same procedure which i have implemented in Hibernate application..
my log is as follow..
Oct 31 11:38:06 2005: [Thread-36] [ALL] Initiate SessionFactory
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Mapping resource: customercontroller/dto/CustomerTO.hbm.xml
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Mapping class: customercontroller.dto.CustomerTO -> customer
Oct 31 11:38:06 2005: [Thread-36] [ALL] - processing extends queue
Oct 31 11:38:06 2005: [Thread-36] [ALL] - processing collection mappings
Oct 31 11:38:06 2005: [Thread-36] [ALL] - processing association property references
Oct 31 11:38:06 2005: [Thread-36] [ALL] - processing foreign key constraints
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Using Hibernate built-in connection pool (not for production use!)
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Hibernate connection pool size: 1
Oct 31 11:38:06 2005: [Thread-36] [ALL] - autocommit mode: false
Oct 31 11:38:06 2005: [Thread-36] [ALL] - using driver: com.sybase.jdbc2.jdbc.SybDriver at URL: jdbc:sybase:Tds:sipl48:5000/dylt2000
Oct 31 11:38:06 2005: [Thread-36] [ALL] - connection properties: {user=jpanchal, password=****}
Oct 31 11:38:06 2005: [Thread-36] [ALL] - RDBMS: Adaptive Server Enterprise, version: Adaptive Server Enterprise/12.5/SWR 9616 GA/P/NT (IX86)/OS 4.0/main/1647/32-bit/OPT/Fri Jun 01 16:58:25 2001
Oct 31 11:38:06 2005: [Thread-36] [ALL] - JDBC driver: jConnect (TM) for JDBC (TM), version: jConnect (TM) for JDBC(TM)/5.5(Build 25159)/P/EBF10636/JDK12/Thu Sep 5 16:01:31 2002
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Using dialect: org.hibernate.dialect.SybaseDialect
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Using default transaction strategy (direct JDBC transactions)
Oct 31 11:38:06 2005: [Thread-36] [ALL] - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Automatic flush during beforeCompletion(): disabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Automatic session close at end of transaction: disabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Scrollable result sets: enabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - JDBC3 getGeneratedKeys(): disabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Connection release mode: null
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Maximum outer join fetch depth: 1
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Default batch fetch size: 1
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Generate SQL with comments: disabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Order SQL updates by primary key: disabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Query translator: org.hibernate.hql.classic.ClassicQueryTranslatorFactory
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Query language substitutions: {no='N', true=1, yes='Y', false=0}
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Second-level cache: enabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Query cache: enabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Cache provider: org.hibernate.cache.EhCacheProvider
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Optimize cache for minimal puts: enabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Cache region prefix: hibernate.test
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Structured second-level cache entries: enabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Echoing all SQL to stdout
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Statistics: disabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Deleted entity synthetic identifier rollback: disabled
Oct 31 11:38:06 2005: [Thread-36] [ALL] - Default entity-mode: pojo
Oct 31 11:38:06 2005: [Thread-36] [ALL] - building session factory
Oct 31 11:38:06 2005: [Thread-36] [ALL] - read-only cache configured for mutable class: hibernate.test.customercontroller.dto.CustomerTO
Oct 31 11:38:07 2005: [Thread-36] [ALL] - Not binding factory to JNDI, no JNDI name configured
Oct 31 11:38:07 2005: [Thread-36] [ALL] - Using dialect: org.hibernate.dialect.SybaseDialect
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing extends queue
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing collection mappings
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing association property references
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing foreign key constraints
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing extends queue
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing collection mappings
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing association property references
Oct 31 11:38:07 2005: [Thread-36] [ALL] - processing foreign key constraints
Oct 31 11:38:07 2005: [Thread-36] [ALL] - Running hbm2ddl schema export
Oct 31 11:38:07 2005: [Thread-36] [ALL] - exporting generated schema to database
Oct 31 11:38:07 2005: [Thread-36] [ALL] - Using Hibernate built-in connection pool (not for production use!)
Oct 31 11:38:07 2005: [Thread-36] [ALL] - Hibernate connection pool size: 1
Oct 31 11:38:07 2005: [Thread-36] [ALL] - autocommit mode: false
Oct 31 11:38:07 2005: [Thread-36] [ALL] - using driver: com.sybase.jdbc2.jdbc.SybDriver at URL: jdbc:sybase:Tds:sipl48:5000/dylt2000
Oct 31 11:38:07 2005: [Thread-36] [ALL] - connection properties: {user=jpanchal, password=****}
Oct 31 11:38:07 2005: [Thread-36] [ALL] - Unsuccessful: create table customer (customerNumber varchar(255) not null, customerName varchar(255) null, creditRatingId int null, creditHold int null, ABCRatingId int null, federalTaxId varchar(255) null, stateTaxId varchar(255) null, accountTypeId int null, DandBRatingId int null, creditLimit double precision null, creditTermsId int null, URL varchar(255) null, SICCode varchar(255) null, invoiceAttach int null, statusId int null, preferedBilling int null, preferredRatingId int null, manualRating int null, startDate datetime null, stopDate datetime null, addDate datetime null, changeDate datetime null, addOpId varchar(255) null, changeOpId varchar(255) null, tenderFlag int null, guaranteePayment int null, noPickup int null, distMethod int null, primary key (customerNumber))
Oct 31 11:38:07 2005: [Thread-36] [ALL] - There is already an object named 'customer' in the database.
Oct 31 11:38:07 2005: [Thread-36] [ALL] - schema export complete
Oct 31 11:38:07 2005: [Thread-36] [ALL] - cleaning up connection pool: jdbc:sybase:Tds:sipl48:5000/dylt2000
Oct 31 11:38:07 2005: [Thread-36] [ALL] - starting update timestamps cache at region: hibernate.test.org.hibernate.cache.UpdateTimestampsCache
Oct 31 11:38:07 2005: [Thread-36] [ALL] - starting query cache at region: hibernate.test.org.hibernate.cache.StandardQueryCache
Oct 31 11:38:07 2005: [Thread-36] [ALL] - Checking 0 named queries
Oct 31 11:38:07 2005: [Thread-36] [ALL] Viewing all Customer info
Oct 31 11:38:07 2005: [Thread-36] [ALL] before beginning transaction
Oct 31 11:38:07 2005: [Thread-36] [ALL] before querycreate
Oct 31 11:38:07 2005: [Thread-36] [ALL]
Oct 31 11:38:07 2005: [Thread-36] [ALL] - starting query cache at region: hibernate.test.query.viewCustomer
Oct 31 11:38:07 2005: [Thread-36] [ALL] Hibernate: select customerto0_.customerNumber as col_0_0_, customerto0_.customerName as col_1_0_, customerto0_.creditRatingId as col_2_0_, customerto0_.creditHold as col_3_0_ from customer customerto0_ where (customerto0_.customerName like 'ABC%' )
So please help to improve efficiency....
|