Invalid Oracle URL specified

[Former Member]

Hello all,

Is there a bug in SAP J2EE Engine regarding Invalid Oracle URL? This happened while I was doing context lookup.

localHome = (TicketLocalHome) icontext.lookup("java:comp/env/ejb/TicketBean");

Here's the trace:

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Exception in method com.pmis.ejb.TicketLocalHomeImpl0_0.findAll().
	at com.pmis.ejb.TicketLocalHomeImpl0_0.findAll(TicketLocalHomeImpl0_0.java:569)
	at com.pmis.ejb.TicketSessionBean.findAll(TicketSessionBean.java:64)
	at com.pmis.ejb.TicketSessionLocalLocalObjectImpl0_0.findAll(TicketSessionLocalLocalObjectImpl0_0.java:103)
	... 25 more
Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Can not obtain a JDBC connection
	at com.sap.engine.services.ejb.entity.pm.TransactionContext.simpleGetConnection(TransactionContext.java:198)
	at com.sap.engine.services.ejb.entity.pm.TransactionContext.getConnection(TransactionContext.java:278)
	at com.sap.engine.services.ejb.entity.pm.PersistenceManager.getConnectionForFindMethod(PersistenceManager.java:345)
	at com.pmis.ejb.TicketBean0_0PM.ejbFindAll(TicketBean0_0PM.java:424)
	at com.pmis.ejb.TicketLocalHomeImpl0_0.findAll(TicketLocalHomeImpl0_0.java:541)
	... 27 more
Caused by: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Invalid Oracle URL specified
	at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:59)
	at com.sap.engine.services.ejb.entity.pm.PersistenceManager.getConnection(PersistenceManager.java:261)
	at com.sap.engine.services.ejb.entity.pm.TransactionContext.simpleGetConnection(TransactionContext.java:191)
	... 31 more
Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Invalid Oracle URL specified

I guess there are two things here:

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Can not obtain a JDBC connection

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Invalid Oracle URL specified

[Vlado · Accepted solution]

Seems like your data source is not configured properly. I believe there should be more details in the nested SQLException thrown by the Oracle driver. Alternatively, please double check the connection URL of your data source.

HTH!

-- Vladimir

P.S. Moving this thread to the NW AS Java forum as it obviously concerns 6.40 or 7.0 release.

[Former Member · Accepted solution]

Much appreciated Vladimir.