Hello,
I am unable to perform database connectivity through JSP. I am receiving the following error when i try to run my code:
Error java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
==============
SOFTWARE DETAILS
==============
JAVA VERSION: j2sdk1.4.1
Database: Oracle 10g Express Edition
Tomcat Version: Tomcat 5.5
=======================
ENVIRONMENT VARIABLE ENTRIES
=======================
CATALINA_HOME: C:\Program Files\Apache Software Foundation\Tomcat 5.5\
CLASSPATH: .;C:\mysql-connector-java-5.0.8\mysql-connector-java-5.0.8-bin.jar;C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\servlet-api.jar;C:\JSDK2.0\lib\jsdk.jar;C:\Program Files\Java\jre6\lib\ext\QTJava.zip
JAVA_HOME: C:\j2sdk1.4.1\bin
==========
SOURCE CODE
==========
FileName: getSugaInsert.jsp
<%@ page import="java.sql.* "%>
<%
String name="", email="";
if(name!=null)
{
Connection conn;
Statement stmt;
try
{
name=request.getParameter("name");
email=request.getParameter("email");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:CMS","system","password");
stmt=conn.createStatement();
stmt.execute("insert into Tester values ('"+name+"','"+email+"')");
out.println("Record Inserted");
}
catch(Exception e)
{
out.println("Error "+e);
}
}
else
{
%>
<HTML>
<HEAD>
<TITLE>INSERTING DATA INTO TABLE</TITLE>
</HEAD>
<BODY>
<FORM ACTION="getSugaInsert.jsp" METHOD=post>
NAME: <INPUT TYPE=test NAME="name" />
EMAIL: <INPUT TYPE=text NAME="email" />
<INPUT TYPE=submit VALUE="insert" />
</FORM>
</BODY>
</HTML>
<%
}
%>
=========================================================================
Please inform me if i am missing any details.
I am unable to perform database connectivity through JSP. I am receiving the following error when i try to run my code:
Error java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
==============
SOFTWARE DETAILS
==============
JAVA VERSION: j2sdk1.4.1
Database: Oracle 10g Express Edition
Tomcat Version: Tomcat 5.5
=======================
ENVIRONMENT VARIABLE ENTRIES
=======================
CATALINA_HOME: C:\Program Files\Apache Software Foundation\Tomcat 5.5\
CLASSPATH: .;C:\mysql-connector-java-5.0.8\mysql-connector-java-5.0.8-bin.jar;C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\servlet-api.jar;C:\JSDK2.0\lib\jsdk.jar;C:\Program Files\Java\jre6\lib\ext\QTJava.zip
JAVA_HOME: C:\j2sdk1.4.1\bin
==========
SOURCE CODE
==========
FileName: getSugaInsert.jsp
<%@ page import="java.sql.* "%>
<%
String name="", email="";
if(name!=null)
{
Connection conn;
Statement stmt;
try
{
name=request.getParameter("name");
email=request.getParameter("email");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:CMS","system","password");
stmt=conn.createStatement();
stmt.execute("insert into Tester values ('"+name+"','"+email+"')");
out.println("Record Inserted");
}
catch(Exception e)
{
out.println("Error "+e);
}
}
else
{
%>
<HTML>
<HEAD>
<TITLE>INSERTING DATA INTO TABLE</TITLE>
</HEAD>
<BODY>
<FORM ACTION="getSugaInsert.jsp" METHOD=post>
NAME: <INPUT TYPE=test NAME="name" />
EMAIL: <INPUT TYPE=text NAME="email" />
<INPUT TYPE=submit VALUE="insert" />
</FORM>
</BODY>
</HTML>
<%
}
%>
=========================================================================
Please inform me if i am missing any details.