Cannot create PoolableConnectionFactory (ORA-00923: 未找到预期 FROM 关键字
来源:互联网 发布:淘宝店铺宝贝被删除 编辑:程序博客网 时间:2024/05/18 02:01
经检查是数据库连接池配置错误(content.xml)!
配置SQL Server 2000数据库连接池时,属性validationQuery默认值为“select 1”,
而在Oracle数据库连接池中应设置为“validationQuery="select 1 from dual"”
SQL Server 2000数据库连接池配置:
- <Context>
- <Resource
- name="jdbc/myOracle"
- type="javax.sql.DataSource"
- username="test"
- password="test"
- driverClassName="oracle.jdbc.driver.OracleDriver"
- maxIdle="5"
- maxWait="5000"
- validationQuery="select 1"
- url="jdbc:oracle:thin:@192.168.1.1:1521:mydb"
- maxActive="20"
- />
- </Context>
Oracle数据库连接池配置:
- <Context>
- <Resource
- name="jdbc/myOracle"
- type="javax.sql.DataSource"
- username="test"
- password="test"
- driverClassName="oracle.jdbc.driver.OracleDriver"
- maxIdle="5"
- maxWait="5000"
- validationQuery="select 1 from dual"
- url="jdbc:oracle:thin:@192.168.1.1:1521:mydb"
- maxActive="20"
- />
- </Context>
0 0
- Cannot create PoolableConnectionFactory (ORA-00923: 未找到预期 FROM 关键字
- Cannot create PoolableConnectionFactory (ORA-00923: 未找到预期 FROM 关键字
- tomcat:Cannot create PoolableConnectionFactory (ORA-00923: 未找到要求的 FROM 关键字)
- spring+mybatis+oracle ORA-00923: 未找到预期 FROM 关键字
- ORA-00923: 未找到要求的 FROM 关键字
- ORA-00923: 未找到要求的 FROM 关键字
- ORA-00923: 未找到要求的 FROM 关键字
- oracle oracle中ORA-00923: 未找到要求的 FROM 关键字
- Oracle-ORA-00923: 未找到要求的FROM关键字-Oracle不支持TOP N查询
- Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
- Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication protocol
- Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication protocol
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- cannot create poolableconnectionfactory mysqlDataSource
- jsp:useBean简单使用方法以及范例
- pycharm +scrapy 运行报错:[twisted] CRITICAL: Unhandled error in Deferred
- 直播+时尚跨界掀起新玩法,传统时装行业变革在即
- PAT甲级 1002
- mysql 动态创建表、添加数据
- Cannot create PoolableConnectionFactory (ORA-00923: 未找到预期 FROM 关键字
- Android 闹钟小Dome
- 通过chrome来查看android数据库(Facebook推出的Stetho)
- Android:25种开源炫酷动画框架
- (转)当传统的分析框架遇见智能投顾——以两家独立智投为例
- 大数阶乘
- Flying to the Mars hdu1800 字典树
- POJ 1556
- c语言小程序——最终匹配