I'm getting an weird error while accessing the database from JDBC driver in JSP using JAVA codes. plz help me to find a sollution the program and error details are below. Code: <%@ page import="java.sql.*" %> <%! Statement st; Connection con; %> <% try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:DSN"); st = con.createStatement(); ResultSet res = st.executeQuery("SELECT * FROM tbNameOne"); while(res.next()) { out.println(res.getString(1) + " " + res.getString(2) +"<br>"); } } catch(Exception e) { out.print(e.toString()); } %> these codes returns no error while building the project in NetBeans v6.1 running this file returns me a error message, given below In the ODBC Data Source, i have added the DSN correctly in both the tabs (user DSN and system DSN, in case i was added in the wrong tab, to be on the safe side i added on both of them). I am Using: OS: Windows 7 RC Database: Microsoft SQL Server 2000 IDE: NetBeans v6.1 (Server Apache TomCat)
the connection will be establish by jdbc, using given below code Code: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:DSN");
Problem is related to database connection.So check your connectivity as database setting .And you are using DSN keyword so rename it Perhaps you could solve your problem.
if you want to use JDBC I suggest you to use JDBC class from shine enterprise pattern it help you to set , the setting , it do all jobs for you it's easier and faster than that old jdbc. it has also soppurt hibernate here is the library and document : j2os.org http://SourceForge.net/projects/shine-enterpris/files/