Two db connections using ejb, java persistence entitymanager

Question

I am am tryign to access two dbs via one slsb, specifically one method within an slsb. However this is not possible ? Other than altering the stored procs is there anything else I could do ?

@PersistenceContext(unitName = "DB1")
private EntityManager oneEntityManager;

@PersistenceContext(unitName = "DB2")
private EntityManager twoEntityManager;

...


    StringBuilder queryString1 = new StringBuilder("exec myProc1 ");
    Query queryOne = oneEntityManager.createNativeQuery(queryString.toString());
    List<?> resultListOne = query.getResultList();

    StringBuilder queryString2 = new StringBuilder("exec myProc2 ");
    Query queryTwo = twoEntityManager.createNativeQuery(queryString2.toString());
    List<?> resultListTwo = queryTwo.getResultList();

...

causes : org.hibernate.exception.GenericJDBCException: Cannot open connection

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629) — NimChimpsky
– NimChimpsky, Commented Jul 5, 2010 at 14:19

Pascal Thivent · Accepted Answer · 2010-07-06 16:23:00Z

1

I am am tryign to access two dbs via one slsb, specifically one method within an slsb. However this is not possible?

This is definitely possible but it would really help to give more details:

are you accessing different databases?
can you show the configuration of your persistence units?
can you tell us how your configured your datasource (XA?)
can you show how you annotated the method of your SLSB?

causes : org.hibernate.exception.GenericJDBCException: Cannot open connection

This suggests a configuration problem for one of your persistence unit but it's impossible to say more.

answered Jul 6, 2010 at 16:23

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Two db connections using ejb, java persistence entitymanager

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related