Forum:

JDBC and Relational Databases

General error can any body solve this problem

Greenhorn

Posts: 5

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I just created simple jsp file which is show me the data from database but when i run that program it will show me the java.sql.SQLException: General error. I give the code in below

file name is showData.jsp
[code=java]
<%@ page contentType="text/html" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>

<html>
<head>
<title>Showing data</title>
</head>
<body>
<%

out.println("welcom to my web-site");

%>

<%
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=null;
conn = DriverManager.getConnection("jdbc:odbc:employee1", "", "");
out.println ("Database Connected.");

}
catch(SQLException e)
{
out.println(e);
e.getStackTrace();
}
%>
</body>
</html>[/code]

Saif Asif

Ranch Hand

Posts: 439

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Greetings hitendra and welcome to the ranch,
Can you please show us the stack trace of the complete excpetion ?

java.sql.SQLException: General error

This is very abstract and general. The root cause may be in the log files. Also kindly use code tags since it becomes quite difficult to read code in text format.

Muhammad Saif Asif Mirza
OCJA(5/6) OCJP(6) OCJWCD(6)

hitendra dongare

Greenhorn

Posts: 5

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thank you for replying sir but i only get the only General error

Divya Chandel

Ranch Hand

Posts: 47

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Hitendra

Can you try with this-put e.printStackTrace(); in catch block then see,maybe it will work.

Divya
SCJP1.6

hitendra dongare

Greenhorn

Posts: 5

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i put it that on my code but it will not work still i get the same error message

Saif Asif

Ranch Hand

Posts: 439

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I see. Well there doesn't seem to be any fault with your code. Can you verify a couple of things on your end like the name of the driver ( is it present on the classpath and the lib folder ), also verify that you are using the correct Database name , also make sure that it has read/write privilages because I see that you have left the user name and password field as empty on the getConnection() method.

Muhammad Saif Asif Mirza
OCJA(5/6) OCJP(6) OCJWCD(6)

Saif Asif

Ranch Hand

Posts: 439

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hitendra dongare wrote:i put it that on my code but it will not work still i get the same error message

Can you paste the entire stack trace ? Also verify the things I have asked of you in my previous post.

Muhammad Saif Asif Mirza
OCJA(5/6) OCJP(6) OCJWCD(6)

hitendra dongare

Greenhorn

Posts: 5

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

yes i verify all things this program is run on eclipse but when i try to run on using web-browser it will not work. is their any configuration on Apache tomcat

Saif Asif

Ranch Hand

Posts: 439

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hitendra dongare wrote:yes i verify all things this program is run on eclipse but when i try to run on using web-browser it will not work. is their any configuration on Apache tomcat

How are you running it on eclipse and not on web-browser ? It is a JSP page, the only way to test it is to deploy it on tomcat and access it on web-browser .

Muhammad Saif Asif Mirza
OCJA(5/6) OCJP(6) OCJWCD(6)

hitendra dongare

Greenhorn

Posts: 5

posted 11 years ago