有一套JSP连Mysql的网站。想改成连oracle。看连接方法是用的c3p0。。在WEB-INF下面的classes底下有个文件叫c3p0-config.xml
里面:<?xml version="1.0" encoding="UTF-8"?><c3p0-config>
<named-config name="userApp">
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/exam?useUnicode=true&characterEncoding=utf-8</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="acquireIncrement">2</property>
<property name="initialPoolSize">5</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">20</property>
<property name="maxStatements">100</property>
<property name="maxStatementsPerConnection">5</property>
<property name="testConnectionOnCheckin">true</property>
<property name="automaticTestTable">tm_test</property>
<property name="idleConnectionTestPeriod">18000</property>
<property name="maxIdleTime">25000</property>
<property name="testConnectionOnCheckout">true</property>
<user-overrides user="master-of-the-universe"></user-overrides>
</named-config>
</c3p0-config>
上网搜了把它改成了<?xml version="1.0" encoding="UTF-8"?><c3p0-config>
<named-config name="userApp">
<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="jdbcUrl">jdbc:oracle:thin:@localhost:1521:name</property>
<property name="user">scott</property>
<property name="password">tiger</property>
<property name="acquireIncrement">2</property>
<property name="initialPoolSize">5</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">20</property>
<property name="maxStatements">100</property>
<property name="maxStatementsPerConnection">5</property>
<property name="testConnectionOnCheckin">true</property>
<property name="automaticTestTable">tm_test</property>
<property name="idleConnectionTestPeriod">18000</property>
<property name="maxIdleTime">25000</property>
<property name="testConnectionOnCheckout">true</property>
<user-overrides user="master-of-the-universe"></user-overrides>
</named-config>
</c3p0-config>
之后还是连不上。刚学oracle。而且原来没用过这种连接方法,各位大侠帮帮忙啦,在线等……
里面:<?xml version="1.0" encoding="UTF-8"?><c3p0-config>
<named-config name="userApp">
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/exam?useUnicode=true&characterEncoding=utf-8</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="acquireIncrement">2</property>
<property name="initialPoolSize">5</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">20</property>
<property name="maxStatements">100</property>
<property name="maxStatementsPerConnection">5</property>
<property name="testConnectionOnCheckin">true</property>
<property name="automaticTestTable">tm_test</property>
<property name="idleConnectionTestPeriod">18000</property>
<property name="maxIdleTime">25000</property>
<property name="testConnectionOnCheckout">true</property>
<user-overrides user="master-of-the-universe"></user-overrides>
</named-config>
</c3p0-config>
上网搜了把它改成了<?xml version="1.0" encoding="UTF-8"?><c3p0-config>
<named-config name="userApp">
<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="jdbcUrl">jdbc:oracle:thin:@localhost:1521:name</property>
<property name="user">scott</property>
<property name="password">tiger</property>
<property name="acquireIncrement">2</property>
<property name="initialPoolSize">5</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">20</property>
<property name="maxStatements">100</property>
<property name="maxStatementsPerConnection">5</property>
<property name="testConnectionOnCheckin">true</property>
<property name="automaticTestTable">tm_test</property>
<property name="idleConnectionTestPeriod">18000</property>
<property name="maxIdleTime">25000</property>
<property name="testConnectionOnCheckout">true</property>
<user-overrides user="master-of-the-universe"></user-overrides>
</named-config>
</c3p0-config>
之后还是连不上。刚学oracle。而且原来没用过这种连接方法,各位大侠帮帮忙啦,在线等……
解决方案 »
- 10g rac添加节点报错Failed To Upgrade Oracle Cluster Registry Configuration When Runnin
- XP下的PLSQL Developer连接虚拟机Linux中的Oracle
- ORACLE 概要 提纲 计划基线之间的区别
- SOS!监听程序当前无法识别
- 200分求Oracle SQL语句转换为SQL Server的TSQL语句,就一句。
- ORA-12840错误
- 紧急求救!!连接oracle出了这样的错误java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
- 请问怎样停止正在运行的作业?
- 字典记忆功能该如何实现
- oracle是否有数据管道的工具,exp和imp怎么使用?
- 一个oracle navicat的问题
- 多表查询求助,急。
确认一下你的oracle的sid是否为name如果不行,贴出具体的错误信息
没有报错,只是登陆之后页面一直是空白的……