Weblogic7和JBuilder8的一个问题，大虾请进？高分，在线等待！马上结帐。

[jasongufeng]

我在编译运行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");
}
}

因为我很蠢，请说详细点，谢谢！在线等待！马上结帐。

[Djava]

应该是你的MS SQL Server的验证方式有问题
你可以试一下
1. Run MS SQL Server2000->Enterprise Manager
2.select your server and press the right button,
select properties from context menu,switch to
security tab,select SQL Server and windows
authentication,click ok
3.everything is ok,try it,if have any problem,
contact me

[zez]

呵呵,楼上都给说了..
就是你的数据库设置的是默认的windows验证.
改为sql adn windsows验证就可以了...
默认的验证是不允许sql里的用户登陆的...

[jasongufeng]

你们好，我按你们的方法设置了sqlServer但还是出现相同的错误。
为什么？
谢谢！

[Djava]

你的代码贴出来看一下,还有你的数据库,如版本,实例名,监听端口等

[jasongufeng]

是因为没有把数据库驱动加入。
嘻嘻，已经解决。