kennethcky
asked on
SQLServer 2000 Driver for JDBC Unable to connect ????????????
Hi,
I'm trying to insert records into the database and display them in the browser.
I'm getting the following error. I used
-Tomcat4.0
-Microsoft SQL 2000 Server
-Microsoft SQLServer 2000 Driver for JDBC
-jdk1.3.1_02
-Windows 2000 Professional
Should I change something in the server.xml, or add something to the classpath
I just added into the classpath the MS SQL 2000 Drivers namely
(located inside \web-inf\classes\lib\*,jar )
-msbase.jar
-mssqlserver.jar
-msutil.jar
but still to no avail
FYI, it able to work using Ms Access but NOT MS SQL 2000 Server. I use JSP to
call JavaBean to connect to database. Am I missing something over here?
PLS HELP ......................
Below is part of the CONNECTION STRING
************************** ********** ********** ********** ********** **********
String dbURL = "jdbc:microsoft:sqlserver: //holla:14 33,Databas eName=samp le";
String dbDriver = "com.microsoft.jdbc.sqlser ver.SQLSer verDriver" ;
Class.forName(dbURL);
dbCon = DriverManager.getConnectio n(dbURL,"s a","jonny" );
************************** ********** ********** ********** ********** **********
500 Error:
javax.servlet.ServletExcep tion: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to
connect. Invalid URL.
at
org.apache.jasper.runtime. PageContex tImpl.hand lePageExce ption(Page ContextImp l.java:471 )
at org.apache.jsp.sql$jsp._js pService(s ql$jsp.jav a:168)
at org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:107 )
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at
org.apache.jasper.servlet. JspServlet $JspServle tWrapper.s ervice(Jsp Servlet.ja va:201)
at org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:381)
at org.apache.jasper.servlet. JspServlet .service(J spServlet. java:473)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at
org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n
.java:247)
at
org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:1 9
3)
at
org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:243)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at
org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:190)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at org.apache.catalina.core.S tandardCon text.invok e(Standard Context.ja va:2347)
at
org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:180 )
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at
org.apache.catalina.valves .ErrorDisp atcherValv e.invoke(E rrorDispat cherValve. java:170)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at
org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:170 )
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.valves .AccessLog Valve.invo ke(AccessL ogValve.ja va:468)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at
org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :174)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at
org.apache.catalina.connec tor.http.H ttpProcess or.process (HttpProce ssor.java: 1027)
at
org.apache.catalina.connec tor.http.H ttpProcess or.run(Htt pProcessor .java:1125 )
at java.lang.Thread.run(Threa d.java:484 )
root cause
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect.
Invalid URL.
at com.microsoft.jdbc.base.Ba seExceptio ns.createE xception(U nknown Source)
at com.microsoft.jdbc.base.Ba seExceptio ns.getExce ption(Unkn own Source)
at com.microsoft.jdbc.base.Ba seDriver.c onnect(Unk nown Source)
at java.sql.DriverManager.get Connection (DriverMan ager.java: 517)
at java.sql.DriverManager.get Connection (DriverMan ager.java: 199)
at SQLBean.DbBean.connect(DbB ean.java:1 9)
at org.apache.jsp.sql$jsp._js pService(s ql$jsp.jav a:111)
at org.apache.jasper.runtime. HttpJspBas e.service( HttpJspBas e.java:107 )
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at
org.apache.jasper.servlet. JspServlet $JspServle tWrapper.s ervice(Jsp Servlet.ja va:201)
at org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:381)
at org.apache.jasper.servlet. JspServlet .service(J spServlet. java:473)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 853)
at
org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n
.java:247)
at
org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:1 9
3)
at
org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:243)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at
org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:190)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at org.apache.catalina.core.S tandardCon text.invok e(Standard Context.ja va:2347)
at
org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:180 )
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at
org.apache.catalina.valves .ErrorDisp atcherValv e.invoke(E rrorDispat cherValve. java:170)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at
org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:170 )
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.valves .AccessLog Valve.invo ke(AccessL ogValve.ja va:468)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 64)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at
org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :174)
at
org.apache.catalina.core.S tandardPip eline.invo keNext(Sta ndardPipel ine.java:5 66)
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:472)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 43)
at
org.apache.catalina.connec tor.http.H ttpProcess or.process (HttpProce ssor.java: 1027)
at
org.apache.catalina.connec tor.http.H ttpProcess or.run(Htt pProcessor .java:1125 )
at java.lang.Thread.run(Threa d.java:484 )
I'm trying to insert records into the database and display them in the browser.
I'm getting the following error. I used
-Tomcat4.0
-Microsoft SQL 2000 Server
-Microsoft SQLServer 2000 Driver for JDBC
-jdk1.3.1_02
-Windows 2000 Professional
Should I change something in the server.xml, or add something to the classpath
I just added into the classpath the MS SQL 2000 Drivers namely
(located inside \web-inf\classes\lib\*,jar
-msbase.jar
-mssqlserver.jar
-msutil.jar
but still to no avail
FYI, it able to work using Ms Access but NOT MS SQL 2000 Server. I use JSP to
call JavaBean to connect to database. Am I missing something over here?
PLS HELP ......................
Below is part of the CONNECTION STRING
**************************
String dbURL = "jdbc:microsoft:sqlserver:
String dbDriver = "com.microsoft.jdbc.sqlser
Class.forName(dbURL);
dbCon = DriverManager.getConnectio
**************************
500 Error:
javax.servlet.ServletExcep
connect. Invalid URL.
at
org.apache.jasper.runtime.
at org.apache.jsp.sql$jsp._js
at org.apache.jasper.runtime.
at javax.servlet.http.HttpSer
at
org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at javax.servlet.http.HttpSer
at
org.apache.catalina.core.A
.java:247)
at
org.apache.catalina.core.A
3)
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at
org.apache.catalina.valves
at
org.apache.catalina.core.S
at
org.apache.catalina.valves
at
org.apache.catalina.core.S
at org.apache.catalina.valves
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at
org.apache.catalina.connec
at
org.apache.catalina.connec
at java.lang.Thread.run(Threa
root cause
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect.
Invalid URL.
at com.microsoft.jdbc.base.Ba
at com.microsoft.jdbc.base.Ba
at com.microsoft.jdbc.base.Ba
at java.sql.DriverManager.get
at java.sql.DriverManager.get
at SQLBean.DbBean.connect(DbB
at org.apache.jsp.sql$jsp._js
at org.apache.jasper.runtime.
at javax.servlet.http.HttpSer
at
org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at org.apache.jasper.servlet.
at javax.servlet.http.HttpSer
at
org.apache.catalina.core.A
.java:247)
at
org.apache.catalina.core.A
3)
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.catalina.core.S
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at
org.apache.catalina.valves
at
org.apache.catalina.core.S
at
org.apache.catalina.valves
at
org.apache.catalina.core.S
at org.apache.catalina.valves
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at
org.apache.catalina.core.S
at
org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at
org.apache.catalina.connec
at
org.apache.catalina.connec
at java.lang.Thread.run(Threa
Are you sure that the JDBC driver expects the jdbc URL on this format: String dbURL = "jdbc:microsoft:sqlserver: //holla:14 33,Databas eName=samp le";
Better check the documentation. It seems it is an invalid format you are trying to send.
Better check the documentation. It seems it is an invalid format you are trying to send.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Pls help me to solve it i'm getting crazy about this error
JAVA CODE
package SQLBean;
import java.sql.*;
import java.io.*;
public class DbBean {
String dbURL = "jdbc:microsoft:sqlserver:
String dbDriver = "com.microsoft.jdbc.sqlser
private Connection dbCon;
public DbBean(){
super();
}
public boolean connect() throws ClassNotFoundException,SQL
Class.forName(dbDriver);
dbCon = DriverManager.getConnectio
return true;
}
public void close() throws SQLException{
dbCon.close();
}
public ResultSet execSQL(String sql) throws SQLException{
Statement s = dbCon.createStatement();
ResultSet r = s.executeQuery(sql);
return (r == null) ? null : r;
}
public int updateSQL(String sql) throws SQLException{
Statement s = dbCon.createStatement();
int r = s.executeUpdate(sql);
return (r == 0) ? 0 : r;
}
}
--------------------------
JSP PAGE
<HTML>
<HEAD><TITLE>DataBase Search</TITLE></HEAD>
<BODY>
<%@ page language="Java" import="java.sql.*" %>
<jsp:useBean id="db" scope="request" class="SQLBean.DbBean" />
<jsp:setProperty name="db" property="*" />
<%!
ResultSet rs = null ;
ResultSetMetaData rsmd = null ;
int numColumns ;
int i;
%>
<center>
<h2> Results from </h2>
<hr>
<br><br>
<table>
<%
db.connect();
try {
rs = db.execSQL("select * from employee");
i = db.updateSQL("UPDATE employee set CLUB = 'MOUNTAIN' where CID='102'");
out.println(i);
}catch(SQLException e) {
throw new ServletException("Your query is not working", e);
}
rsmd = rs.getMetaData();
numColumns = rsmd.getColumnCount();
for(int column=1; column <= numColumns; column++){
out.println(rsmd.getColumn
}
%>
<%
while(rs.next()) {
%>
<%= rs.getString("EMPNO") %>
<BR>
<%
}
%>
<BR>
<%
db.close();
%>
Done
</table>
</body>
</HTML>