Problem with JDBC

il912's Avatar, Join Date: Oct 2009
Newbie Member
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
Quote:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
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)
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
Don't you need to open the connection?
0
il912's Avatar, Join Date: Oct 2009
Newbie Member
Quote:
Originally Posted by nimesh View Post
Don't you need to open the connection?
the connection will be establish by jdbc, using given below code
Code:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    con = DriverManager.getConnection("jdbc:odbc:DSN");
0
satyedra pal's Avatar, Join Date: Mar 2010
Contributor
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.
0
omid128's Avatar, Join Date: Jul 2010
Go4Expert Member
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/