ojdbc14.jar with version 10.2.0.1.0
ojdbc5.jar with version 11.2.0.1.0
Which JDBC drivers support which versions of Oracle Database?
JDBC 9.0.1 drivers can talk to RDBMS
11.1.0
10.2.0
10.1.0
9.2.0
9.0.1
8.1.7
8.1.6
8.1.5
8.0.6
8.0.5
8.0.4
7.3.4
JDBC 9.2.0 drivers can talk to RDBMS
11.2.0
11.1.0
10.2.0
10.1.0
9.2.0
9.0.1
8.1.7
JDBC 10.1.0 drivers can talk to RDBMS
11.2.0
11.1.0
10.2.0
10.1.0
9.2.0
9.0.1
8.1.7
JDBC 10.2.0 drivers can talk to RDBMS
11.2.0
11.1.0
10.2.0
10.1.0
9.2.0
9.0.1
8.1.7
JDBC 11.1.0 drivers can talk to RDBMS
11.2.0
11.1.0
10.2.0
10.1.0
9.2.0
9.0.1
JDBC 11.2.0 drivers can talk to RDBMS
11.2.0
11.1.0
10.2.0
10.1.0
9.2.0
9.0.1
A related question is about versions NOT listed here. If its not listed here, its not supported.
You should verify with your support channel that you are still on a supported version of Oracle.
For example, a lot of people have asked about 8.1.7 which has been desupported. People still
using 8.1.7 need to contact their support channels for upgrade info (some of these upgrades are free!).
分享到:
相关推荐
String url = "jdbc:oracle:thin:@//your_db_host:port/service_name"; String username = "your_username"; String password = "your_password"; try { Class.forName("oracle.jdbc.driver.OracleDriver"); ...
Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:service_name", "username", "password"); ``` 3. **DB2 JDBC驱动**:...
"jdbc:oracle:thin:@localhost:1521:ORCL", // URL (replace with your DB info) "username", // replace with your username "password" // replace with your password ); ``` 3. **创建Statement对象**:`...
driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:XE" username="mss" password="mss" maxActive="50" maxIdle="2" maxWait="10000"/> ``` 这里定义了一个...
<Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource" username="oracle_user" password="oracle_password" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:...
Class.forName("oracle.jdbc.driver.OracleDriver"); Connection cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd); ``` #### 4. Sybase Sybase是一个关系型...
- `jdbc.driver`:驱动类名,应为`oracle.jdbc.driver.OracleDriver`。 - `jdbc.url`:连接URL,格式为`jdbc:oracle:thin:@localhost:1521:ORCL`。 - `jdbc.username`和`jdbc.password`:数据库用户名和密码。 ####...
driver-class-name: oracle.jdbc.driver.OracleDriver url: jdbc:oracle:thin:@localhost:1521:orclpdb username: oracle_user password: oracle_password ``` 然后,创建两个数据源的配置类,继承`...
class:oracle.jdbc.driver.OracleDriver url:"jdbc:oracle:thin:@localhost:1521:jbitdb","epet","epet" sqlserver: class:com.microsoft.sqlserver.jdbc.SQLServerDriver url:"jdbc:sqlserver://localhost:1433;...
- 将`db=H2`改为`db=oracle`,指定使用Oracle数据库。 - 调整`tomcat.version`值为当前Tomcat版本号,确保与实际安装的Tomcat版本相匹配。 2. **配置Oracle连接信息:** - 在`build.oracle.properties`文件中,...
Class.forName("oracle.jdbc.driver.OracleDriver"); // 建立连接 Connection conn = DriverManager.getConnection(url, username, password); // 创建PreparedStatement,用于执行SQL语句 String sql = ...
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver ``` 或者,如果你使用的是YAML格式: ```yaml # application.yml 示例 spring: datasource: url: jdbc:oracle:thin:@//your-oracle-server:port/...
orcl.driver=oracle.jdbc.OracleDriver orcl.url=jdbc:oracle:thin:@localhost:1521:mp orcl.username=username orcl.password=1234 ``` - **applicationContext.xml**:配置数据源`dataSource`,使用C3P0...
<dataSource driver="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:testoracle" user="test" password="test" batch-size="-1"/> ``` 2. **定义数据映射**: - 定义`document`段...
hibernate.connection.driver_class org.hsqldb.jdbcDriver hibernate.connection.username sa hibernate.connection.password hibernate.connection.url jdbc:hsqldb:./build/db/hsqldb/hibernate #hibernate....
<driver>com.mysql.jdbc.Driver</driver> <url>jdbc:mysql://localhost:3306/mydb <username>root <password>password <script>src/main/resources/db/init.sql ``` 在上面的配置中,`init-db`...
4. **版本兼容性**:提到的 1.4 版本,可能支持多种数据库引擎,如 MySQL、Oracle、PostgreSQL 等,并兼容多种 JDBC 驱动。 ** 使用方法 ** 要在 Maven 项目中使用 maven-db-plugin,首先需要在项目的 pom.xml ...
2. **数据库连接管理**:Maven DB Plugin支持多种数据库连接,包括MySQL、Oracle、PostgreSQL等,通过配置插件参数可以方便地切换不同的数据库环境。 3. **事务控制**:插件提供了事务控制能力,可以根据需求决定...
- **兼容性**:虽然具体版本1.4的兼容性信息未明确给出,但通常Maven插件会支持主流的JDBC驱动,意味着它可以与多种数据库系统(如MySQL、Oracle、PostgreSQL等)协同工作。 ** 注意事项 ** 1. **安全**:在配置...