Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Java (http://www.go4expert.com/forums/java/)
-   -   Problem with JDBC (http://www.go4expert.com/forums/problem-with-jdbc-t19776/)

il912 16Oct2009 09:57

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)

nimesh 16Oct2009 13:39

Re: Problem with JDBC
 
Don't you need to open the connection?

il912 16Oct2009 16:25

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


satyedra pal 1Apr2010 15:04

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.

omid128 12Jul2010 15:26

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/


All times are GMT +5.5. The time now is 21:08.