Beginners problem

[Rasika Gopalakrishnan]

I am trying a JDBC connection for the first time. I have JDK 1.6, SQL Server 2005 and Microsoft's jdbc driver 3.0. The code goes:

package com.example;
import java.io.*;
import java.sql.*;
import java.util.*;
public class DBConnect
{
	private static Connection con;
	private static Statement stmt;
	public DBConnect()
	{
	}
	public static Connection getConnection() throws ClassNotFoundException,SQLException
	{
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=VisitorLog;","Rasika", "rasika");
		return con;
	}
	public static void closeConnection() throws SQLException
	{
		con.close();
	}
}

and the test class:

package com.example;
import java.sql.*;
import java.io.*;
import java.util.*;
public class DepartmentLookUp
{
	private static DBConnect db;
	private static Statement stmt;
	private static ResultSet rs;
	private static Connection con;
	public static void getDepartment()
	{
		try
		{
			stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery("Select * from DepartmentMaster;");
			while (rs.next()) 
			{  
                System.out.println("DEPARTMENT ID:"+ rs.getString("DepId"));
				System.out.println("DEPARTMENT NAME:" + rs.getString("DepName"));
            }  
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
	public static void main (String[] args)
	{
		try
		{
			db=new DBConnect();
			con=db.getConnection();
			getDepartment();
			db.closeConnection();
		}
		catch (Exception e1)
		{
			e1.printStackTrace();
		}
	}

}

no compiler errors, but on running the test class, i get the following message:


F:\EVM\classes>java com/example/DepartmentLookUp
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dbo.departmentmaster' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)
at com.example.DepartmentLookUp.getDepartment(DepartmentLookUp.java:18)
at com.example.DepartmentLookUp.main(DepartmentLookUp.java:36)

The database name is VisitorLog and table name is DepartmentMaster.

Please help!

Thanks and regards,
Rasika

[Rob Spoor]

Does user "Rasika" have enough rights to see that table?

[William P O'Sullivan]

Your statement has no schema prefix so it is defaulting to "dbo" for some reason.

If you know exactly what schema the table is under then add "schemaname." in front of departmentmaster.

WP

[Rasika Gopalakrishnan]

Rob Spoor wrote:Does user "Rasika" have enough rights to see that table?

Yes. The user has the rights to see the table.

[Rasika Gopalakrishnan]

William P O'Sullivan wrote:Your statement has no schema prefix so it is defaulting to "dbo" for some reason.

If you know exactly what schema the table is under then add "schemaname." in front of departmentmaster.

WP

The schema name displayed in the table properties is dbo.