Problem in fetching data from sql server 2005

[Maheswaran Devaraj]

Hi all,


I have tried to fetch the values from my table named sample. It contains one field, it was named id. While I try to fetch the data It will throw exception. Name of my datasource is Sample.

my code is following:
-----------------------

 package db;


import java.sql.*;
import java.util.*;

public class ConnectUrl {
	public static void main(String[] args) {
		Connection con=null;
		try {
			//load the driver
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			//obtaining a connection
			//con=DriverManager.getConnection("jdbc:sqlserver://localhost;"+"user=sa;password=sa");
			con = DriverManager.getConnection("jdbc:odbc:Sample;");
			if(con!=null){
			Statement stmt = con.createStatement();
			ResultSet rs =stmt.executeQuery("select * from sample");
			
			while (rs.next()) {
				System.out.println(rs.getInt(1));
			}
			}
			
			// Connection is ready to use
		      /*DatabaseMetaData meta = con.getMetaData();
		      System.out.println("Driver name: "+ meta.getDriverName());
		      System.out.println("Driver version: "+ meta.getDriverVersion());
		      System.out.println("Server name: "+ meta.getDatabaseProductName());
		      System.out.println("Server version: "+ meta.getDatabaseProductVersion());
		      System.out.println("Connection URL: "+ meta.getURL());
		      System.out.println("Login name: "+ meta.getUserName());
*/			if(con!=null){
			System.out.println("Connection ok");
		}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	
	/*public static void main(String[] args) {
		    Connection con = null;
		    try {
		      System.out.println("Before loading SQLServerDriver:");
		      listDrivers();

//		 Load Microsoft JDBC Driver 1.0
		      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		 
		      System.out.println("After loading SQLServerDriver:");
		      listDrivers();
		    } catch (Exception e) {
		      System.err.println("Exception: "+e.getMessage());
		    }
		  }
		  private static void listDrivers() {
		    Enumeration driverList = DriverManager.getDrivers();
		    while (driverList.hasMoreElements()) {
		      Driver driverClass = (Driver) driverList.nextElement();
		      System.out.println("   "+driverClass.getClass().getName());
		    }
		  
	}
*/
}
   

The exception is:
--------------------

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'sample'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at db.ConnectUrl.main(ConnectUrl.java:18)

help me to resolve the problem.

Thanks and Regards,
Mahes

[Rob Spoor]

You don't have a table called sample inside that datasource.

Moving to JDBC.

[Paul Sturrock]

...and why are you using the JDBC-ODBC bridge? You'll have fewer issues if you use a proper type 4 driver.