API tools faq
paste
Guest User

Untitled

a guest
Apr 2nd, 2018
144
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.30 KB | None | 0 0
raw download clone embed print report
  1. <!-- hibernate dialect -->
  2. <property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
  3. <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
  4. <property name="hibernate.connection.url">jdbc:oracle:thin:@10.123.79.59:1521:georli04</property>
  5. <property name="hibernate.connection.username">username</property>
  6. <property name="hibernate.connection.password">password</property>
  7. <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
  8.  
  9. <!-- Automatic schema creation (begin) === -->
  10. <property name="hibernate.hbm2ddl.auto">none</property>
  11.  
  12. <!-- Simple memory-only cache -->
  13. <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
  14.  
  15. <!-- Enable Hibernate's automatic session context management -->
  16. <property name="current_session_context_class">thread</property>
  17.  
  18. <mapping class="com.infy.entity.StudentEntity"/>
  19. <mapping class="com.infy.entity.CourseEntity"/>
  20.  
  21. public class StudentDAOImpl implements StudentDAO {
  22.  
  23. public Student getStudentDetails(String studentId) throws Exception {
  24. SessionFactory sessionFactory = null;
  25. Session session = null;
  26. Student student = null;
  27.  
  28. try {
  29. sessionFactory = HibernateUtility.createSessionFactory();
  30. session = sessionFactory.openSession();
  31. StudentEntity se = (StudentEntity) session.get(StudentEntity.class,
  32. studentId);
  33. if (se != null) {
  34. student = new Student();
  35. student.setStudentId(se.getStudentId());
  36. student.setDateOfBirth(se.getDateOfBirth());
  37. System.out.println(se.getDateOfBirth());
  38. student.setStudentName(se.getStudentName());
  39. System.out.println(se.getStudentName());
  40. student.setBranch(se.getBranch());
  41. student.setSem(se.getSem());
  42. student.setEmail(se.getEmail());
  43. }
  44. } catch (HibernateException exception) {
  45. exception.printStackTrace();
  46. DOMConfigurator.configure("src/resources/log4j.xml");
  47. Logger logger = Logger.getLogger(this.getClass());
  48. logger.error(exception.getMessage(), exception);
  49. throw new Exception("DAO.TECHNICAL_ERROR");
  50. } catch (Exception exception) {
  51. exception.printStackTrace();
  52. DOMConfigurator.configure("src/resources/log4j.xml");
  53. Logger logger = Logger.getLogger(this.getClass());
  54. logger.error(exception.getMessage(), exception);
  55. throw exception;
  56. } finally {
  57. if (session.isOpen() || session != null) {
  58. session.close();
  59. }
  60. }
  61. return student;
  62. }
  63.  
  64. @SuppressWarnings("unchecked")
  65. public List<Course> getCourses(int semester) throws Exception {
  66. SessionFactory sessionFactory = HibernateUtility.createSessionFactory();
  67. Session session = null;
  68. List<CourseEntity> courseEntities = new LinkedList<CourseEntity>();
  69. List<Course> courses = new LinkedList<Course>();
  70.  
  71. String hql = "from CourseEntity ce where ce.semester='" + semester
  72. + "'";
  73.  
  74. try {
  75. System.out.println("before session");
  76.  
  77. session = sessionFactory.openSession();
  78. System.out.println("after session");
  79. Query q = session.createQuery(hql);
  80.  
  81. courseEntities = q.list();
  82.  
  83. if (courseEntities.isEmpty())
  84. System.out.println("empty");
  85. for (CourseEntity i : courseEntities) {
  86. Course course = new Course();
  87. course.setCourseId(i.getCourseId());
  88. course.setCourseName(i.getCourseName());
  89. course.setCourseType(i.getCourseType());
  90. course.setSemester(i.getSemester());
  91. course.setBranch(i.getBranch());
  92. courses.add(course);
  93. }
  94.  
  95. } catch (HibernateException exception) {
  96. exception.printStackTrace();
  97. DOMConfigurator.configure("src/resources/log4j.xml");
  98. Logger logger = Logger.getLogger(this.getClass());
  99. logger.error(exception.getMessage(), exception);
  100. throw new Exception("DAO.TECHNICAL_ERROR");
  101. } catch (Exception exception) {
  102. exception.printStackTrace();
  103. DOMConfigurator.configure("src/resources/log4j.xml");
  104. Logger logger = Logger.getLogger(this.getClass());
  105. logger.error(exception.getMessage(), exception);
  106. throw exception;
  107. }finally {
  108. if (session.isOpen() || session != null)
  109. session.close();
  110. }
  111. return courses;
  112. }
  113.  
  114. org.hibernate.service.UnknownServiceException: Unknown service requested [org.hibernate.engine.jdbc.connections.spi.ConnectionProvider]
  115. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:201)
  116. at org.hibernate.internal.AbstractSessionImpl.getJdbcConnectionAccess(AbstractSessionImpl.java:341)
  117. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.<init>(JdbcCoordinatorImpl.java:114)
  118. at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.<init>(TransactionCoordinatorImpl.java:89)
  119. at org.hibernate.internal.SessionImpl.<init>(SessionImpl.java:258)
  120. at org.hibernate.internal.SessionFactoryImpl$SessionBuilderImpl.openSession(SessionFactoryImpl.java:1589)
  121. at org.hibernate.internal.SessionFactoryImpl.openSession(SessionFactoryImpl.java:999)
  122. at com.infy.dao.StudentDAOImpl.getCourses(StudentDAOImpl.java:74)
  123. at com.infy.service.StudentServiceImpl.getListOfCourses(StudentServiceImpl.java:73)
  124. at com.infy.api.RegistrationAPI.getCoursesList(RegistrationAPI.java:38)
  125. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  126. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  127. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  128. at java.lang.reflect.Method.invoke(Unknown Source)
  129. at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
  130. at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
  131. at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
  132. at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
  133. at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
  134. at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
  135. at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
  136. at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
  137. at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:317)
  138. at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
  139. at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
  140. at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
  141. at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
  142. at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
  143. at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
  144. at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:298)
  145. at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
  146. at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:471)
  147. at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:425)
  148. at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:383)
  149. at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:336)
  150. at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:223)
  151. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  152. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  153. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  154. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  155. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  156. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  157. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  158. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  159. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  160. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  161. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
  162. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  163. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  164. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  165. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
  166. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  167. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  168. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  169. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  170. at java.lang.Thread.run(Unknown Source)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!