关于jdbc的链接问题，大家帮忙，来者必给分

大概还是在驱动上出了问题，
要不先用odbc试一下。

试了，odbc是可以的。大伙再帮帮忙。我想还是环境的问题吧。

1、注意驱动名称的大小写问题了吗？
2、有没有先做
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
out.print ("驱动程序不存在");
}排查一下问题！

连不上不一定是驱动的问题，只有报ClassNotFoundException或者No suitable Driver才有可能是驱动的问题。把你的详细异常信息，贴出来看看。

噢！！那就不是驱动的问题。错误的具体情况我现在没有。不过我记得是这样：
每一行都有错误，比如： Class.forName()；DriverManager.getConnection()
等等，都有错误。

我用tomcat4.0和weblogic6.1进行开发？？？？都是web服务器，一个不就足够了！！！！！！

试试:String url=new String();
url="jdbc:microsoft:sqlserver://servername:1433;DatabaseName=dbname";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection(url,"sa","password");
Statement stmt=con.createStatement();

我的意思是我用tomcat和weblogic都试验了，都连不上。
firemica(熊熊)：谢谢你。
能不能给我一个每一步都设置异常抛出的例子。我试试。谢谢啦

String odbcQuery;
Connection odbcconn;
Statement odbcstmt;
ResultSet odbcrs; try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
out.print ("驱动程序不存在");
}
try{
odbcconn = DriverManager.getConnection("jdbc:odbc:myaccess");
odbcstmt = odbcconn.createStatement();
odbcQuery="Select * From usercheck where username='" + username +"' if(odbcrs.next())
{
}
else
{
out.print ("结果集为空！");
}
odbcrs.close();
odbcstmt.close();
odbcconn.close();
}
catch (SQLException e)
{
out.print (e);
}

试试这样<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>

感谢大家的帮助！还想请问一个问题：我的jar文件放的地方对不对？还有我的weblogic的.cmd文件修改了我的classpath.那么我的tomcat应该在什么地方修改classpath呢？是在环境变量里吗？

★°∴°°∴ ☆°．·★°∴°．
         ◢◣   新    ◢◣
        ◢★◣  春   ◢★◣
       ◢坛子◣ 快  ◢朋友◣ ．·°∴★°．°∴°．☆° ．·°
      ◢■■■◣乐 ◢■■■◣ ~~~~~~所有坛子里的朋友~~~~~~
      ︸︸||︸︸!!︸︸||︸︸°．°★ ．·°∴°°．★☆° ·°拷贝一下，这叫信息共享，版权所有： elapsed(鸡毛乱舞)

啊，我怎么没有下载jdbc for SQL2000,
用 sun.jdbc.odbc.JdbcOdbcDriver 就可以连上啊static final String DBDriver ="sun.jdbc.odbc.JdbcOdbcDriver";
static final String strConn ="jdbc:odbc:wap";

我用odbc也没问题，所以想不通过桥来连接

说点边上的，使用了 weblogic再用Tomcat就没有必要了吧，Weblogic自己的连接持也是十分号的啊，

odbcconn = DriverManager.getConnection("jdbc:odbc:myaccess");
myaccess为数据源

SQLSERVER设置了远程访问属性了么？

远程访问属性？是 dataname user和password吗？设了呀！而且用odbc都可以访问成功。

我的程序：
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language = "java" import = "java.sql.*, java.util.*" %><%
   Connection conn = null;
   Statement Stmt = null;
   ResultSet Rst = null;
   int countInt = 0;
    try{
//jdbc-odbc
Class.forName("weblogic.jdbc.mssqlserver4.Driver");
Connection con = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost","sa","1234");      Stmt = conn.createStatement();    }catch(SQLException sql){
      System.out.println("catch sqlexception");
     }catch(java.lang.Exception e){
      System.out.println("");
      out.println("error link");
    }String sql="select * from table1";    try{
      Rst=Stmt.executeQuery(sql);       int k=0;
      while (Rst.next())
      {k++;
      String id=Rst.getString(1);
      String name=Rst.getString(2);
      out.print("userid"+k+" = "+id+"<br>");
      out.println("user"+k+" = "+name+"<BR>");      }
    }catch(SQLException sql){
      System.out.println("Query error");
    }catch(java.lang.Exception e){
      System.out.println("lang error");
    }%></body>
</html>

tomcat中错误如下：type Exception reportmessage Internal Server Errordescription The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.exception org.apache.jasper.compiler.ParseException: /jdbc/test.jsp(5,4) Invalid directive
at org.apache.jasper.compiler.Parser$Directive.accept(Parser.java:214)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1133)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1091)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1087)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:213)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:210)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:546)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:177)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:189)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:484)

weblogic中错误如下：Compilation of 'C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java' failed:
--------------------------------------------------------------------------------
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:92: cannot resolve symbol
probably occurred due to an error in /jdbc/test.jsp line 10:
Connection conn = null;C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:93: cannot resolve symbol
probably occurred due to an error in /jdbc/test.jsp line 11:
Statement drpStmt = null;C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:94: cannot resolve symbol
probably occurred due to an error in /jdbc/test.jsp line 12:
ResultSet drpRst = null;C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:104: cannot resolve symbol
probably occurred due to an error in /jdbc/test.jsp line 22:
Connection conn = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost:1433","sa","pjj");C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:104: cannot resolve symbol
probably occurred due to an error in /jdbc/test.jsp line 22:
Connection conn = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost:1433","sa","pjj");C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:116: cannot resolve symbol
probably occurred due to an error in /jdbc/test.jsp line 34:
}catch(SQLException sqle){C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:136: cannot resolve symbol
probably occurred due to an error in /jdbc/test.jsp line 54:
}catch(SQLException sqly){
--------------------------------------------------------------------------------
Full compiler error(s):
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:92: cannot resolve symbol
symbol  : class Connection
location: class jsp_servlet._jdbc.__test
            Connection conn = null; //[ /jdbc/test.jsp; Line: 10]
            ^
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:93: cannot resolve symbol
symbol  : class Statement
location: class jsp_servlet._jdbc.__test
            Statement drpStmt = null; //[ /jdbc/test.jsp; Line: 11]
            ^
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:94: cannot resolve symbol
symbol  : class ResultSet
location: class jsp_servlet._jdbc.__test
            ResultSet drpRst = null; //[ /jdbc/test.jsp; Line: 12]
            ^
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:104: cannot resolve symbol
symbol  : class Connection
location: class jsp_servlet._jdbc.__test
                Connection conn = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost:1433","sa","pjj"); //[ /jdbc/test.jsp; Line: 22]
                ^
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:104: cannot resolve symbol
symbol  : variable DriverManager
location: class jsp_servlet._jdbc.__test
                Connection conn = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost:1433","sa","pjj"); //[ /jdbc/test.jsp; Line: 22]
                                  ^
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:116: cannot resolve symbol
symbol  : class SQLException
location: class jsp_servlet._jdbc.__test
            }catch(SQLException sqle){ //[ /jdbc/test.jsp; Line: 34]
                   ^
C:\bea\wlserver6.1\config\mydomain\applications\DefaultWebApp\WEB-INF\_tmp_war_myserver_myserver_DefaultWebApp\jsp_servlet\_jdbc\__test.java:136: cannot resolve symbol
symbol  : class SQLException
location: class jsp_servlet._jdbc.__test
            }catch(SQLException sqly){ //[ /jdbc/test.jsp; Line: 54]
                   ^
7 errors
--------------------------------------------------------------------------------
Mon Jan 27 20:18:39 CST 2003

直接用weblogic的连接池连算了!weblogic 的jar只能在weblogic中用.!

Connection con = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost","sa","1234");
-->
conn = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost","sa","1234");

tomcat:
在环境变量CLASSPATH里加上你的JAR路径

tomcat的classpath怎么设？是在：我的电脑－属性－环境变量里设吗

Connection conn = null;
Connection con = DriverManager.getConnection（..)//这里有错吧
->conn = DriverManager.getConnection（..)

要以高级用户身份登录才可以修改一些特殊的表（Create database dataname时的默认权限），修改它就可以了，我手边没有Sql server，准确在那里我不太清楚，只好自己看了！

调试易

关于jdbc的链接问题，大家帮忙，来者必给分

解决方案 »