tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sladky, Jan" <Jan.Sla...@partner.commerzbank.com>
Subject AW: got a doubt
Date Mon, 30 Jul 2001 08:10:22 GMT
Sajan,
be sure to have created your DSN as a system DSN.
If you created your DSN as a User DSN this wont work.
(I guess that you have created a DSN at all.)

Grtx
Jan

-----Urspr√ľngliche Nachricht-----
Von: sajan koshy george [mailto:sajan_75@rediffmail.com]
Gesendet am: Montag, 30. Juli 2001 10:06
An: tomcat-user@jakarta.apache.org
Betreff: got a doubt

Hi,

when i installed tomcat as a service in nt machine.u get the default page
and everything.but when i try to use a JSP page that has to interact with a
database.i get the following error.


Internal Servlet Error:

javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
	at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
	at
jsp.apepmail._0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0._jsp
Service(_0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0.java:137)
	at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
	at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
	at org.apache.tomcat.core.Handler.service(Handler.java:286)
	at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
	at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
	at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
	at java.lang.Thread.run(Thread.java:484)

Root cause: 
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
	at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458)
	at
sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320)
	at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
	at java.sql.DriverManager.getConnection(DriverManager.java:517)
	at java.sql.DriverManager.getConnection(DriverManager.java:199)
	at apepmail.sqlbean.makeConnection(sqlbean.java:19)
	at
jsp.apepmail._0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0._jsp
Service(_0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0.java:87)
	at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
	at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
	at org.apache.tomcat.core.Handler.service(Handler.java:286)
	at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
	at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
	at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
	at java.lang.Thread



This error comes only when i try to use tomcat as a service .if i directly
start tomcat with startup.bat it works.is there any classpath or anything
like that i should set for driver only?.would be grateful if u could help me
out.

with regards 
sajan

_________________________________________________________
For Rs. 2,000,000 worth of Aptech scholarships click below
http://events.rediff.com/aptechsch/scholarship.htm



Mime
View raw message