[il912]

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.

<%@ 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]

Don't you need to open the connection?

[il912]

Quote:

Originally Posted by nimesh

Don't you need to open the connection?

the connection will be establish by jdbc, using given below code

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    con = DriverManager.getConnection("jdbc:odbc:DSN");

[satyedra pal]

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]

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/