OracleDatabase 配置

最新推荐文章于 2024-10-06 09:31:15 发布

weixin_30332241

最新推荐文章于 2024-10-06 09:31:15 发布

阅读量255

点赞数

文章标签：数据库网络

原文链接：http://www.cnblogs.com/freewater/archive/2011/08/28/2156497.html

版权

tnsnames.ora

ORCL=
 (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.5.78 )(PORT = 1522))
   )
   (CONNECT_DATA =
      (SERVICE_NAME = orcl)
   )
 )

　　法一：

 1 OracleDataSource ds = new OracleDataSource();
 2 ds.setDriverType("oci");
 3 ds.setNetworkProtocol("tcp");
 4 ds.setServerName("10.3.5.78");
 5 ds.setPortNumber(1522);
 6 ds.setDatabaseName("orcl");
 7 ds.setUser("scott");        
 8 ds.setPassword("tiger");

　　法二：

OracleDataSource ds = new OracleDataSource();
ds.setDriverType("oci");
ds.setTNSEntryName("orcl");
ds.setUser("scott");        
ds.setPassword("tiger");

　　法三：

OracleDataSource ds = new OracleDataSource();
ds.setURL("jdbc:oracle:oci:@orcl");
ds.setUser("scott");        
ds.setPassword("tiger");

　　If you are using the JDBC Thin or OCI driver, then note the following:

■A URL setting can include settings for user and password, as in the following example, in which case this takes precedence over individual user and password property settings:

jdbc:oracle:thin:scott/tiger@localhost:1521:orcl

■Settings for user and password are required, either directly through the URL setting or through the getConnection call. The user and password settings in a getConnection call take precedence over any property settings.

■If the url property is set, then any tnsEntry, driverType, portNumber, networkProtocol, serverName, and databaseName property settings are

ignored.

■If the tnsEntry property is set, which presumes the url property is not set, then any databaseName, serverName, portNumber, and networkProtocol settings are ignored.

■If you are using an OCI driver, which presumes the driverType property is set to oci, and the networkProtocol is set to ipc, then any other property settings are ignored.

详细参见： Oracle Database JDBC Developer's Guide and References(11.2) chapter 8.DataSource and URL

转载于:https://www.cnblogs.com/freewater/archive/2011/08/28/2156497.html