nimesh hindocha

Greenhorn
+ Follow
since Aug 11, 2010
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by nimesh hindocha

Hi vijitha,
I have kept hibernate.cfg.xml file as said by you but i am getting the same exception again and i am giving server.xml file might be needed .I have attached the project structure and i am using eclipse.


I am waiting for your reply....
Thanks Vijitha for your reply.
I wanted to know if i keep hibernate.cfg.xml file directly inside the WEB-INF/classes do i have to write context path in server.xml file and i would also like to know second approach which you have mentioned


if you use in a real application you might bind the hibernate service to JNDI in the server startup, initialized in a listener etc...



again thanks for reply...
Hi,
I have understood the problem but i am unable to fix it..so anybody can help please.
Hi,
How to configure when the application is deployed because apache tomcat looks in deployment descriptor that is web.xml.

so how i can direct it to hibernate.cfg.xml file from web.xml for configuration.

below is my configuration file. Please give some way.

org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:80)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:62)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at mypack.PdServlet.init(PdServlet.java:35)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at mypack.PdServlet.doPost(PdServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

nimesh hindocha wrote:Hi
I want to know how to do hibernate configuration in this servlet based hibernate application.

Hi
I want to know how to do hibernate configuration in this servlet based hibernate application.
Hi friends,
I am getting following exception and my cde is as given below.please any one could help to locate the fault.

org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:80)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:62)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at mypack.PdServlet.init(PdServlet.java:35)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at mypack.PdServlet.doPost(PdServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)



Thanks..
Hi Guys,
I want to write delete query for below code please any one could help,i am new to hibernate.




Thanks in advance.
Hi Paul,
Now i am able to configure but exception is thrown while query execution.Below is exception
inside try
16 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.3.0.SP1
32 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
32 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
32 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
110 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
110 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
204 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : Employee.hbm.xml
297 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: Employee -> emp1234
329 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
391 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
391 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
391 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
500 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.ibm.db2.jcc.DB2Driver at URL: jdbc:db2:emp1234
500 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=nimesh.hindocha, password=****}
3329 [main] INFO org.hibernate.cfg.SettingsFactory - RDBMS: DB2/NT, version: SQL09071
3329 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 3.4.65
3375 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.DB2Dialect
3375 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
3375 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
3375 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
3375 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
3375 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
3391 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
3391 [main] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
3438 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
3672 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
after configure
Hibernate: select employee0_.eid as eid0_, employee0_.ename as ename0_, employee0_.esal as esal0_ from emp1234 employee0_
4204 [main] WARN org.hibernate.jdbc.AbstractBatcher - exception clearing maxRows/queryTimeout
com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10120][10943] Invalid operation: statement is closed.
at com.ibm.db2.jcc.b.hh.A(hh.java:2416)
at com.ibm.db2.jcc.b.hh.getMaxRows(hh.java:615)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1822)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at ViewEmployees.main(ViewEmployees.java:27)
4204 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: -4499, SQLState: 58009
4204 [main] ERROR org.hibernate.util.JDBCExceptionReporter - [ibm][db2][jcc][t4][2034][11148] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected. Reason: 0x1.
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at ViewEmployees.main(ViewEmployees.java:27)
Caused by: com.ibm.db2.jcc.b.DisconnectException: [ibm][db2][jcc][t4][2034][11148] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected. Reason: 0x1.
at com.ibm.db2.jcc.c.ab.l(ab.java:931)
at com.ibm.db2.jcc.c.ab.c(ab.java:365)
at com.ibm.db2.jcc.c.ab.v(ab.java:1134)
at com.ibm.db2.jcc.c.db.b(db.java:81)
at com.ibm.db2.jcc.c.t.b(t.java:71)
at com.ibm.db2.jcc.c.tb.c(tb.java:225)
at com.ibm.db2.jcc.b.ih.bb(ih.java:1921)
at com.ibm.db2.jcc.b.ih.eb(ih.java:1998)
at com.ibm.db2.jcc.b.ih.d(ih.java:2439)
at com.ibm.db2.jcc.b.ih.V(ih.java:492)
at com.ibm.db2.jcc.b.ih.executeQuery(ih.java:475)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 8 more
in catch blk



Please do reply paul......i am looking for you.
Hi Paul,
Exception in thread "main" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory
at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:151)
at ViewEmployees.main(ViewEmployees.java:22)
Caused by: java.lang.ClassNotFoundException: org.slf4j.LoggerFactory
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
... 2 more
Hi Paul,
Exception in thread "main" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory
at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:151)
at ViewEmployees.main(ViewEmployees.java:22)
Caused by: java.lang.ClassNotFoundException: org.slf4j.LoggerFactory
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
... 2 more
Hi Paul,
I am sending the image of project structure i hope this might help to solve the problem.

Hi Paul,
Problem is due to exception thrown class files are not generated.
Hi Paul,
I have put my configuration file in src folder as said by you but same problem remains.
Any other solution please do specify.