Go4Expert - Problem with JDBC

Go4Expert (http://www.go4expert.com/)

- Java (http://www.go4expert.com/forumdisplay.php?f=21)

- - Problem with JDBC (http://www.go4expert.com/showthread.php?t=19776)

Problem with JDBC

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)

Re: Problem with JDBC

Don't you need to open the connection?

Re: Problem with JDBC

Quote:

Originally Posted by nimesh (Post 58897)

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");

Re: Problem with JDBC

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.

Re: Problem with JDBC

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/