-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
 Post subject: Where to put ehcache.xml and are there any other config ?
PostPosted: Mon Oct 31, 2005 2:12 am 
Newbie

Joined: Thu Oct 20, 2005 7:48 am
Posts: 19
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....


Top
 Profile  
 
 Post subject: where to specify the ehcache.xml?
PostPosted: Mon Oct 31, 2005 2:36 am 
Newbie

Joined: Thu Jun 23, 2005 9:23 pm
Posts: 13
i am facing the same question too.
where to specify the ehcache.xml file?


Top
 Profile  
 
 Post subject: Re: where to specify the ehcache.xml?
PostPosted: Mon Oct 31, 2005 3:04 am 
Newbie

Joined: Thu Oct 20, 2005 7:48 am
Posts: 19
i have done the job...
just place the ehcache.xml in root directory..
and set 2L cache in hibernate.properties...

u do the same..


Top
 Profile  
 
 Post subject: Re: where to specify the ehcache.xml?
PostPosted: Mon Oct 31, 2005 3:04 am 
Newbie

Joined: Thu Oct 20, 2005 7:48 am
Posts: 19
i have done the job...
just place the ehcache.xml in root directory..
and set 2L cache in hibernate.properties...

u do the same..


Top
 Profile  
 
 Post subject: the console couldnt show the sql.
PostPosted: Mon Oct 31, 2005 4:06 am 
Newbie

Joined: Thu Jun 23, 2005 9:23 pm
Posts: 13
Hi,i have done the job too.
now ,i am using the second cache.but the console couldnt show the sql.in spite of the config has set the value true to the property of "hibernate.show_sql ".why?


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.