Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
  2. Internal Exception: java.sql.SQLException: Invalid state, the Connection object is closed.
  3. Error Code: 0
  4. Call: SELECT XXXXX FROM XXXXX
  5. bind => [/Home/Footer/]
  6. Query: ReadAllQuery(name="WWW.find" referenceClass=WWW sql="SELECT XXXXX FROM XXXXX")
  7.  
  8. public List<WWW> find(String url) {
  9. }
  10. EntityManager em = getEntityManager();
  11. try {
  12. Query q = em.createNamedQuery("WWW.find");
  13. q.setParameter("url", url);
  14. return q.getResultList();
  15. } finally {
  16. em.close();
  17. }
  18. }
  19.  
  20. <properties>
  21. <property name="javax.persistence.jdbc.password" value="password"/>
  22. <property name="javax.persistence.jdbc.user" value="user"/>
  23. <property name="javax.persistence.jdbc.driver" value="net.sourceforge.jtds.jdbc.Driver"/>
  24. <property name="javax.persistence.jdbc.url" value="jdbc:jtds:sqlserver://SERVER:1433/DB"/>
  25. <property name="eclipselink.ddl-generation" value="none"/>
  26. <property name="eclipselink.jdbc.timeout" value="20"/>
  27. <property name="eclipselink.jdbc.connections.wait-timeout" value="20"/>
  28. <property name="javax.persistence.query.timeout" value="20"/>
  29. <property name="eclipselink.allow-zero-id" value="true"/>
  30. </properties>
  31.  
  32. public WWWWJpaController() {
  33. emf = Persistence.createEntityManagerFactory("properties");
  34. }
  35.  
  36. public WWWWJpaController(String unitName) {
  37. emf = Persistence.createEntityManagerFactory(unitName);
  38. }
  39.  
  40. private EntityManagerFactory emf = null;
  41.  
  42. public EntityManager getEntityManager() {
  43. return emf.createEntityManager();
  44. }
  45.  
  46. public List<WWW> find(String url) {
  47. EntityManager em = getEntityManager();
  48. try {
  49. Query q = em.createNamedQuery("WWW.find");
  50. q.setParameter("url", url);
  51. return q.getResultList();
  52. }finally{
  53. em.close();
  54. }
  55. }
  56.  
  57. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement