Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
- Internal Exception: java.sql.SQLException: Invalid state, the Connection object is closed.
- Error Code: 0
- Call: SELECT XXXXX FROM XXXXX
- bind => [/Home/Footer/]
- Query: ReadAllQuery(name="WWW.find" referenceClass=WWW sql="SELECT XXXXX FROM XXXXX")
- public List<WWW> find(String url) {
- }
- EntityManager em = getEntityManager();
- try {
- Query q = em.createNamedQuery("WWW.find");
- q.setParameter("url", url);
- return q.getResultList();
- } finally {
- em.close();
- }
- }
- <properties>
- <property name="javax.persistence.jdbc.password" value="password"/>
- <property name="javax.persistence.jdbc.user" value="user"/>
- <property name="javax.persistence.jdbc.driver" value="net.sourceforge.jtds.jdbc.Driver"/>
- <property name="javax.persistence.jdbc.url" value="jdbc:jtds:sqlserver://SERVER:1433/DB"/>
- <property name="eclipselink.ddl-generation" value="none"/>
- <property name="eclipselink.jdbc.timeout" value="20"/>
- <property name="eclipselink.jdbc.connections.wait-timeout" value="20"/>
- <property name="javax.persistence.query.timeout" value="20"/>
- <property name="eclipselink.allow-zero-id" value="true"/>
- </properties>
- public WWWWJpaController() {
- emf = Persistence.createEntityManagerFactory("properties");
- }
- public WWWWJpaController(String unitName) {
- emf = Persistence.createEntityManagerFactory(unitName);
- }
- private EntityManagerFactory emf = null;
- public EntityManager getEntityManager() {
- return emf.createEntityManager();
- }
- public List<WWW> find(String url) {
- EntityManager em = getEntityManager();
- try {
- Query q = em.createNamedQuery("WWW.find");
- q.setParameter("url", url);
- return q.getResultList();
- }finally{
- em.close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement