[schanamolu]

Hi,

I’m still getting the following error message. “Connections could not be acquired from the underlying database!”

The detail exception is as follow

“Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!”

ApplicationContext.xml

<property name=”jdbcUrl”>
<value>
jdbc:oracle:oci:@${jdbc.host}:${jdbc.port}:${jdbc.database}
</value>
</property>

startup.bat

We modified startup.bat in tomcat/bin directory

@echo off
if “%OS%” == “Windows_NT” setlocal
rem —————————————————————————
rem Start script for the CATALINA Server
rem
rem $Id: startup.bat 302918 2004-05-27 18:25:11Z yoavs $
rem —————————————————————————

set CATALINA_OPTS=-Djava.library.path=E:\oracle\ora92\bin

rem Guess CATALINA_HOME if not defined
set CURRENT_DIR=%cd%
if not “%CATALINA_HOME%” == “” goto gotHome
set CATALINA_HOME=%CURRENT_DIR%

………………………

Enviornemnt Variable changes:

we referenced ocijdbc9.dll library by setting path enviornment variable ORALCE_HOME/bin

We copied ojbdc14.jar to this directory C:\tomcat\shared\lib

Any help would be appreicated as Iam kind of exhausted with this exception for last one month

Thanks,
Sreedhar

[Loyal Water]

Moving to Off Topic >> Software Development.

[Author]

Posts