-->
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.  [ 3 posts ] 
Author Message
 Post subject: hibernate query returns null for data from table
PostPosted: Sat Mar 06, 2010 8:15 am 
Newbie

Joined: Sat Mar 06, 2010 7:50 am
Posts: 2
Following is the log when I run my application :




[color=#80FF00]Apache Ant version 1.7.1 compiled on June 27 2008
Buildfile: D:\rkp\workspace\AccountData\build.xml
parsing buildfile D:\rkp\workspace\AccountData\build.xml with URI = file:/D:/rkp/workspace/AccountData/build.xml
Project base dir set to: D:\rkp\workspace\AccountData
[antlib:org.apache.tools.ant] Could not load definitions from resource org/apache/tools/ant/antlib.xml. It could not be found.
Build sequence for target(s) `compile' is [init, compile]
Complete build sequence is [init, compile, run, ]
init:
[mkdir] Skipping D:\rkp\workspace\AccountData because it already exists.
compile:
[javac] D:\rkp\workspace\AccountData\.classpath skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\.project skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\.settings\org.eclipse.jdt.core.prefs skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\Copy of hibernate.cfg.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\accountdatapak\AccountData.class skipped - don't know how to handle it
[javac] accountdatapak\AccountData.java omitted as D:\rkp\workspace\AccountData\accountdatapak\AccountData.class is up to date.
[javac] D:\rkp\workspace\AccountData\accountdatapak\HibernateUtil.class skipped - don't know how to handle it
[javac] accountdatapak\HibernateUtil.java omitted as D:\rkp\workspace\AccountData\accountdatapak\HibernateUtil.class is up to date.
[javac] D:\rkp\workspace\AccountData\accountdatapak\TestHiberNate.class skipped - don't know how to handle it
[javac] accountdatapak\TestHiberNate.java omitted as D:\rkp\workspace\AccountData\accountdatapak\TestHiberNate.class is up to date.
[javac] D:\rkp\workspace\AccountData\accountdatapak\hibernate.cfg.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\build.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\hibernate.cfg.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\README.txt skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ant-contrib-1.0b2.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ant-junit-1.6.5.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\antlr-2.7.6.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\antlr.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\asm-attrs.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\asm.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\charsets.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\commons-collections-3.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\commons-collections.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\deploy.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\dnsns.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\dom4j-1.6.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\dom4j.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ejb3-persistence.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate-annotations.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate-commons-annotations.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate-core.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate3.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\javassist-3.9.0.GA.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\javassist.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\javaws.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jce.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jcl-over-slf4j-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jcl-over-slf4j-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jsse.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jta-1.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jta.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jul-to-slf4j-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jul-to-slf4j-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\junit-3.8.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\junit.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\localedata.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\log4j-over-slf4j-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\log4j-over-slf4j-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\log4j.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\management-agent.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ojdbc14.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ojdbc14_g.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\plugin.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\resources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\rt.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api-1.5.8.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-ext-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-ext-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jcl-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jcl-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jdk14-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jdk14-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-log4j12-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-log4j12-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-log4j12.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-migrator-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-nop-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-nop-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-simple-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-simple-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\sunjce_provider.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\sunmscapi.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\sunpkcs11.jar skipped - don't know how to handle it
[copy] Copy of hibernate.cfg.xml omitted as D:\rkp\workspace\AccountData\Copy of hibernate.cfg.xml is up to date.
[copy] accountdatapak\hibernate.cfg.xml omitted as D:\rkp\workspace\AccountData\accountdatapak\hibernate.cfg.xml is up to date.
[copy] build.xml omitted as D:\rkp\workspace\AccountData\build.xml is up to date.
[copy] hibernate.cfg.xml omitted as D:\rkp\workspace\AccountData\hibernate.cfg.xml is up to date.
[copy] No sources found.
Build sequence for target(s) `run' is [init, compile, run]
Complete build sequence is [init, compile, run, ]
init:
[mkdir] Skipping D:\rkp\workspace\AccountData because it already exists.
compile:
[javac] D:\rkp\workspace\AccountData\.classpath skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\.project skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\.settings\org.eclipse.jdt.core.prefs skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\Copy of hibernate.cfg.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\accountdatapak\AccountData.class skipped - don't know how to handle it
[javac] accountdatapak\AccountData.java omitted as D:\rkp\workspace\AccountData\accountdatapak\AccountData.class is up to date.
[javac] D:\rkp\workspace\AccountData\accountdatapak\HibernateUtil.class skipped - don't know how to handle it
[javac] accountdatapak\HibernateUtil.java omitted as D:\rkp\workspace\AccountData\accountdatapak\HibernateUtil.class is up to date.
[javac] D:\rkp\workspace\AccountData\accountdatapak\TestHiberNate.class skipped - don't know how to handle it
[javac] accountdatapak\TestHiberNate.java omitted as D:\rkp\workspace\AccountData\accountdatapak\TestHiberNate.class is up to date.
[javac] D:\rkp\workspace\AccountData\accountdatapak\hibernate.cfg.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\build.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\hibernate.cfg.xml skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\README.txt skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ant-contrib-1.0b2.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ant-junit-1.6.5.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\antlr-2.7.6.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\antlr.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\asm-attrs.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\asm.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\charsets.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\commons-collections-3.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\commons-collections.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\deploy.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\dnsns.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\dom4j-1.6.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\dom4j.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ejb3-persistence.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate-annotations.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate-commons-annotations.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate-core.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\hibernate3.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\javassist-3.9.0.GA.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\javassist.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\javaws.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jce.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jcl-over-slf4j-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jcl-over-slf4j-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jsse.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jta-1.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jta.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jul-to-slf4j-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\jul-to-slf4j-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\junit-3.8.1.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\junit.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\localedata.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\log4j-over-slf4j-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\log4j-over-slf4j-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\log4j.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\management-agent.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ojdbc14.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\ojdbc14_g.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\plugin.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\resources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\rt.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api-1.5.8.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-api.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-ext-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-ext-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jcl-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jcl-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jdk14-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-jdk14-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-log4j12-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-log4j12-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-log4j12.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-migrator-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-nop-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-nop-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-simple-1.5.11-sources.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\slf4j-simple-1.5.11.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\sunjce_provider.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\sunmscapi.jar skipped - don't know how to handle it
[javac] D:\rkp\workspace\AccountData\lib\sunpkcs11.jar skipped - don't know how to handle it
[copy] Copy of hibernate.cfg.xml omitted as D:\rkp\workspace\AccountData\Copy of hibernate.cfg.xml is up to date.
[copy] accountdatapak\hibernate.cfg.xml omitted as D:\rkp\workspace\AccountData\accountdatapak\hibernate.cfg.xml is up to date.
[copy] build.xml omitted as D:\rkp\workspace\AccountData\build.xml is up to date.
[copy] hibernate.cfg.xml omitted as D:\rkp\workspace\AccountData\hibernate.cfg.xml is up to date.
[copy] No sources found.
run:
Property "classpathref" has not been set
[echo] classpath= ${classpathref}
[echo] classpath= D:\rkp\workspace\AccountData\lib;D:\rkp\workspace\AccountData;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-antlr.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-apache-bcel.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-apache-bsf.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-apache-log4j.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-apache-oro.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-apache-regexp.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-apache-resolver.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-commons-logging.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-commons-net.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-jai.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-javamail.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-jdepend.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-jmf.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-jsch.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-junit.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-launcher.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-netrexx.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-nodeps.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-starteam.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-stylebook.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-swing.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-trax.jar;D:\Program Files\eclipse\plugins\org.apache.ant_1.7.1.v20090120-1145\lib\ant-weblogic.jar;D:\Program Files\eclipse\configuration\org.eclipse.osgi\bundles\699\1\.cp\lib\remoteAnt.jar;C:\Program Files\Java\jdk1.6.0_18\lib\tools.jar;D:\Program Files\eclipse\plugins\org.eclipse.swt.win32.win32.x86_3.5.1.v3555a.jar;D:\rkp\workspace\AccountData\lib\slf4j-simple-1.5.11.jar;D:\rkp\workspace\AccountData\lib\antlr-2.7.6.jar;D:\rkp\workspace\AccountData\lib\commons-collections-3.1.jar;D:\rkp\workspace\AccountData\lib\dom4j-1.6.1.jar;D:\rkp\workspace\AccountData\lib\javassist-3.9.0.GA.jar;D:\rkp\workspace\AccountData\lib\jta-1.1.jar;D:\rkp\workspace\AccountData\lib\slf4j-api-1.5.11.jar;D:\rkp\workspace\AccountData\lib\ejb3-persistence.jar;D:\rkp\workspace\AccountData\lib\hibernate-commons-annotations.jar;D:\rkp\workspace\AccountData\lib\hibernate-annotations.jar;D:\rkp\workspace\AccountData\lib\hibernate3.jar;D:\rkp\workspace\AccountData\lib\ojdbc14_g.jar;D:\rkp\workspace\AccountData\lib\ojdbc14.jar
[java] running accountdatapak.TestHiberNate with default permissions (exit forbidden)
[java] Running in same VM Executing 'accountdatapak.TestHiberNate'
[java] The ' characters around the executable and arguments are
[java] not part of the command.
[java] Before Query
[java] SLF4J: Class path contains multiple SLF4J bindings.
[java] SLF4J: Found binding in [jar:file:/D:/rkp/workspace/AccountData/lib/slf4j-simple-1.5.11.jar!/org/slf4j/impl/StaticLoggerBinder.class]
[java] SLF4J: Found binding in [jar:file:/D:/rkp/workspace/AccountData/lib/slf4j-simple-1.5.11.jar!/org/slf4j/impl/StaticLoggerBinder.class]
[java] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
[java] 15 [main] INFO org.hibernate.cfg.annotations.Version - Hibernate Annotations 3.4.0.GA
[java] 93 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.3.2.GA
[java] 93 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
[java] 125 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
[java] 156 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
[java] 546 [main] INFO org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.1.0.GA
[java] 562 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
[java] 562 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
[java] 968 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
[java] 984 [main] INFO org.hibernate.cfg.search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
[java] 1187 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: accountdatapak.AccountData
[java] 1406 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity accountdatapak.AccountData on table accountdata
[java] 1625 [main] INFO org.hibernate.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
[java] 1921 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
[java] 1921 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
[java] 1921 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
[java] 2156 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:xe
[java] 2156 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=admin, password=****}
[java] 4093 [main] INFO org.hibernate.cfg.SettingsFactory - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
[java] 4093 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0XE
[java] 4281 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.OracleDialect
[java] 4296 [main] WARN org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
[java] 4312 [main] WARN org.hibernate.dialect.OracleDialect - The OracleDialect dialect has been deprecated; use Oracle8iDialect instead
[java] 4328 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
[java] 4343 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[java] 4343 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
[java] 4343 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
[java] 4343 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
[java] 4359 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[java] 4390 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
[java] 4390 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
[java] 4390 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
[java] 4390 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
[java] 4390 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
[java] 4390 [main] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
[java] 4390 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
[java] 4390 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
[java] 4453 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
[java] 4453 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
[java] 4453 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
[java] 4453 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
[java] 4453 [main] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
[java] 4812 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
[java] 5765 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
[java] Before Query
[java] Hibernate: select accountdat0_.AccountHolder as AccountH7_0_ from accountdata accountdat0_
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Jyoti Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Rahul Deepak Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Ashwini Rahul Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Ashwini Rahul Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Ashwini Rahul Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] Ashwini Rahul Kulkarni
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
[java] null
[java] null
[java] HUF
[java] 0.0
[java] 0.0
[java] 0.0
BUILD SUCCESSFUL
Total time: 9 seconds

[/color]
Following is my annotated POJO class.



package accountdatapak;

import javax.persistence.Column;
import javax.persistence.Table;
import javax.persistence.Entity;
import javax.persistence.Id;
import java.util.Date;



@Entity
@Table(name = "accountdata")
public class AccountData {

public AccountData() {
}

@Id
@Column( name = "ReceiptNo")
String receiptNo ;

@Id
@Column( name = "Bank")
String bank;

@Id
@Column( name = "DepositAmt")
double depositAmount ;

@Id
@Column( name = "InterestRate")
double interestRate;

@Id
@Column( name = "MaturationAmt")
double maturationAmt ;

@Id
@Column( name = "MaturationDate")
Date maturationDate ;

@Id
@Column( name = "AccountHolder")
String accountHolder ;

public String getAccountHolder() {
return accountHolder;
}

public void setAccountHolder(String accountHolder) {
this.accountHolder = accountHolder;
}

public String getBank() {
return bank;
}

public void setBank(String bank) {
this.bank = bank;
}

public double getDepositAmount() {
return depositAmount;
}

public void setDepositAmount(double depositAmount) {
this.depositAmount = depositAmount;
}

public double getInterestRate() {
return interestRate;
}

public void setInterestRate(double interestRate) {
this.interestRate = interestRate;
}

public double getMaturationAmt() {
return maturationAmt;
}

public void setMaturationAmt(double maturationAmt) {
this.maturationAmt = maturationAmt;
}

public Date getMaturationDate() {
return maturationDate;
}

public void setMaturationDate(Date maturationDate) {
this.maturationDate = maturationDate;
}

public String getReceiptNo() {
return receiptNo;
}

public void setReceiptNo(String receiptNo) {
this.receiptNo = receiptNo;
}
}

Following is my main java class



package accountdatapak;

import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.Session;
import org.hibernate.Transaction;


public class TestHiberNate {


public static void main(String[] str) {
System.out.println("Before Query");
Session session = null;
try
{
SessionFactory sf = HibernateUtil.getSessionFactory();
session = sf.openSession();
Transaction tx = session.beginTransaction();
System.out.println("Before Query");
Query qry = session.createQuery("from accountdatapak.AccountData");
List cntctList = qry.list();
Object obj[] = cntctList.toArray();

for (int i = 0; i < obj.length; i++) {
AccountData ad = (AccountData) obj[i];
System.out.println();
System.out.println(ad.getReceiptNo());
System.out.println(ad.getBank());
System.out.println(ad.getAccountHolder());
System.out.println(ad.getDepositAmount());
System.out.println(ad.getInterestRate());
System.out.println(ad.getMaturationAmt());
}
tx.commit();
}
catch( Exception e)
{
e.printStackTrace();
}

finally
{
session.flush();
session.close();
}

}
}



Following my hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<property name="hibernate.connection.username">admin</property>
<property name="hibernate.connection.password">admin</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.current_session_context_class">thread</property>
<mapping class="accountdatapak.AccountData" />
</session-factory>
</hibernate-configuration>


Following is my oracle db types


SQL> describe accountdata;
Name Null? Type
----------------------------------------- -------- ----------------------------

RECEIPTNO VARCHAR2(50 CHAR)
BANK VARCHAR2(50 CHAR)
DEPOSITAMT FLOAT(126)
INTERESTRATE FLOAT(126)
MATURATIONAMT FLOAT(126)
MATURATIONDATE DATE
ACCOUNTHOLDER VARCHAR2(50 CHAR)


Please help me in finding why I am getting null or 0.0 instead of data.

Thanks ;


Top
 Profile  
 
 Post subject: Re: hibernate query returns null for data from table
PostPosted: Sat Mar 06, 2010 11:39 am 
Regular
Regular

Joined: Thu May 07, 2009 5:56 am
Posts: 94
Location: Toulouse, France
that's normal only accounHolder is displayed because your query returns only AccountHolder data:
select accountdat0_.AccountHolder as AccountH7_0_ from accountdata accountdat0_

I think this comes round because your entity has several @Id annotations (only one @Id is allowed if you not specify @IdClass)...if you want to do composite primary key find for @EmbeddedId and @Embeddable annotations.

_________________
everything should be made as simple as possible, but not simpler (AE)


Top
 Profile  
 
 Post subject: Re: hibernate query returns null for data from table
PostPosted: Sun Mar 07, 2010 12:28 pm 
Newbie

Joined: Sat Mar 06, 2010 7:50 am
Posts: 2
Thanks hallmit,

This helped me to solve the problem.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 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.