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)
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
Don't you need to open the connection?
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");
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.
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/