PDA

View Full Version : When I am trying to connect Groovy Application with Oracle11gR2



gautammaji
13-12-2011, 03:55 PM
While trying to connect Groovy Application (Grails framework) with Oracle11gR2 I am getting the following Error:


Caused by: org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessExc eption: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionEx ception: Could not get JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

Groovy Application and Oracle 11gR2 are installed on seperat servers.


The configuration set in Datasource.groovy file is given below:

dataSource {
dialect = "org.hibernate.dialect.OracleDialect"
driverClassName = "oracle.jdbc.driver.OracleDriver"
username = "oracle"
password = "Independent12#"
url = "jdbc:oracle:thin:@host IP:1521:test_db"

pooled = true
configClass = GrailsAnnotationConfiguration.class
dbCreate = "none"
}

And set in environment variable is given below:


export JAVA_HOME=/usr/java/jdk1.7.0_01
export GRAILS_HOME=/home/administrator/grails-1.3.4
export CLASS_PATH=/home/administrator/Downloads/Billing_proj/lib/ojdbc14.jar;$GRAILS_HOME/lib;$JAVA_HOME/lib
PATH=$PATH:$GRAILS_HOME/bin
PATH=$PATH:$HOME/bin
export PATH


Please help me out.

Thanks