Hibernate Community • View topic - Having problem of executing a HQL query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Having problem of executing a HQL query

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

vfonger

Post subject: Having problem of executing a HQL query

Posted: Mon Feb 16, 2004 11:07 am

Beginner

Joined: Wed Sep 10, 2003 5:32 pm
Posts: 28

Hi everyone,

I am having problem of executing the following HQL query:

Code:

select grp from com.company4.internaldatasource.database.AccGroupInfo as grp inner join grp.getAccUsers as usr where usr.usrLname like 'V%'

Everytime I execute this query, I will get the following java exception:

Code:

net.sf.hibernate.QueryException: could not resolve property: getAccUsers of: com.example4.internaldatasource.database.AccGroupInfo [select grp from com.example4.internaldatasource.database.AccGroupInfo as grp inner join grp.getAccUsers as usr where usr.usrLname like 'V%']
        at net.sf.hibernate.persister.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:38)
        at net.sf.hibernate.hql.PathExpressionParser.getPropertyType(PathExpressionParser.java:244)
        at net.sf.hibernate.hql.FromPathExpressionParser.end(FromPathExpressionParser.java:12)
        at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30)
        at net.sf.hibernate.hql.FromParser.token(FromParser.java:193)
        at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
        at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
        at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
        at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
        at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
        at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:293)
        at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1530)
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501)
        at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
        at com.test.database.TestInternalDatabase.getGroupInfo(TestInternalDatabase.java:54)
        at com.test.database.TestInternalDatabase.main(TestInternalDatabase.java:101)

Here is the groupinfo hibernate xml file:

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
    
<hibernate-mapping>


<class 
    name="com.example4.internaldatasource.database.AccGroupInfo" 
    table="ACC_GROUP_INFO"
>
    <id
        name="grpId"
        type="long"
        column="G_ID"
    >
        <generator class="assigned" />
    </id>
    <property
        name="grpName"
        type="java.lang.String"
        column="G_NAME"
        not-null="true"
        length="40"
    />

    <!-- bi-directional one-to-many association to AccUser -->
    <set
        name="accUsers"
        lazy="true"
        inverse="true"
    >
        <key>
            <column name="G_ID" />
        </key>
        <one-to-many 
            class="com.example4.internaldatasource.database.AccUser"
        />
    </set>
</class>
</hibernate-mapping>

Here is the users hibernate xml file:

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
    
<hibernate-mapping>


<class 
    name="com.example4.internaldatasource.database.AccUser" 
    table="ACC_USER"
>
    <id
        name="usrId"
        type="long"
        column="U_ID"
    >
        <generator class="assigned" />
    </id>
    <property
        name="grpId"
        type="long"
        column="G_ID"
    />
    <property
        name="usrFname"
        type="java.lang.String"
        column="U_FNAME"
        length="30"
    />
    <property
        name="usrLname"
        type="java.lang.String"
        column="U_LNAME"
        length="30"
    />

    <!-- associations -->
    <!-- bi-directional many-to-one association to AccGroupInfo -->
    <many-to-one
        name="accGroupInfo"
        class="com.example4.internaldatasource.database.AccGroupInfo"
        not-null="true"
   update="false"
   insert="false"
   outer-join="true"
   unique="false"
    >
        <column name="G_ID" />
    </many-to-one>   
    <!-- bi-directional one-to-many association to AccTrial -->
    <set
        name="accTrialsByAtLastModifiedBy"
        lazy="true"
        inverse="true"
    >
        <key>
            <column name="AT_LAST_MODIFIED_BY" />
        </key>
        <one-to-many 
            class="com.example4.internaldatasource.database.AccTrial"
        />
    </set>
    <!-- bi-directional one-to-many association to AccTrial -->
    <set
        name="accTrialsByAtCreator"
        lazy="true"
        inverse="true"
    >
        <key>
            <column name="AT_CREATOR" />
        </key>
        <one-to-many 
            class="com.example4.internaldatasource.database.AccTrial"
        />
    </set>
    <!-- bi-directional one-to-many association to AccCampaign -->
    <set
        name="accCampaignsByAcCreator"
        lazy="true"
        inverse="true"
    >
        <key>
            <column name="AC_CREATOR" />
        </key>
        <one-to-many 
            class="com.example4.internaldatasource.database.AccCampaign"
        />
    </set>
    <!-- bi-directional one-to-many association to AccCampaign -->
    <set
        name="accCampaignsByAcLastModifiedBy"
        lazy="true"
        inverse="true"
    >
        <key>
            <column name="AC_LAST_MODIFIED_BY" />
        </key>
        <one-to-many 
            class="com.example4.internaldatasource.database.AccCampaign"
        />
    </set>

</class>
</hibernate-mapping>

Here is log file generates by hibernate:

Code:

51:32,953  INFO Environment:462 - Hibernate 2.1.2
51:32,999  INFO Environment:496 - loaded properties from resource hibernate.properties: {hibernate.cglib.use_reflection_optimizer=true}
51:32,999  INFO Environment:519 - using CGLIB reflection optimizer
51:33,031  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccGroupInfo.hbm.xml
51:34,109 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:34,124 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:34,890  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccGroupInfo -> ACC_GROUP_INFO
51:35,156 DEBUG Binder:462 - Mapped property: grpId -> G_ID, type: long
51:35,203 DEBUG Binder:462 - Mapped property: grpName -> G_NAME, type: string
51:35,265 DEBUG Binder:462 - Mapped property: accUsers, type: java.util.Set
51:35,265  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccCategory.hbm.xml
51:35,281 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:35,281 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:35,421  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccCategory -> ACC_CATEGORY
51:35,421 DEBUG Binder:462 - Mapped property: catId -> CAT_ID, type: long
51:35,453 DEBUG Binder:462 - Mapped property: catName -> CAT_NAME, type: string
51:35,468 DEBUG Binder:462 - Mapped property: accCampaigns, type: java.util.Set
51:35,484 DEBUG Binder:462 - Mapped property: accGroupInfo -> G_ID, type: com.example4.internaldatasource.database.AccGroupInfo
51:35,484  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccUser.hbm.xml
51:35,499 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:35,515 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:35,781  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccUser -> ACC_USER
51:35,781 DEBUG Binder:462 - Mapped property: usrId -> U_ID, type: long
51:35,781 DEBUG Binder:462 - Mapped property: grpId -> G_ID, type: long
51:35,781 DEBUG Binder:462 - Mapped property: usrFname -> U_FNAME, type: string
51:35,781 DEBUG Binder:462 - Mapped property: usrLname -> U_LNAME, type: string
51:35,796 DEBUG Binder:462 - Mapped property: accGroupInfo -> G_ID, type: com.example4.internaldatasource.database.AccGroupInfo
51:35,812 DEBUG Binder:462 - Mapped property: accTrialsByAtLastModifiedBy, type: java.util.Set
51:35,812 DEBUG Binder:462 - Mapped property: accTrialsByAtCreator, type: java.util.Set
51:35,812 DEBUG Binder:462 - Mapped property: accCampaignsByAcCreator, type: java.util.Set
51:35,812 DEBUG Binder:462 - Mapped property: accCampaignsByAcLastModifiedBy, type: java.util.Set
51:35,812  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccDatasource.hbm.xml
51:35,843 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:35,843 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:35,953  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccDatasource -> ACC_DATASOURCE
51:35,953 DEBUG Binder:462 - Mapped property: dsId -> DS_ID, type: long
51:35,953 DEBUG Binder:462 - Mapped property: dsName -> DS_NAME, type: string
51:35,953 DEBUG Binder:462 - Mapped property: accGroupInfo -> G_ID, type: com.example4.internaldatasource.database.AccGroupInfo
51:35,953 DEBUG Binder:462 - Mapped property: accCampaigns, type: java.util.Set
51:35,953  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccCampaign.hbm.xml
51:35,968 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:35,984 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:36,109  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccCampaign -> ACC_CAMPAIGN
51:36,109 DEBUG Binder:462 - Mapped property: acId -> AC_ID, type: long
51:36,109 DEBUG Binder:462 - Mapped property: catId -> CAT_ID, type: long
51:36,125 DEBUG Binder:462 - Mapped property: dsId -> DS_ID, type: long
51:36,125 DEBUG Binder:462 - Mapped property: acName -> AC_NAME, type: string
51:36,125 DEBUG Binder:462 - Mapped property: acArchived -> AC_ARCHIVED, type: integer
51:36,125 DEBUG Binder:462 - Mapped property: acArchiveDate -> AC_ARCHIVE_DATE, type: timestamp
51:36,125 DEBUG Binder:462 - Mapped property: accArchiveNow -> ACC_ARCHIVE_NOW, type: integer
51:36,125 DEBUG Binder:462 - Mapped property: acParent -> AC_PARENT, type: long
51:36,125 DEBUG Binder:462 - Mapped property: acCreator -> AC_CREATOR, type: long
51:36,140 DEBUG Binder:462 - Mapped property: acCreationDate -> AC_CREATION_DATE, type: timestamp
51:36,140 DEBUG Binder:462 - Mapped property: acLastModifiedBy -> AC_LAST_MODIFIED_BY, type: long
51:36,140 DEBUG Binder:462 - Mapped property: acModificationDate -> AC_MODIFICATION_DATE, type: timestamp
51:36,140 DEBUG Binder:462 - Mapped property: accCategory -> CAT_ID, type: com.example4.internaldatasource.database.AccCategory
51:36,140 DEBUG Binder:462 - Mapped property: accTrials, type: java.util.Set
51:36,140 DEBUG Binder:462 - Mapped property: accUserByAcCreator -> AC_CREATOR, type: com.example4.internaldatasource.database.AccUser
51:36,140 DEBUG Binder:462 - Mapped property: accUserByAcLastModifiedBy -> AC_LAST_MODIFIED_BY, type: com.example4.internaldatasource.database.AccUser
51:36,156 DEBUG Binder:462 - Mapped property: accDatasource -> DS_ID, type: com.example4.internaldatasource.database.AccDatasource
51:36,265  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccTrial.hbm.xml
51:36,296 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:36,312 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:36,515  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccTrial -> ACC_TRIAL
51:36,515 DEBUG Binder:462 - Mapped property: atId -> AT_ID, type: long
51:36,531 DEBUG Binder:462 - Mapped property: acId -> AC_ID, type: long
51:36,531 DEBUG Binder:462 - Mapped property: atName -> AT_NAME, type: string
51:36,531 DEBUG Binder:462 - Mapped property: atStart -> AT_START, type: timestamp
51:36,531 DEBUG Binder:462 - Mapped property: atEnd -> AT_END, type: timestamp
51:36,531 DEBUG Binder:462 - Mapped property: atBuildState -> AT_BUILD_STATE, type: long
51:36,531 DEBUG Binder:462 - Mapped property: atTotalCount -> AT_TOTAL_COUNT, type: long
51:36,546 DEBUG Binder:462 - Mapped property: atAddrErrorCount -> AT_ADDR_ERROR_COUNT, type: long
51:36,546 DEBUG Binder:462 - Mapped property: atContentErrorCount -> AT_CONTENT_ERROR_COUNT, type: long
51:36,546 DEBUG Binder:462 - Mapped property: atSentCount -> AT_SENT_COUNT, type: long
51:36,546 DEBUG Binder:462 - Mapped property: atDefaultList -> AT_DEFAULT_LIST, type: big_decimal
51:36,546 DEBUG Binder:462 - Mapped property: atReqDoubleConf -> AT_REQ_DOUBLE_CONF, type: big_decimal
51:36,546 DEBUG Binder:462 - Mapped property: atOpenedCount -> AT_OPENED_COUNT, type: long
51:36,546 DEBUG Binder:462 - Mapped property: atOptinCount -> AT_OPTIN_COUNT, type: long
51:36,546 DEBUG Binder:462 - Mapped property: atOptoutCount -> AT_OPTOUT_COUNT, type: long
51:36,562 DEBUG Binder:462 - Mapped property: atCreator -> AT_CREATOR, type: long
51:36,562 DEBUG Binder:462 - Mapped property: atCreationDate -> AT_CREATION_DATE, type: timestamp
51:36,562 DEBUG Binder:462 - Mapped property: atLastModifiedBy -> AT_LAST_MODIFIED_BY, type: long
51:36,562 DEBUG Binder:462 - Mapped property: atModificationDate -> AT_MODIFICATION_DATE, type: timestamp
51:36,562 DEBUG Binder:462 - Mapped property: accRedirects, type: java.util.Set
51:36,562 DEBUG Binder:462 - Mapped property: accCampaign -> AC_ID, type: com.example4.internaldatasource.database.AccCampaign
51:36,578 DEBUG Binder:462 - Mapped property: accUserByAtLastModifiedBy -> AT_LAST_MODIFIED_BY, type: com.example4.internaldatasource.database.AccUser
51:36,578 DEBUG Binder:462 - Mapped property: accUserByAtCreator -> AT_CREATOR, type: com.example4.internaldatasource.database.AccUser
51:36,578  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccRedirect.hbm.xml
51:36,593 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:36,593 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:36,656  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccRedirect -> ACC_REDIRECT
51:36,656 DEBUG Binder:462 - Mapped property: arId -> AR_ID, type: long
51:36,671 DEBUG Binder:462 - Mapped property: arName -> AR_NAME, type: string
51:36,671 DEBUG Binder:462 - Mapped property: arUrl -> AR_URL, type: string
51:36,671 DEBUG Binder:462 - Mapped property: arClicks -> AR_CLICKS, type: long
51:36,687 DEBUG Binder:462 - Mapped property: arClickType -> AR_CLICK_TYPE, type: string
51:36,687 DEBUG Binder:462 - Mapped property: arArchived -> AR_ARCHIVED, type: integer
51:36,687 DEBUG Binder:462 - Mapped property: arUniqClicks -> AR_UNIQ_CLICKS, type: long
51:36,687 DEBUG Binder:462 - Mapped property: accTrial -> AT_ID, type: com.example4.internaldatasource.database.AccTrial
51:36,687  INFO Configuration:595 - processing one-to-many association mappings
51:36,687 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccGroupInfo.accUsers
51:36,687  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccGroupInfo.accUsers -> ACC_USER
51:36,703 DEBUG Binder:1341 - Mapped collection key: G_ID, one-to-many: com.example4.internaldatasource.database.AccUser
51:36,703 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccCategory.accCampaigns
51:36,703  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccCategory.accCampaigns -> ACC_CAMPAIGN
51:36,703 DEBUG Binder:1341 - Mapped collection key: CAT_ID, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:36,703 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtLastModifiedBy
51:36,703  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtLastModifiedBy -> ACC_TRIAL
51:36,703 DEBUG Binder:1341 - Mapped collection key: AT_LAST_MODIFIED_BY, one-to-many: com.example4.internaldatasource.database.AccTrial
51:36,703 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtCreator
51:36,703  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtCreator -> ACC_TRIAL
51:36,703 DEBUG Binder:1341 - Mapped collection key: AT_CREATOR, one-to-many: com.example4.internaldatasource.database.AccTrial
51:36,703 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcCreator
51:36,703  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcCreator -> ACC_CAMPAIGN
51:36,703 DEBUG Binder:1341 - Mapped collection key: AC_CREATOR, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:36,703 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcLastModifiedBy
51:36,718  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcLastModifiedBy -> ACC_CAMPAIGN
51:36,718 DEBUG Binder:1341 - Mapped collection key: AC_LAST_MODIFIED_BY, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:36,718 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccDatasource.accCampaigns
51:36,718  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccDatasource.accCampaigns -> ACC_CAMPAIGN
51:36,718 DEBUG Binder:1341 - Mapped collection key: DS_ID, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:36,718 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccCampaign.accTrials
51:36,718  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccCampaign.accTrials -> ACC_TRIAL
51:36,718 DEBUG Binder:1341 - Mapped collection key: AC_ID, one-to-many: com.example4.internaldatasource.database.AccTrial
51:36,718 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccTrial.accRedirects
51:36,718  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccTrial.accRedirects -> ACC_REDIRECT
51:36,718 DEBUG Binder:1341 - Mapped collection key: AT_ID, one-to-many: com.example4.internaldatasource.database.AccRedirect
51:36,734  INFO Configuration:604 - processing one-to-one association property references
51:36,734  INFO Configuration:629 - processing foreign key constraints
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccTrial
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccGroupInfo
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccCampaign
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccGroupInfo
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccDatasource
51:36,734 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccCategory
51:36,750 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:36,750 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccGroupInfo
51:36,828  INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.OracleDialect
51:36,843  INFO SettingsFactory:62 - Use outer join fetching: true
51:36,859  INFO DBCPConnectionProvider:56 - DBCP using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@ora-dev.headquarters.example.com:1521:ORADEV
51:36,875  INFO DBCPConnectionProvider:57 - Connection properties: {user=VFONGER, password=Ally28101}
51:36,984  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
51:38,312  INFO SettingsFactory:102 - Use scrollable result sets: true
51:38,312  INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): false
51:38,312  INFO SettingsFactory:108 - Optimize cache for minimal puts: false
51:38,328  INFO SettingsFactory:111 - Default schema set to: VFONGER
51:38,328  INFO SettingsFactory:114 - echoing all SQL to stdout
51:38,328  INFO SettingsFactory:117 - Query language substitutions: {hqlCurrentDate=sysdate}
51:38,328  INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
51:38,343  INFO Configuration:1080 - instantiating and configuring caches
51:38,734  INFO SessionFactoryImpl:119 - building session factory
51:38,750 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {hibernate.dbcp.timeBetweenEvictionRunsMillis=60000, hibernate.connection.password=Ally28101, hibernate.query.substitutions=hqlCurrentDate sysdate, hibernate.dbcp.whenExhaustedAction=1, hibernate.show_sql=true, hibernate.dbcp.testOnBorrow=true, hibernate.jdbc.batch_size=20, hibernate.dbcp.testOnReturn=false, hibernate.dbcp.validationQuery=select 1 from dual, hibernate.dbcp.ps.maxActive=5, hibernate.default_schema=VFONGER, hibernate.use_outer_join=true, hibernate.connection.username=VFONGER, hibernate.dbcp.maxActive=6, hibernate.dbcp.ps.whenExhaustedAction=1, hibernate.dbcp.maxIdle=16, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, hibernate.dbcp.ps.maxIdle=10, hibernate.dbcp.testWhileIdle=false, hibernate.dbcp.maxWait=2000, hibernate.dbcp.ps.maxWait=2000, hibernate.dbcp.minEvictableIdleTimeMillis=0, hibernate.dialect=net.sf.hibernate.dialect.OracleDialect, hibernate.connection.url=jdbc:oracle:thin:@ora-dev.headquarters.example.com:1521:ORADEV}
51:40,453 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
51:40,468 DEBUG SessionFactoryObjectFactory:76 - registered: 40288097fabecf9200fabecf9a150000 (unnamed)
51:40,468  INFO SessionFactoryObjectFactory:82 - no JNDI name configured
51:40,468 DEBUG SessionFactoryImpl:196 - instantiated session factory
51:40,656 DEBUG SessionImpl:531 - opened session
51:40,687 DEBUG SessionImpl:1497 - find: select camp.acName, trial.atId, trial.atName, trial.atStart, trial.atEnd, trial.atTotalCount, trial.atBuildState from com.example4.internaldatasource.database.AccCampaign as camp inner join camp.accTrials as trial where trial.atId = 110896
51:40,703 DEBUG QueryParameters:108 - named parameters: {}
51:40,765 DEBUG QueryTranslator:147 - compiling query
51:40,859 DEBUG SessionImpl:2228 - flushing session
51:40,859 DEBUG SessionImpl:2421 - Flushing entities and processing referenced collections
51:40,859 DEBUG SessionImpl:2764 - Processing unreferenced collections
51:40,859 DEBUG SessionImpl:2778 - Scheduling collection removes/(re)creates/updates
51:40,859 DEBUG SessionImpl:2252 - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
51:40,875 DEBUG SessionImpl:2257 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
51:40,875 DEBUG SessionImpl:1800 - Dont need to execute flush
51:40,875 DEBUG QueryTranslator:199 - HQL: select camp.acName, trial.atId, trial.atName, trial.atStart, trial.atEnd, trial.atTotalCount, trial.atBuildState from com.example4.internaldatasource.database.AccCampaign as camp inner join camp.accTrials as trial where trial.atId = 110896
51:40,875 DEBUG QueryTranslator:200 - SQL: select acccampaig0_.AC_NAME as x0_0_, acctrials1_.AT_ID as x1_0_, acctrials1_.AT_NAME as x2_0_, acctrials1_.AT_START as x3_0_, acctrials1_.AT_END as x4_0_, acctrials1_.AT_TOTAL_COUNT as x5_0_, acctrials1_.AT_BUILD_STATE as x6_0_ from VFONGER.ACC_CAMPAIGN acccampaig0_, VFONGER.ACC_TRIAL acctrials1_ where acccampaig0_.AC_ID=acctrials1_.AC_ID and ((acctrials1_.AT_ID=110896 ))
51:40,875 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
51:40,890 DEBUG SQL:237 - select acccampaig0_.AC_NAME as x0_0_, acctrials1_.AT_ID as x1_0_, acctrials1_.AT_NAME as x2_0_, acctrials1_.AT_START as x3_0_, acctrials1_.AT_END as x4_0_, acctrials1_.AT_TOTAL_COUNT as x5_0_, acctrials1_.AT_BUILD_STATE as x6_0_ from VFONGER.ACC_CAMPAIGN acccampaig0_, VFONGER.ACC_TRIAL acctrials1_ where acccampaig0_.AC_ID=acctrials1_.AC_ID and ((acctrials1_.AT_ID=110896 ))
51:40,890 DEBUG BatcherImpl:241 - preparing statement
51:41,000 DEBUG Loader:197 - processing result set
51:41,000 DEBUG Loader:405 - result row: 
51:41,000 DEBUG StringType:68 - returning 'Av4 Extract Query(4)' as column: x0_0_
51:41,047 DEBUG LongType:68 - returning '110896' as column: x1_0_
51:41,047 DEBUG StringType:68 - returning 'Av4 Extract Query(4)' as column: x2_0_
51:41,047 DEBUG TimestampType:68 - returning '12 September 2003 12:24:00' as column: x3_0_
51:41,062 DEBUG TimestampType:68 - returning '12 October 2003 13:24:00' as column: x4_0_
51:41,062 DEBUG LongType:68 - returning '5' as column: x5_0_
51:41,062 DEBUG LongType:68 - returning '4' as column: x6_0_
51:41,062 DEBUG Loader:226 - done processing result set (1 rows)
51:41,078 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
51:41,078 DEBUG BatcherImpl:261 - closing statement
51:41,078 DEBUG SessionImpl:3100 - initializing non-lazy collections
51:41,078 DEBUG SessionImpl:549 - closing session
51:41,078 DEBUG SessionImpl:3312 - disconnecting session
51:41,093 DEBUG SessionImpl:561 - transaction completion
51:41,109  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccGroupInfo.hbm.xml
51:41,125 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:41,140 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:41,437  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccGroupInfo -> ACC_GROUP_INFO
51:41,437 DEBUG Binder:462 - Mapped property: grpId -> G_ID, type: long
51:41,437 DEBUG Binder:462 - Mapped property: grpName -> G_NAME, type: string
51:41,734 DEBUG SessionImpl:3364 - running Session.finalize()
51:41,734 DEBUG Binder:462 - Mapped property: accUsers, type: java.util.Set
51:41,734  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccCategory.hbm.xml
51:41,750 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:41,750 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:41,812  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccCategory -> ACC_CATEGORY
51:41,812 DEBUG Binder:462 - Mapped property: catId -> CAT_ID, type: long
51:41,812 DEBUG Binder:462 - Mapped property: catName -> CAT_NAME, type: string
51:41,828 DEBUG Binder:462 - Mapped property: accCampaigns, type: java.util.Set
51:41,828 DEBUG Binder:462 - Mapped property: accGroupInfo -> G_ID, type: com.example4.internaldatasource.database.AccGroupInfo
51:41,828  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccUser.hbm.xml
51:41,844 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:41,859 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:41,922  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccUser -> ACC_USER
51:41,922 DEBUG Binder:462 - Mapped property: usrId -> U_ID, type: long
51:41,922 DEBUG Binder:462 - Mapped property: grpId -> G_ID, type: long
51:41,922 DEBUG Binder:462 - Mapped property: usrFname -> U_FNAME, type: string
51:41,937 DEBUG Binder:462 - Mapped property: usrLname -> U_LNAME, type: string
51:41,937 DEBUG Binder:462 - Mapped property: accGroupInfo -> G_ID, type: com.example4.internaldatasource.database.AccGroupInfo
51:41,937 DEBUG Binder:462 - Mapped property: accTrialsByAtLastModifiedBy, type: java.util.Set
51:41,937 DEBUG Binder:462 - Mapped property: accTrialsByAtCreator, type: java.util.Set
51:41,937 DEBUG Binder:462 - Mapped property: accCampaignsByAcCreator, type: java.util.Set
51:41,937 DEBUG Binder:462 - Mapped property: accCampaignsByAcLastModifiedBy, type: java.util.Set
51:41,937  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccDatasource.hbm.xml
51:42,172 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:42,172 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:42,234  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccDatasource -> ACC_DATASOURCE
51:42,234 DEBUG Binder:462 - Mapped property: dsId -> DS_ID, type: long
51:42,234 DEBUG Binder:462 - Mapped property: dsName -> DS_NAME, type: string
51:42,234 DEBUG Binder:462 - Mapped property: accGroupInfo -> G_ID, type: com.example4.internaldatasource.database.AccGroupInfo
51:42,234 DEBUG Binder:462 - Mapped property: accCampaigns, type: java.util.Set
51:42,234  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccCampaign.hbm.xml
51:42,250 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:42,265 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:42,328  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccCampaign -> ACC_CAMPAIGN
51:42,344 DEBUG Binder:462 - Mapped property: acId -> AC_ID, type: long
51:42,344 DEBUG Binder:462 - Mapped property: catId -> CAT_ID, type: long
51:42,344 DEBUG Binder:462 - Mapped property: dsId -> DS_ID, type: long
51:42,344 DEBUG Binder:462 - Mapped property: acName -> AC_NAME, type: string
51:42,344 DEBUG Binder:462 - Mapped property: acArchived -> AC_ARCHIVED, type: integer
51:42,344 DEBUG Binder:462 - Mapped property: acArchiveDate -> AC_ARCHIVE_DATE, type: timestamp
51:42,344 DEBUG Binder:462 - Mapped property: accArchiveNow -> ACC_ARCHIVE_NOW, type: integer
51:42,344 DEBUG Binder:462 - Mapped property: acParent -> AC_PARENT, type: long
51:42,344 DEBUG Binder:462 - Mapped property: acCreator -> AC_CREATOR, type: long
51:42,344 DEBUG Binder:462 - Mapped property: acCreationDate -> AC_CREATION_DATE, type: timestamp
51:42,344 DEBUG Binder:462 - Mapped property: acLastModifiedBy -> AC_LAST_MODIFIED_BY, type: long
51:42,344 DEBUG Binder:462 - Mapped property: acModificationDate -> AC_MODIFICATION_DATE, type: timestamp
51:42,359 DEBUG Binder:462 - Mapped property: accCategory -> CAT_ID, type: com.example4.internaldatasource.database.AccCategory
51:42,359 DEBUG Binder:462 - Mapped property: accTrials, type: java.util.Set
51:42,359 DEBUG Binder:462 - Mapped property: accUserByAcCreator -> AC_CREATOR, type: com.example4.internaldatasource.database.AccUser
51:42,359 DEBUG Binder:462 - Mapped property: accUserByAcLastModifiedBy -> AC_LAST_MODIFIED_BY, type: com.example4.internaldatasource.database.AccUser
51:42,359 DEBUG Binder:462 - Mapped property: accDatasource -> DS_ID, type: com.example4.internaldatasource.database.AccDatasource
51:42,359  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccTrial.hbm.xml
51:42,375 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:42,390 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:42,687  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccTrial -> ACC_TRIAL
51:42,703 DEBUG Binder:462 - Mapped property: atId -> AT_ID, type: long
51:42,703 DEBUG Binder:462 - Mapped property: acId -> AC_ID, type: long
51:42,703 DEBUG Binder:462 - Mapped property: atName -> AT_NAME, type: string
51:42,703 DEBUG Binder:462 - Mapped property: atStart -> AT_START, type: timestamp
51:42,703 DEBUG Binder:462 - Mapped property: atEnd -> AT_END, type: timestamp
51:42,719 DEBUG Binder:462 - Mapped property: atBuildState -> AT_BUILD_STATE, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atTotalCount -> AT_TOTAL_COUNT, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atAddrErrorCount -> AT_ADDR_ERROR_COUNT, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atContentErrorCount -> AT_CONTENT_ERROR_COUNT, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atSentCount -> AT_SENT_COUNT, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atDefaultList -> AT_DEFAULT_LIST, type: big_decimal
51:42,719 DEBUG Binder:462 - Mapped property: atReqDoubleConf -> AT_REQ_DOUBLE_CONF, type: big_decimal
51:42,719 DEBUG Binder:462 - Mapped property: atOpenedCount -> AT_OPENED_COUNT, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atOptinCount -> AT_OPTIN_COUNT, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atOptoutCount -> AT_OPTOUT_COUNT, type: long
51:42,719 DEBUG Binder:462 - Mapped property: atCreator -> AT_CREATOR, type: long
51:42,734 DEBUG Binder:462 - Mapped property: atCreationDate -> AT_CREATION_DATE, type: timestamp
51:42,734 DEBUG Binder:462 - Mapped property: atLastModifiedBy -> AT_LAST_MODIFIED_BY, type: long
51:42,734 DEBUG Binder:462 - Mapped property: atModificationDate -> AT_MODIFICATION_DATE, type: timestamp
51:42,734 DEBUG Binder:462 - Mapped property: accRedirects, type: java.util.Set
51:42,734 DEBUG Binder:462 - Mapped property: accCampaign -> AC_ID, type: com.example4.internaldatasource.database.AccCampaign
51:42,734 DEBUG Binder:462 - Mapped property: accUserByAtLastModifiedBy -> AT_LAST_MODIFIED_BY, type: com.example4.internaldatasource.database.AccUser
51:42,750 DEBUG Binder:462 - Mapped property: accUserByAtCreator -> AT_CREATOR, type: com.example4.internaldatasource.database.AccUser
51:42,750  INFO Configuration:329 - Mapping resource: com/example4/internaldatasource/database/AccRedirect.hbm.xml
51:42,765 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
51:42,765 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
51:42,828  INFO Binder:229 - Mapping class: com.example4.internaldatasource.database.AccRedirect -> ACC_REDIRECT
51:42,828 DEBUG Binder:462 - Mapped property: arId -> AR_ID, type: long
51:42,828 DEBUG Binder:462 - Mapped property: arName -> AR_NAME, type: string
51:42,828 DEBUG Binder:462 - Mapped property: arUrl -> AR_URL, type: string
51:42,828 DEBUG Binder:462 - Mapped property: arClicks -> AR_CLICKS, type: long
51:42,828 DEBUG Binder:462 - Mapped property: arClickType -> AR_CLICK_TYPE, type: string
51:42,828 DEBUG Binder:462 - Mapped property: arArchived -> AR_ARCHIVED, type: integer
51:42,844 DEBUG Binder:462 - Mapped property: arUniqClicks -> AR_UNIQ_CLICKS, type: long
51:42,844 DEBUG Binder:462 - Mapped property: accTrial -> AT_ID, type: com.example4.internaldatasource.database.AccTrial
51:42,844  INFO Configuration:595 - processing one-to-many association mappings
51:42,844 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccGroupInfo.accUsers
51:42,844  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccGroupInfo.accUsers -> ACC_USER
51:42,844 DEBUG Binder:1341 - Mapped collection key: G_ID, one-to-many: com.example4.internaldatasource.database.AccUser
51:42,844 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccCategory.accCampaigns
51:42,844  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccCategory.accCampaigns -> ACC_CAMPAIGN
51:42,844 DEBUG Binder:1341 - Mapped collection key: CAT_ID, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:42,859 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtLastModifiedBy
51:42,859  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtLastModifiedBy -> ACC_TRIAL
51:42,859 DEBUG Binder:1341 - Mapped collection key: AT_LAST_MODIFIED_BY, one-to-many: com.example4.internaldatasource.database.AccTrial
51:42,859 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtCreator
51:42,859  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accTrialsByAtCreator -> ACC_TRIAL
51:42,859 DEBUG Binder:1341 - Mapped collection key: AT_CREATOR, one-to-many: com.example4.internaldatasource.database.AccTrial
51:42,859 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcCreator
51:42,859  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcCreator -> ACC_CAMPAIGN
51:42,875 DEBUG Binder:1341 - Mapped collection key: AC_CREATOR, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:42,875 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcLastModifiedBy
51:42,875  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccUser.accCampaignsByAcLastModifiedBy -> ACC_CAMPAIGN
51:42,875 DEBUG Binder:1341 - Mapped collection key: AC_LAST_MODIFIED_BY, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:42,875 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccDatasource.accCampaigns
51:42,875  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccDatasource.accCampaigns -> ACC_CAMPAIGN
51:42,875 DEBUG Binder:1341 - Mapped collection key: DS_ID, one-to-many: com.example4.internaldatasource.database.AccCampaign
51:42,875 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccCampaign.accTrials
51:42,875  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccCampaign.accTrials -> ACC_TRIAL
51:42,875 DEBUG Binder:1341 - Mapped collection key: AC_ID, one-to-many: com.example4.internaldatasource.database.AccTrial
51:42,890 DEBUG Binder:1326 - Second pass for collection: com.example4.internaldatasource.database.AccTrial.accRedirects
51:42,890  INFO Binder:1154 - Mapping collection: com.example4.internaldatasource.database.AccTrial.accRedirects -> ACC_REDIRECT
51:42,890 DEBUG Binder:1341 - Mapped collection key: AT_ID, one-to-many: com.example4.internaldatasource.database.AccRedirect
51:42,890  INFO Configuration:604 - processing one-to-one association property references
51:42,890  INFO Configuration:629 - processing foreign key constraints
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccTrial
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccGroupInfo
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccCampaign
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccGroupInfo
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccDatasource
51:42,890 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccCategory
51:42,906 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccUser
51:42,906 DEBUG Configuration:639 - resolving reference to class: com.example4.internaldatasource.database.AccGroupInfo
51:42,906  INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.OracleDialect
51:42,906  INFO SettingsFactory:62 - Use outer join fetching: true
51:42,906  INFO DBCPConnectionProvider:56 - DBCP using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@ora-dev.headquarters.example.com:1521:ORADEV
51:42,906  INFO DBCPConnectionProvider:57 - Connection properties: {user=VFONGER, password=Ally28101}
51:42,906  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
51:43,109  INFO SettingsFactory:102 - Use scrollable result sets: true
51:43,109  INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): false
51:43,109  INFO SettingsFactory:108 - Optimize cache for minimal puts: false
51:43,109  INFO SettingsFactory:111 - Default schema set to: VFONGER
51:43,109  INFO SettingsFactory:114 - echoing all SQL to stdout
51:43,109  INFO SettingsFactory:117 - Query language substitutions: {hqlCurrentDate=sysdate}
51:43,109  INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
51:43,109  INFO Configuration:1080 - instantiating and configuring caches
51:43,125  INFO SessionFactoryImpl:119 - building session factory
51:43,125 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {hibernate.dbcp.timeBetweenEvictionRunsMillis=60000, hibernate.connection.password=Ally28101, hibernate.query.substitutions=hqlCurrentDate sysdate, hibernate.dbcp.whenExhaustedAction=1, hibernate.show_sql=true, hibernate.dbcp.testOnBorrow=true, hibernate.jdbc.batch_size=20, hibernate.dbcp.testOnReturn=false, hibernate.dbcp.validationQuery=select 1 from dual, hibernate.dbcp.ps.maxActive=5, hibernate.default_schema=VFONGER, hibernate.use_outer_join=true, hibernate.connection.username=VFONGER, hibernate.dbcp.maxActive=6, hibernate.dbcp.ps.whenExhaustedAction=1, hibernate.dbcp.maxIdle=16, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, hibernate.dbcp.ps.maxIdle=10, hibernate.dbcp.testWhileIdle=false, hibernate.dbcp.maxWait=2000, hibernate.dbcp.ps.maxWait=2000, hibernate.dbcp.minEvictableIdleTimeMillis=0, hibernate.dialect=net.sf.hibernate.dialect.OracleDialect, hibernate.connection.url=jdbc:oracle:thin:@ora-dev.headquarters.example.com:1521:ORADEV}
51:43,609 DEBUG SessionFactoryObjectFactory:76 - registered: 40288097fabecf9200fabecfa6790001 (unnamed)
51:43,609  INFO SessionFactoryObjectFactory:82 - no JNDI name configured
51:43,609 DEBUG SessionFactoryImpl:196 - instantiated session factory
51:43,609 DEBUG SessionImpl:531 - opened session
51:43,609 DEBUG SessionImpl:1497 - find: select grp from com.example4.internaldatasource.database.AccGroupInfo as grp inner join grp.getAccUsers as usr where usr.usrLname like 'V%'
51:43,609 DEBUG QueryParameters:108 - named parameters: {}
51:43,609 DEBUG QueryTranslator:147 - compiling query

I have a lot of similar mapping and I have no problem to execute HQL query but this one I run into problem, if anyone can give me some pointers how to correct it, that will be wonderful. THanks

Vivian

Top

michael

Post subject:

Posted: Mon Feb 16, 2004 11:08 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

The query should be

Code:

select grp from com.company4.internaldatasource.database.AccGroupInfo as grp inner join grp.accUsers as usr where usr.usrLname like 'V%' 

The property name must be used, not the method name.

Top

vfonger

Post subject:

Posted: Mon Feb 16, 2004 11:23 am

Beginner

Joined: Wed Sep 10, 2003 5:32 pm
Posts: 28

Thanks..:) :) I can't believe I cannot see this mistake.. :) :)

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

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