Error while trying to retrieve text error CRA-12154
数据库连接错误
Pl/SQL
连接数据库 看ip地址
在PL/SQL中选择Help-->Support Info... ->查看DNS File C:\oracle\ora90\network\Admin\tnsnames.ora ->查看jdbcurl.java连接数据库IP-->查看数据库登录名和密码
#dev slisoper/slisoper
newdev2 = (DESCRIPTION =(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.200.105 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = lifedev)
)
)
根据jdbc连接数据库的ip地址
public JdbcUrl()
{
DBType = "ORACLE";
IP = "xx.x.xxx.xxx";
Port = "1521";
DBName = "lifedev";
UserName = "sss";
PassWord = "sss";
}
public String getJdbcUrl()
{
String sUrl = "";
if (DBType.trim().toUpperCase().equals("ORACLE"))
{
sUrl = "jdbc:oracle:thin:@" + IP + ":"
+ Port + ":"
+ DBName ;
}
if (DBType.trim().toUpperCase().equals("INFORMIX"))
{
sUrl = "jdbc:informix-sqli://" + IP + ":"
+ Port + "/"
+ DBName + ":"
+ "informixserver=" + ServerName + ";"
+ "user=" + UserName + ";"
+ "password=" + PassWord + ";";
}
if (DBType.trim().toUpperCase().equals("SQLSERVER"))
{
sUrl = "jdbc:microsoft:sqlserver://" + IP + ":"
+ Port +
";databaseName=" + DBName + ";selectMethod=cursor";
}
if (DBType.trim().toUpperCase().equals("WEBLOGICPOOL"))
{
sUrl = "jdbc:weblogic:pool:" + DBName ;
}
return sUrl;
}