Tomcat: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found)

19:09:00, 546 [localhost-startStop-1] Error context. grailscontextloader-error initializing the application: Error creating bean with name 'transact
Ionmanagerpostprocessor ': initialization of bean failed; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with N
Ame 'transactionmanager': cannot resolve reference to bean 'sessionfactory 'while setting bean property 'sessionfactory'; Nested exception is org. springframewor
K. Beans. Factory. beancreationexception: Error creating bean with name 'sessionfactory': cannot resolve reference to bean 'lobhandlerdetector' while setting Bean
Property 'lobhandler'; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': invocatati
On of init method failed; Nested exception is org. springframework. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested effectio
N is org. Apache. commons. DBCP. sqlnestedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
Org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'transactionmanagerpostprocessor ': initialization of bean failed; Nested
Exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'transactionmanager': cannot resolve reference to bean' sess
Ionfactory 'while setting bean property 'sessionfactory '; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean
Name 'sessionfactory ': cannot resolve reference to bean 'lobhandlerdetector' while setting bean property 'lobhandler'; Nested exception is org. springframework. B
Eans. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': Invocation of init method failed; Nested exception is org. springframewor
K. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. sqlnestedexception: cannot create P
Oolableconnectionfactory (ORA-00923: requested from keyword not found
)
At java. util. Concurrent. executors $ runnableadapter. Call (executors. Java: 441)
At java. util. Concurrent. futuretask $ sync. innerrun (futuretask. Java: 303)
At java. util. Concurrent. futuretask. Run (futuretask. Java: 138)
At java. util. Concurrent. threadpoolexecutor $ worker. runtask (threadpoolexecutor. Java: 886)
At java. util. Concurrent. threadpoolexecutor $ worker. Run (threadpoolexecutor. Java: 908)
At java. Lang. thread. Run (thread. Java: 662)
Caused by: org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'transactionmanager': cannot resolve reference to bean 'sessio
Nfactory 'while setting bean property 'sessionfactory '; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with Na
Me 'sessionfactory ': cannot resolve reference to bean 'lobhandlerdetector' while setting bean property 'lobhandler'; Nested exception is org. springframework. Bea
NS. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': Invocation of init method failed; Nested exception is org. springframework.
JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. sqlnestedexception: cannot create poo
Lableconnectionfactory (ORA-00923: requested from keyword not found
)
... 6 more
Caused by: org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'sessionfactory ': cannot resolve reference to bean 'lobhandler
Detector 'while setting bean property 'lobhandler'; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with name'
Lobhandlerdetector ': Invocation of init method failed; Nested exception is org. springframework. JDBC. Support. metadataaccessexception: Error while extracting data
Basemetadata; Nested exception is org. Apache. commons. DBCP. sqlnestedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
... 6 more
Caused by: org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': Invocation of init method failed; Nested
Exception is org. springframework. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. SQL
Nestedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
... 6 more
Caused by: org. springframework. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. sqlnes
Tedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
... 6 more
Caused by: org. Apache. commons. DBCP. sqlnestedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
At org. Apache. commons. DBCP. basicdatasource. createpoolableconnectionfactory (basicdatasource. Java: 1549)
At org. Apache. commons. DBCP. basicdatasource. createdatasource (basicdatasource. Java: 1388)
At org. Apache. commons. DBCP. basicdatasource. getconnection (basicdatasource. Java: 1044)
... 6 more
Caused by: Java. SQL. sqlsyntaxerrorexception: ORA-00923: requested from keyword not found

At oracle. JDBC. Driver. t4cttioer. processerror (t4cttioer. Java: 445)
At oracle. JDBC. Driver. t4cttioer. processerror (t4cttioer. Java: 396)
At oracle. JDBC. Driver. t4c8oall. processerror (t4c8oall. Java: 879)
At oracle. JDBC. Driver. t4cttifun. Receive (t4cttifun. Java: 450)
At oracle. JDBC. Driver. t4cttifun. dorpc (t4cttifun. Java: 192)
At oracle. JDBC. Driver. t4c8oall. dooall (t4c8oall. Java: 531)
At oracle. JDBC. Driver. t4cstatement. dooall8 (t4cstatement. Java: 193)
At oracle.jdbc.driver.t4cstatement.exe cutefordescribe (t4cstatement. Java: 873)
At oracle.jdbc.driver.oraclestatement.exe cutemaybedescribe (oraclestatement. Java: 1167)
At oracle. JDBC. Driver. oraclestatement. doexecutewithtimeout (oraclestatement. Java: 1289)
At oracle.jdbc.driver.oraclestatement.exe cutequery (oraclestatement. Java: 1491)
At oracle.jdbc.driver.oraclestatementwrapper.exe cutequery (oraclestatementwrapper. Java: 406)
At org.apache.commons.dbcp.delegatingstatement.exe cutequery (delegatingstatement. Java: 208)
At org. Apache. commons. DBCP. poolableconnectionfactory. validateconnection (poolableconnectionfactory. Java: 658)
At org. Apache. commons. DBCP. basicdatasource. validateconnectionfactory (basicdatasource. Java: 1558)
At org. Apache. commons. DBCP. basicdatasource. createpoolableconnectionfactory (basicdatasource. Java: 1545)
... 8 more
19:09:00, 609 [localhost-startStop-1] Error context. grailscontextloader-error initializing grails: Error creating bean with name 'transactionmanage
Rpostprocessor ': initialization of bean failed; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with name' tran
Sactionmanager ': cannot resolve reference to bean 'sessionfactory' while setting bean property 'sessionfactory '; Nested exception is org. springframework. Beans. f
Acloud. beancreationexception: Error creating bean with name 'sessionfactory ': cannot resolve reference to bean 'lobhandlerdetector' while setting bean Property
'Lobhandler'; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': Invocation of ini
T method failed; Nested exception is org. springframework. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is Org.
Apache. commons. DBCP. sqlnestedexception: cannot create poolableconnectionfactory (ORA-00923: requested from keyword not found
)
Org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'transactionmanagerpostprocessor ': initialization of bean failed; Nested
Exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'transactionmanager': cannot resolve reference to bean' sess
Ionfactory 'while setting bean property 'sessionfactory '; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean
Name 'sessionfactory ': cannot resolve reference to bean 'lobhandlerdetector' while setting bean property 'lobhandler'; Nested exception is org. springframework. B
Eans. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': Invocation of init method failed; Nested exception is org. springframewor
K. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. sqlnestedexception: cannot create P
Oolableconnectionfactory (ORA-00923: requested from keyword not found
)
At java. util. Concurrent. executors $ runnableadapter. Call (executors. Java: 441)
At java. util. Concurrent. futuretask $ sync. innerrun (futuretask. Java: 303)
At java. util. Concurrent. futuretask. Run (futuretask. Java: 138)
At java. util. Concurrent. threadpoolexecutor $ worker. runtask (threadpoolexecutor. Java: 886)
At java. util. Concurrent. threadpoolexecutor $ worker. Run (threadpoolexecutor. Java: 908)
At java. Lang. thread. Run (thread. Java: 662)
Caused by: org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'transactionmanager': cannot resolve reference to bean 'sessio
Nfactory 'while setting bean property 'sessionfactory '; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with Na
Me 'sessionfactory ': cannot resolve reference to bean 'lobhandlerdetector' while setting bean property 'lobhandler'; Nested exception is org. springframework. Bea
NS. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': Invocation of init method failed; Nested exception is org. springframework.
JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. sqlnestedexception: cannot create poo
Lableconnectionfactory (ORA-00923: requested from keyword not found
)
... 6 more
Caused by: org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'sessionfactory ': cannot resolve reference to bean 'lobhandler
Detector 'while setting bean property 'lobhandler'; Nested exception is org. springframework. Beans. Factory. beancreationexception: Error creating bean with name'
Lobhandlerdetector ': Invocation of init method failed; Nested exception is org. springframework. JDBC. Support. metadataaccessexception: Error while extracting data
Basemetadata; Nested exception is org. Apache. commons. DBCP. sqlnestedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
... 6 more
Caused by: org. springframework. Beans. Factory. beancreationexception: Error creating bean with name 'lobhandlerdetector': Invocation of init method failed; Nested
Exception is org. springframework. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. SQL
Nestedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
... 6 more
Caused by: org. springframework. JDBC. Support. metadataaccessexception: Error while extracting databasemetadata; Nested exception is org. Apache. commons. DBCP. sqlnes
Tedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
... 6 more
Caused by: org. Apache. commons. DBCP. sqlnestedexception: cannot create poolableconnectionfactory (ORA-00923: the requested from keyword is not found
)
At org. Apache. commons. DBCP. basicdatasource. createpoolableconnectionfactory (basicdatasource. Java: 1549)
At org. Apache. commons. DBCP. basicdatasource. createdatasource (basicdatasource. Java: 1388)
At org. Apache. commons. DBCP. basicdatasource. getconnection (basicdatasource. Java: 1044)
... 6 more
Caused by: Java. SQL. sqlsyntaxerrorexception: ORA-00923: requested from keyword not found

At oracle. JDBC. Driver. t4cttioer. processerror (t4cttioer. Java: 445)
At oracle. JDBC. Driver. t4cttioer. processerror (t4cttioer. Java: 396)
At oracle. JDBC. Driver. t4c8oall. processerror (t4c8oall. Java: 879)
At oracle. JDBC. Driver. t4cttifun. Receive (t4cttifun. Java: 450)
At oracle. JDBC. Driver. t4cttifun. dorpc (t4cttifun. Java: 192)
At oracle. JDBC. Driver. t4c8oall. dooall (t4c8oall. Java: 531)
At oracle. JDBC. Driver. t4cstatement. dooall8 (t4cstatement. Java: 193)
At oracle.jdbc.driver.t4cstatement.exe cutefordescribe (t4cstatement. Java: 873)
At oracle.jdbc.driver.oraclestatement.exe cutemaybedescribe (oraclestatement. Java: 1167)
At oracle. JDBC. Driver. oraclestatement. doexecutewithtimeout (oraclestatement. Java: 1289)
At oracle.jdbc.driver.oraclestatement.exe cutequery (oraclestatement. Java: 1491)
At oracle.jdbc.driver.oraclestatementwrapper.exe cutequery (oraclestatementwrapper. Java: 406)
At org.apache.commons.dbcp.delegatingstatement.exe cutequery (delegatingstatement. Java: 208)
At org. Apache. commons. DBCP. poolableconnectionfactory. validateconnection (poolableconnectionfactory. Java: 658)
At org. Apache. commons. DBCP. basicdatasource. validateconnectionfactory (basicdatasource. Java: 1558)
At org. Apache. commons. DBCP. basicdatasource. createpoolableconnectionfactory (basicdatasource. Java: 1545)
... 8 more
Started 19:09:00 org. Apache. Catalina. Core. standardcontext startinternal
Severe: Error listenerstart
2013-7-18 19:09:00 org. Apache. Catalina. Core. standardcontext startinternal
Severe: context [/talentExchange-0.1] startup failed due to previous errors
Server shutdown 19:09:00 org. Apache. Catalina. loader. webappclassloader clearreferencesjdbc
Severe: the Web application [/talentExchange-0.1] registered the JDBC driver [Oracle. JDBC. oracledriver] but failed to unregister it when the web application was s
Topped. To prevent a memory leak, the JDBC driver has been forcibly unregistered.
2013-7-18 19:09:00 org. Apache. Catalina. loader. webappclassloader checkthreadlocalmapforleaks
Severe: the Web application [/talentExchange-0.1] created a threadlocal with key of Type [java. Lang. threadlocal] (value [java. Lang. threadlocal @ 4a25d5]) and a valu
E of Type [java. Lang. Class] (value [class oracle. SQL. anydatafactory]) but failed to remove it when the web application was stopped. threads are going to be Rene
Wed over time to try and avoid a probable memory leak.
2013-7-18 19:09:00 org. Apache. Catalina. loader. webappclassloader checkthreadlocalmapforleaks
Severe: the Web application [/talentExchange-0.1] created a threadlocal with key of Type [java. Lang. threadlocal] (value [java. Lang. threadlocal @ 1f9f663]) and a Val
Ue of Type [java. Lang. Class] (value [class oracle. SQL. typedescriptorfactory]) but failed to remove it when the web application was stopped. threads are going
Be renewed over time to try and avoid a probable memory leak.
19:09:00 org. Apache. Catalina. startup. hostconfig deploydirectory
Information: deploying web application directory e: \ apache-tomcat-7.0.29-windows-x86 \ apache-Tomcat-7.0.29 \ webapps \ docs
19:09:00 org. Apache. Catalina. startup. hostconfig deploydirectory
Information: deploying web application directory e: \ apache-tomcat-7.0.29-windows-x86 \ apache-Tomcat-7.0.29 \ webapps \ examples
19:09:00 org. Apache. Catalina. startup. hostconfig deploydirectory
Information: deploying web application directory e: \ apache-tomcat-7.0.29-windows-x86 \ apache-Tomcat-7.0.29 \ webapps \ host-Manager
19:09:01 org. Apache. Catalina. startup. hostconfig deploydirectory
Information: deploying web application directory e: \ apache-tomcat-7.0.29-windows-x86 \ apache-Tomcat-7.0.29 \ webapps \ Manager
19:09:01 org. Apache. Catalina. startup. hostconfig deploydirectory
Information: deploying web application directory e: \ apache-tomcat-7.0.29-windows-x86 \ apache-Tomcat-7.0.29 \ webapps \ Root
19:09:01 org. Apache. Coyote. abstractprotocol start
Information: Starting protocolhandler ["http-apr-8080"]
19:09:01 org. Apache. Coyote. abstractprotocol start
Information: Starting protocolhandler ["ajp-apr-8009"]
19:09:01 org. Apache. Catalina. startup. Catalina start

Information: server startup in 31872 MS

Grails: Change the validationquery = "select 1" of datasource to validationquery = "select 1 from dual"