java三种连接方式_Oracle三种连接方式

TNS mode：将TNS文件放至Oracle的Client目录下，如  E:\app\mes\product\11.2.0\client_1\Network\Admin

tnsnames.ora

# Every line that begins with # is a comment line

#

# Create Oracle net service names, or aliases, for each database server

# you need to connect to.

#

# TNSNames.ora sample entry

#

# alias =

# (DESCRIPTION =

# (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mycompany.com)(PORT = 1521))

# (CONNECT_DATA =

# (SERVER = DEDICATED)

# (SERVICE_NAME = orcl)

# )

# )

#

# You can modify the entry below for your own database.

# = Name to use in the connection string Data Source

# = name or IP of the database server machine

# = database server machine port to use

# = name of the database service on the server

INTRAFACTORY =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.238)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

2、字符串连接：

User Id=INTRAFACTORYUSER;Password=INTRAFACTORY;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.128.238)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));

注：

SERVICE_NAME是orcl