Home > Database > Mysql Tutorial > body text

有关Oracle安装以及Oracle-JDBC的使用问题

WBOY
Release: 2016-06-07 17:06:16
Original
836 people have browsed it

1,安装Oracle时,安装路径和源路径都必须是英文的。2,做例题的时候用到Oracle的JDBC,遇到困难,解决后得出结论如下:

1,安装Oracle时,安装路径和源路径都必须是英文的。

2,做例题的时候用到Oracle的JDBC,遇到困难,解决后得出结论如下:

classes12.jar - for Java 1.2 and 1.3
ojdbc14.jar - for Java 1.4 and 1.5
ojdbc5.jar - for Java 1.5
ojdbc6.jar - for Java 1.6

oracle92自带jdk为1.3,,虽然我的开发环境是1.6,可是在配置文件中仍然选用classes12.jar - for Java 1.2 and 1.3

jdbc版本与java版本有关。并且jdbc的运行于oracle自带的jdk版本有关。

3,配置数据源的时候,需要更改tomcat-config-context.xml

driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:ora92"/>

其中url里,ip127.0.0.1是指你要连接的数据库所在服务端的ip地址;ora92指的是全局数据库名;1521是端口号。

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!