weblogic不能设置数据库连接池???求解.
新装了weblogic8.1
安照一般的J2EE书籍配置weblogic,其它都正常,可是到了设置数据库连接池时,总是出问题..
出现下面错误:
mydomain> JDBC Connection Pools> Configure
Connected to : yangxingkuan :7001 You are logged in as : system Logout
Can't open a socket on yangxingkuan:1433. Check host and port number and make sure the security manager allows this connection. You can also try running the SocketApplet (java.net.ConnectException: Connection refused: connect).
Configure a JDBC Connection Pool
Test database connection
A connection pool can fail if the database cannot be reached or if there are errors in the connection properties. Ping your database now to test database availability and the connection properties you provided. Driver Classname:
The full package name of JDBC driver class used to create the physical database connections in the connection pool. (Note that this driver class must be in the classpath of any server to which it is deployed.)
URL:
The URL of the database to connect to. The format of the URL varies by JDBC driver.
Database User Name:
The database account user name used in the physical database connection.
Password:
Confirm Password:
The database account password used in the physical database connection.
Properties: db=test
user=sa
server=yangxingkuan
The list of properties passed to the JDBC driver that are used to create physical database connections. For example: server=dbserver1. List each property=value pair on a separate line.
在Host Name:输入自己的IP同样出错误..
求高手解决..??
问题点数:30、回复次数:5Top
1 楼njbaige(白鸽)回复于 2006-03-07 14:07:43 得分 10
是提示没有连接上Server了,
1.保证Server还活着,用数据库服务器客户端可以连接上
2.JDBC驱动配置是否正确,在Class path中可以找到
3.JDBC连接的URL是否配置正确,包括IP,UserName,Password 等Top
2 楼lqfeng123(暴风雨)回复于 2006-03-07 15:31:26 得分 10
顶Top
3 楼yangxingkuan(开发者)回复于 2006-03-07 17:18:20 得分 0
1.保证Server还活着,用数据库服务器客户端可以连接上
2.JDBC驱动配置是否正确,在Class path中可以找到
3.JDBC连接的URL是否配置正确,包括IP,UserName,Password 等
这3个应该都没有问题,我的其它同学也和我一样连不上,机器上安装SQL个人版,weblogic的驱动是SQL的驱动,
可以用ODBC连接数据库.不知道会不会和盗版有关..Top
4 楼mosquitoxh((IT,中间件,架构)http://it.paiming.org/bbs)回复于 2006-03-07 18:12:09 得分 10
是不是防火墙什么作怪Top
5 楼yangxingkuan(开发者)回复于 2006-03-10 13:30:00 得分 0
在网上找了下,很多都有我的情况,下载了一个SOL 2000 SP4就可以了,谢谢大家。Top




