I am not generally one to ask for help, but after reading all the appropriate documentation (both Hiberante and EHCache) and searching through the forums I am out of ideas for my caching problem. I have a five object caching set up and am trying to use second level-caching writing to disk. Using the configuration files I have below when I run my test client the appropriate cache data files are written to as I expect. The second time and all following times when I run the same query I still see the SQL being generated and my database is still being hit. I know this because if I shutdown mySQL the query fails. So my question is what might cause my system configuration to write to my cache, but ignore it on subsequent queries? Any ideas would be greatly appreciated.

Hibernate version:

Hibernate 3.0

Mapping documents:
hibernate.porperties:

######################
### Query Language ###
######################

## define query language constants / function names

hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'



#################
### Platforms ###
#################


## MySQL

hibernate.dialect org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql://localhost/cacore
hibernate.connection.username cabiouser
hibernate.connection.password cabio



#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1



###########################
### C3P0 Connection Pool###
###########################

#hibernate.c3p0.max_size 2
#hibernate.c3p0.min_size 2
#hibernate.c3p0.timeout 5000
#hibernate.c3p0.max_statements 100
#hibernate.c3p0.idle_test_period 3000
#hibernate.c3p0.acquire_increment 2
#hibernate.c3p0.validate false



##############################
### Proxool Connection Pool###
##############################

## Properties for external configuration of Proxool

hibernate.proxool.pool_alias pool1

## Only need one of the following

#hibernate.proxool.existing_pool true
#hibernate.proxool.xml proxool.xml
#hibernate.proxool.properties proxool.properties



#################################
### Plugin ConnectionProvider ###
#################################

## use a custom ConnectionProvider (if not set, Hibernate will choose a built-in ConnectionProvider using hueristics)

#hibernate.connection.provider_class org.hibernate.connection.DriverManagerConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.DatasourceConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.C3P0ConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.DBCPConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.ProxoolConnectionProvider



#######################
### Transaction API ###
#######################

## the Transaction API abstracts application code from the underlying JTA or JDBC transactions

#hibernate.transaction.factory_class org.hibernate.transaction.JTATransactionFactory
#hibernate.transaction.factory_class org.hibernate.transaction.JDBCTransactionFactory


## to use JTATransactionFactory, Hibernate must be able to locate the UserTransaction in JNDI
## default is java:comp/UserTransaction
## you do NOT need this setting if you specify hibernate.transaction.manager_lookup_class

#jta.UserTransaction jta/usertransaction
#jta.UserTransaction javax.transaction.UserTransaction
#jta.UserTransaction UserTransaction


## to use the second-level cache with JTA, Hibernate must be able to obtain the JTA TransactionManager

#hibernate.transaction.manager_lookup_class org.hibernate.transaction.JBossTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WeblogicTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WebSphereTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.OrionTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.ResinTransactionManagerLookup



##############################
### Miscellaneous Settings ###
##############################

## print all generated SQL to the console

hibernate.show_sql true


## add comments to the generated SQL

#hibernate.use_sql_comments true


## generate statistics

#hibernate.generate_statistics true


## auto schema export

#hibernate.hbm2ddl.auto create-drop
#hibernate.hbm2ddl.auto create
#hibernate.hbm2ddl.auto update


## rollback generated identifier values of deleted entities to default values

#hibernate.use_identifer_rollback true


## specify a default schema and catalog for unqualified tablenames

#hibernate.default_schema test
#hibernate.default_catalog test


## set the maximum depth of the outer join fetch tree

hibernate.max_fetch_depth 1


## enable CGLIB reflection optimizer (enabled by default)

hibernate.cglib.use_reflection_optimizer false


## use a custom stylesheet for XML generation (if not specified, hibernate-default.xslt will be used)

#hibernate.xml.output_stylesheet C:/Hibernate/net/sf/hibernate/hibernate-default.xslt



#####################
### JDBC Settings ###
#####################

## specify a JDBC isolation level

#hibernate.connection.isolation 4


## enable JDBC autocommit (not recommended!)

#hibernate.connection.autocommit true


## set the JDBC fetch size

#hibernate.jdbc.fetch_size 25


## set the maximum JDBC 2 batch size (a nonzero value enables batching)

#hibernate.jdbc.batch_size 5


## enable batch updates even for versioned data

hibernate.jdbc.batch_versioned_data true


## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default)

#hibernate.jdbc.use_scrollable_resultset true


## use streams when writing binary types to / from JDBC

hibernate.jdbc.use_streams_for_binary true


## use JDBC 3 PreparedStatement.getGeneratedKeys() to get the identifier of an inserted row

#hibernate.jdbc.use_get_generated_keys false



##########################
### Second-level Cache ###
##########################

hibernate.cache.use_second_level_cache true
hibernate.cache.use_query_cache false

hibernate.cache.provider_class org.hibernate.cache.EhCacheProvider
###############################################


ehcache.xml :

<ehcache>
<diskStore path="C:/tomcat/webapps/cacore301/WEB-INF/cache"/>
<defaultCache
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/><cache name="gov.nih.nci.cabio.domain.impl.GeneImpl"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.GeneImpl.libraryCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.GeneImpl.sequenceCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.GeneImpl.targetCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.ChromosomeImpl"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.ChromosomeImpl.geneCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.TaxonImpl"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.TaxonImpl.geneCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.TaxonImpl.chromosomeCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.LibraryImpl"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.LibraryImpl.cloneCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.LibraryImpl.geneCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.CloneImpl"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.CloneImpl.sequenceCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.SequenceImpl"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.SequenceImpl.geneCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.TargetImpl"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
<cache name="gov.nih.nci.cabio.domain.impl.TargetImpl.geneCollection"
maxElementsInMemory="2"
eternal="false"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
overflowToDisk="true"
/>
</ehcache>

hibernate.cfg.xml file:

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

<hibernate-configuration>
<session-factory>
<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>

<mapping resource="gov/nih/nci/cabio/domain/impl/GeneImpl.hbm.xml" />
<mapping resource="gov/nih/nci/cabio/domain/impl/ChromosomeImpl.hbm.xml" />
<mapping resource="gov/nih/nci/cabio/domain/impl/TaxonImpl.hbm.xml" />
<mapping resource="gov/nih/nci/cabio/domain/impl/LibraryImpl.hbm.xml" />
<mapping resource="gov/nih/nci/cabio/domain/impl/CloneImpl.hbm.xml" />
<mapping resource="gov/nih/nci/cabio/domain/impl/SequenceImpl.hbm.xml" />
<mapping resource="gov/nih/nci/cabio/domain/impl/TargetImpl.hbm.xml" />
</session-factory>
</hibernate-configuration>

domain object mapping files:

Gene object:

<?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 package="gov.nih.nci.cabio.domain.impl">
<class name="GeneImpl" table="GENE" mutable="false">
<cache usage="read-only" />
<id name="id" type="java.lang.Long" column="GENE_ID">
<generator class="assigned" />
</id>
<property name="title" type="java.lang.String" column="GENE_TITLE" />
<property name="symbol" type="java.lang.String" column="GENE_SYMBOL" />
<property name="locusLinkSummary" type="java.lang.String" column="LOCUS_LINK_SUMMARY" />
<property name="OMIMID" type="java.lang.String" column="OMIM_ID" />
<property name="locusLinkId" type="java.lang.String" column="LOCUS_LINK_ID" />
<property name="clusterId" type="java.lang.Long" column="CLUSTER_ID" />
<set name="libraryCollection" table="LIBRARY_GENE" lazy="true">
<cache usage="read-only" />
<key column="GENE_ID" />
<many-to-many class="gov.nih.nci.cabio.domain.impl.LibraryImpl" column="LIBRARY_ID" />
</set>
<many-to-one name="chromosome" class="gov.nih.nci.cabio.domain.impl.ChromosomeImpl" column="CHROMOSOME_ID" lazy="true" />
<many-to-one name="taxon" class="gov.nih.nci.cabio.domain.impl.TaxonImpl" column="TAXON_ID" lazy="true" />
<set name="sequenceCollection" table="GENE_SEQUENCE" lazy="true">
<cache usage="read-only" />
<key column="GENE_ID" />
<many-to-many class="gov.nih.nci.cabio.domain.impl.SequenceImpl" column="SEQUENCE_ID" />
</set>
<set name="targetCollection" table="GENE_TARGET" lazy="true">
<cache usage="read-only" />
<key column="GENE_ID" />
<many-to-many class="gov.nih.nci.cabio.domain.impl.TargetImpl" column="TARGET_ID" />
</set>
</class>
</hibernate-mapping>

Sequence Object:

<?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 package="gov.nih.nci.cabio.domain.impl">
<class name="SequenceImpl" table="SEQUENCE" mutable="false">
<cache usage="read-only" />
<id name="id" type="java.lang.Long" column="SEQUENCE_ID">
<generator class="assigned" />
</id>
<property name="length" type="java.lang.Long" column="LENGTH" />
<property name="isReferenceSequence" type="java.lang.Boolean" column="IS_REF_SEQUENCE" />
<property name="description" type="java.lang.String" column="DESCRIPTION" />
<property name="asciiString" type="java.lang.String" column="ASCII_STRING" />
<property name="accessionNumber" type="java.lang.String" column="ACCESSION_NUMBER" />
<property name="accessionNumberVersion" type="java.lang.String" column="VERSION" />
<property name="type" type="java.lang.Long" column="SEQUENCE_TYPE" />
<many-to-one name="clone" class="gov.nih.nci.cabio.domain.impl.CloneImpl" column="CLONE_ID" lazy="true" />
<set name="geneCollection" table="GENE_SEQUENCE" lazy="true" inverse="true">
<cache usage="read-only" />
<key column="SEQUENCE_ID" />
<many-to-many class="gov.nih.nci.cabio.domain.impl.GeneImpl" column="GENE_ID" />
</set>
</class>
</hibernate-mapping>

Taxon Object:

<?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 package="gov.nih.nci.cabio.domain.impl">
<class name="TaxonImpl" table="TAXON" mutable="false">
<cache usage="read-only" />
<id name="id" type="java.lang.Long" column="TAXON_ID">
<generator class="assigned" />
</id>
<property name="scientificName" type="java.lang.String" column="SCIENTIFIC_NAME" />
<property name="ethnicityOrStrain" type="java.lang.String" column="STRAIN_OR_ETHNICITY" />
<property name="abbreviation" type="java.lang.String" column="ABBREVIATION" />
<property name="commonName" type="java.lang.String" column="COMMON_NAME" />
<property name="isPreferred" type="java.lang.Boolean" column="PREFERRED" />
<set name="geneCollection" lazy="true" inverse="true">
<cache usage="read-only" />
<key column="TAXON_ID" />
<one-to-many class="gov.nih.nci.cabio.domain.impl.GeneImpl" />
</set>
<set name="chromosomeCollection" lazy="true" inverse="true">
<cache usage="read-only" />
<key column="TAXON_ID" />
<one-to-many class="gov.nih.nci.cabio.domain.impl.ChromosomeImpl" />
</set>
</class>
</hibernate-mapping>

Target Object:

?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 package="gov.nih.nci.cabio.domain.impl">
<class name="TargetImpl" table="TARGET" mutable="false">
<cache usage="read-only" />
<id name="id" type="java.lang.Long" column="TARGET_ID">
<generator class="assigned" />
</id>
<property name="type" type="java.lang.String" column="TARGET_TYPE" />
<property name="name" type="java.lang.String" column="TARGET_NAME" />
<set name="geneCollection" table="GENE_TARGET" lazy="true" inverse="true">
<cache usage="read-only" />
<key column="TARGET_ID" />
<many-to-many class="gov.nih.nci.cabio.domain.impl.GeneImpl" column="GENE_ID" />
</set>
</class>
</hibernate-mapping>

Chromosome Object:

<?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 package="gov.nih.nci.cabio.domain.impl">
<class name="ChromosomeImpl" table="CHROMOSOME" mutable="false">
<cache usage="read-only" />
<id name="id" type="java.lang.Long" column="CHROMOSOME_ID">
<generator class="assigned" />
</id>
<property name="name" type="java.lang.String" column="CHROMOSOME_NUMBER" />
<set name="geneCollection" lazy="true" inverse="true">
<cache usage="read-only" />
<key column="CHROMOSOME_ID" />
<one-to-many class="gov.nih.nci.cabio.domain.impl.GeneImpl" />
</set>
<many-to-one name="taxon" class="gov.nih.nci.cabio.domain.impl.TaxonImpl" column="TAXON_ID" lazy="true" />
</class>
</hibernate-mapping>

Clone Object:

<?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 package="gov.nih.nci.cabio.domain.impl">
<class name="CloneImpl" table="CLONE" mutable="false">
<cache usage="read-only" />
<id name="id" type="java.lang.Long" column="CLONE_ID">
<generator class="assigned" />
</id>
<property name="verified" type="java.lang.Boolean" column="VERIFIED" />
<property name="insertSize" type="java.lang.Long" column="INSERT_SIZE" />
<property name="accessionNumber" type="java.lang.String" column="ACCESSION_NUMBER" />
<property name="name" type="java.lang.String" column="CLONE_NAME" />
<property name="version" type="java.lang.String" column="VERSION" />
<property name="strain" type="java.lang.String" column="CLONE_STRAIN" />
<many-to-one name="library" class="gov.nih.nci.cabio.domain.impl.LibraryImpl" column="LIBRARY_ID" lazy="true" />
<set name="sequenceCollection" lazy="true" inverse="true">
<cache usage="read-only" />
<key column="CLONE_ID" />
<one-to-many class="gov.nih.nci.cabio.domain.impl.SequenceImpl" />
</set>
</class>
</hibernate-mapping>




Code between sessionFactory.openSession() and session.close():


public class HibernateUtil {

private static Logger log = Logger.getLogger(HibernateUtil.class);

private static final SessionFactory sessionFactory;

static {
try {
// Create the SessionFactory
sessionFactory = new Configuration().configure()
.buildSessionFactory();
} catch (Throwable ex) {
log.error("Initial SessionFactory creation failed.", ex);
throw new ExceptionInInitializerError(ex);
}
}

public static final ThreadLocal session = new ThreadLocal();

public static Session currentSession() throws HibernateException {
Session s = (Session) session.get();
// Open a new Session, if this Thread has none yet
if (s == null) {
s = sessionFactory.openSession();
session.set(s);
}
return s;
}

public static void closeSession() throws HibernateException {
Session s = (Session) session.get();
session.set(null);
if (s != null)
s.close();
}


}


Full stack trace of any exception that occurs:

No Exceptions


Name and version of the database you are using:

mySQL 4.1.12

The generated SQL (show_sql=true):

Hibernate: select this_.GENE_ID as GENE1_0_, this_.GENE_TITLE as GENE2_0_0_, this_.GENE_SYMBOL as GE
NE3_0_0_, this_.LOCUS_LINK_SUMMARY as LOCUS4_0_0_, this_.OMIM_ID as OMIM5_0_0_, this_.LOCUS_LINK_ID
as LOCUS6_0_0_, this_.CLUSTER_ID as CLUSTER7_0_0_, this_.CHROMOSOME_ID as CHROMOSOME8_0_0_, this_.TA
XON_ID as TAXON9_0_0_ from GENE this_ limit ?
J.Z.............ORMDAOImpl.query: construction ORMConnection ....
J.Z.............ORMDAOImpl.query: ormConn = gov.nih.nci.system.dao.impl.orm.ORMConnection@1b8b3bb
J.Z.............ORMDAOImpl.query: serviceLocator counter = 1
J.Z.............ORMDAOImpl.query: get the hibernate session ... ... ...
J.Z........ obj is Criteria Object
Hibernate: select count(*) as y0_ from GENE this_
ORMDAOImpl ===== count = 118

Debug level Hibernate log excerpt:

Do you understand the difference between the second level cache and the query cache?

Well, when i posted the question I didn't quite, but I think I do now. Please let me know if I am incorrect.

Query cache: someone runs a query like "select * from gene". The query results gets cached with the sql being the key to the hashtable so the next time someone runs the identical query the cache recognizes the sql as a key and returns the cached result set.

Second-level cache: someone runs a query like the above which returns 12 records. Someone then runs another query with the primary key of 2 as the search criteria. The gene cache is checked and if the primary key '2' happens to be the key in the cache hashtable that value is returned eventually as a materialized object. If there is no key of '2' the database is then queried normally.

Based on this understanding I have tried a new test. I set my maxElementsInMemory="10" in the ehcache.xml file. I run a select * from gene and cache all the records about(1000)I then run a query base on GENE_ID=2 . This record should have been contained in the first query result set, so I shouldn't see sql, but I still do. I looked inside the cache file gene.data and the record is there.

I did notice one thing and I don't know if this matters, but the org.hibernate.cache.UpdateTimestampsCache.data file never increases in size (zero).

Am I understanding how this works or am I still confused?

Thanks

Mike

Using the out of the box default caching I see the following in my hibernate debug. You can see where running a simple query for gene_id=2 which is the primary key of my gene table returns the same record and caches it twice. I would think the second time it runs the query it would find it in the cache. Anyone have any idea or see anything missing in this debug.:

15:23:07,154 WARN EhCacheProvider:97 - Could not find configuration [gov.nih.nci.camod.domain.impl.GeneImpl]; using defaults.
15:23:07,154 DEBUG EhCacheProvider:100 - started EHCache region: gov.nih.nci.camod.domain.impl.GeneImpl
15:23:07,420 WARN EhCacheProvider:97 - Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
15:23:07,420 DEBUG EhCacheProvider:100 - started EHCache region: org.hibernate.cache.StandardQueryCache
15:23:07,420 INFO SessionFactoryImpl:366 - Checking 0 named queries
Hibernate: select * from ( select this_.GENE_ID as GENE1_0_, this_.FULL_NAME as FULL2_135_0_, this_.CLUSTER_ID as CLUSTER3_135_0_, this_.SYMBOL as SYMBOL135_0_, this_.TAXON_ID as TAXON5_135_0_, this_.CHROMOSOME_ID as CHROMOSOME6_135_0_ from GENE_TV this_ where this_.GENE_ID=? ) where rownum <= ?
15:23:07,498 DEBUG LongType:59 - binding '2' to parameter: 1
15:23:07,514 DEBUG LongType:86 - returning '2' as column: GENE1_0_
15:23:07,529 DEBUG StringType:86 - returning 'N-acetyltransferase 2 (arylamine N-acetyltransferase)' as column: FULL2_135_0_
15:23:07,529 DEBUG LongType:86 - returning '2' as column: CLUSTER3_135_0_
15:23:07,529 DEBUG StringType:86 - returning 'NAT2' as column: SYMBOL135_0_
15:23:07,529 DEBUG LongType:86 - returning '5' as column: TAXON5_135_0_
15:23:07,545 DEBUG LongType:86 - returning '0' as column: CHROMOSOME6_135_0_
15:23:07,576 DEBUG ReadOnlyCache:58 - Caching: gov.nih.nci.cabio.domain.impl.GeneImpl#2
Hibernate: select * from ( select this_.GENE_ID as GENE1_0_, this_.FULL_NAME as FULL2_135_0_, this_.CLUSTER_ID as CLUSTER3_135_0_, this_.SYMBOL as SYMBOL135_0_, this_.TAXON_ID as TAXON5_135_0_, this_.CHROMOSOME_ID as CHROMOSOME6_135_0_ from GENE_TV this_ where this_.GENE_ID=? ) where rownum <= ?
15:23:12,670 DEBUG LongType:59 - binding '2' to parameter: 1
15:23:12,670 DEBUG LongType:86 - returning '2' as column: GENE1_0_
15:23:12,670 DEBUG StringType:86 - returning 'N-acetyltransferase 2 (arylamine N-acetyltransferase)' as column: FULL2_135_0_
15:23:12,670 DEBUG LongType:86 - returning '2' as column: CLUSTER3_135_0_
15:23:12,670 DEBUG StringType:86 - returning 'NAT2' as column: SYMBOL135_0_
15:23:12,670 DEBUG LongType:86 - returning '5' as column: TAXON5_135_0_
15:23:12,670 DEBUG LongType:86 - returning '0' as column: CHROMOSOME6_135_0_
15:23:12,686 DEBUG ReadOnlyCache:58 - Caching: gov.nih.nci.cabio.domain.impl.GeneImpl#2
Hibernate: select count(*) as y0_ from GENE_TV this_ where this_.GENE_ID=?
15:23:12,733 DEBUG LongType:59 - binding '2' to parameter: 1
15:23:12,733 DEBUG IntegerType:86 - returning '1' as column: y0_
ORMDAOImpl ===== count = 1
Hibernate: select count(*) as y0_ from GENE_TV this_ where this_.GENE_ID=?
15:23:12,780 DEBUG LongType:59 - binding '2' to parameter: 1
15:23:12,780 DEBUG IntegerType:86 - returning '1' as column: y0_
ORMDAOImpl ===== count = 1