Resolution:
Description:
============
Using oracle.getConnection() API getting java.lang.NullPointerException when Business Event (BE)  engine is started up.

Environment:
==========
BE 3.0.1 All platforms; Oracle 10.x for database.

Symptoms:
==========
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] - java.lang.NullPointerException
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.be.oracle.impl.OracleConnectionCache.getConnection(OracleConnectionCache.java:74)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.be.oracle.functions.OracleCustomFunctions.getConnectionWithTimeout(OracleCustomFunctions.java:117)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.be.oracle.functions.OracleCustomFunctions.getConnection(OracleCustomFunctions.java:106)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at be.gen.Rules.RF.nullinit$.init(nullinit$.java:21)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at be.gen.BusinessEvents$0020Archive.BE$$Actions$Startup.execute(BE$$Actions.java:12)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.kernel.core.rete.ReteWM.invoke(ReteWM.java:384)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.kernel.core.rete.ReteWM.start(ReteWM.java:166)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.runtime.session.impl.RuleSessionImpl.start(RuleSessionImpl.java:284)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.runtime.session.impl.RuleSessionManagerImpl.start(RuleSessionManagerImpl.java:238)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.startAll(RuleServiceProviderImpl.java:823)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.configure(RuleServiceProviderImpl.java:190)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.container.standalone.BEMain.jumpStart(BEMain.java:132)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com Error [main] -     at com.tibco.cep.container.standalone.BEMain.main(BEMain.java:45)
2010 May 07 18:04:11:813 GMT +8 apandian-nb.apac.tibco.com User [main] - [BusinessEvents Archive] ### An exception occurred in retrieving the DB data java.lang.RuntimeException: java.lang.NullPointerException

Note, testing JDBC connection in Designer works.

Resolution:
============
Make sure you are using the correct version of the ojdbc14.jar file (10.2.0.4)

In tnsnames.ora change (ADDRESS = (PROTOCOL = TCP)(HOST = IP_Address)(PORT = 1521) change IP address to host_name.

Business Event (BE) 3.0.1-java.lang.NullPointerException while using oracle.getConnection() API for JDBC connection.