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

Source: Internet
Author: User
Tags grails

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"

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.