Weblogic7和JBuilder8的一个问题,大虾请进?高分,在线等待!马上结帐。

jasongufeng 2003-03-05 02:50:00
我在编译运行servlet程序时,Weblogic7.0能正常运行(servlet也能运行),但是出现如下错误:

Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: 用户 'cne5' 登录失败。原因: 未与信任 SQL Server 连接相关联。 Severity 14, State 1, Procedure 'null null', Line 0 Unable to connect, please check your server's version and availability.

<2003-3-5 下午02时35分29秒> <Error> <JDBC> <001060> <Cannot startup connection pool "demoPool" weblogic.common.ResourceException: Cannot load driver class: com.pointbase.jdbc.jdbcUniversalDriver>

<2003-3-5 下午02时35分29秒> <Error> <JDBC> <001059> <Error during Data Source creation: weblogic.common.ResourceException: DataSource(SQLServer) can't be created with non-existent Pool (connection or multi) (SQL Server Connection Pool)

<2003-3-5 下午02时35分30秒> <Error> <JDBC> <001059> <Error during Data Source creation: weblogic.common.ResourceException: DataSource(examples-dataSource-demoPool) can't be created with non-existent Pool (connection or multi) (demoPool)

<2003-3-5 下午02时35分30秒> <Error> <JDBC> <001059> <Error during Data Source creation: weblogic.common.ResourceException: DataSource(examples-dataSource-demoXAPool) can't be created with non-existent Pool (connection or multi) (demoXAPool)

<2003-3-5 下午02时35分31秒> <Alert> <JMS> <040052> <JMSServer "examplesJMSServer", store failed to open, java.io.IOException: JMS JDBC store, connection pool = <demoPool>, prefix = <examples>: connection pool does not exist.

java.io.IOException: JMS JDBC store, connection pool = <demoPool>, prefix = <examples>: connection pool does not exist

<2003-3-5 下午02时35分31秒> <Error> <JMS> <040123> <Failed to start JMS Server "examplesJMSServer" due to weblogic.jms.common.JMSException: JMS can not open store exampleJDBCStore.

weblogic.jms.common.JMSException: JMS can not open store exampleJDBCStore

----------- Linked Exception -----------

java.io.IOException: JMS JDBC store, connection pool = <demoPool>, prefix = <examples>: connection pool does not exist

<2003-3-5 下午02时35分37秒> <Error> <EJB> <010070> <Error activating EJB Module : ejb20_basic_containerManaged.jar
Exception is :

Unable to deploy EJB: containerManaged from ejb20_basic_containerManaged.jar:

weblogic.ejb20.WLDeploymentException: The DataSource with the JNDI name: examples-dataSource-demoPool could not be located. Please ensure that the DataSource has been deployed successfully and that the JNDI name in your EJB Deployment descriptor is correct.

Unable to deploy EJB: containerManaged from ejb20_basic_containerManaged.jar:

weblogic.ejb20.WLDeploymentException: The DataSource with the JNDI name: examples-dataSource-demoPool could not be located. Please ensure that the DataSource has been deployed successfully and that the JNDI name in your EJB Deployment descriptor is correct.

<2003-3-5 下午02时35分38秒> <Error> <Deployer> <149231> <The slave deployer was unable to set the activation state to true for the application _appsdir_ejb20_basic_containerManaged_ear

weblogic.management.ApplicationException: activate failed forejb20_basic_containerManaged.jar
{
Module Name: ejb20_basic_containerManaged.jar, Error: Exception activating module: EJBModule(ejb20_basic_containerManaged.jar,status=PREPARED)


Unable to deploy EJB: containerManaged from ejb20_basic_containerManaged.jar:

weblogic.ejb20.WLDeploymentException: The DataSource with the JNDI name: examples-dataSource-demoPool could not be located. Please ensure that the DataSource has been deployed successfully and that the JNDI name in your EJB Deployment descriptor is correct.

TargetException:

Unable to deploy EJB: containerManaged from ejb20_basic_containerManaged.jar:

weblogic.ejb20.WLDeploymentException: The DataSource with the JNDI name: examples-dataSource-demoPool could not be located. Please ensure that the DataSource has been deployed successfully and that the JNDI name in your EJB Deployment descriptor is correct.


我是按下面设置weblogic7的。
WebLogic7的配置:
1. 启动WebLogic7
2. 打开IE6,在地址栏中输入:<http://localhost:7001/console>
3. 输入用户名和密码
4. 在左边的目录树中选中Services->JDBC->Connection Pools,单击右侧的Configure a new JDBC Connection Pool.,输入以下信息:
Configuration->General页:
Name = SQL Server Connection Pool
URL = jdbc:weblogic:mssqlserver4:northwind@localhost
Driver classname = weblogic.jdbc.mssqlserver4.Driver
Properties :
user = cne5
Password = “********” <- sa的密码
单击Create建立连接池。
Targets->Server页:
将myserver(服务器名称)移至右侧的列表中,但击单击Apply
5. 在左边的目录树中选中Services->JDBC->Data Sources(或者TXData Sources),单击右侧的Configure a new JDBC Connection Pool.,输入以下信息:
Configuration->General页:
Name = SQLServer Tx Data Source
JNDI Name = SQLServer
Pool Name = SQL Server Connection Pool
选中Emulate Two-Phase Commit for non-XA Driver和Row Prefetch Enabled
单击Create建立数据源。
Targets->Server页:
将myserver(服务器名称)移至右侧的列表中,但击单击Apply,配置完毕。

servlet源文件:
package test;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Servlet extends HttpServlet
{
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out = response.getWriter();
out.println("Hello World");
}
}

因为我很蠢,请说详细点,谢谢!在线等待!马上结帐。
...全文
10 点赞 收藏 2
写回复
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
jasongufeng 2003-03-05
你好,我按你的方法设置了sqlServer但还是出现相同的错误。
为什么?
谢谢!
回复
zez 2003-03-05
打开你的sql server 企业管理器,打开你的数据库,在你的数据库上点右键,点security.选SQL server and windows
确定
另外确认你sql里有那个用户名和密码正确 :)
回复
发动态
发帖子
中间件
创建于2007-08-27

1192

社区成员

企业软件 中间件技术
申请成为版主
社区公告
暂无公告