Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 8 of 8

Thread: Cannot locate sun.jdbc.odbc.jbcOdbc driver

  1. #1
    Junior Member
    Join Date
    Nov 2010
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Exclamation Cannot locate sun.jdbc.odbc.jbcOdbc driver

    Hello, I am a current Java student and am having a problem when I run my compiled program from an in chapter lab assignment called "Stock Tracker". I receive a message from a dialog box "Cannot locate sun.jdbc.odbc.jbcOdbc Driver. Class not found exception creating database object. Following are a list of files that make up the whole program...

    Files copied over from the previous chapter's java files:
    Activator.class

    PasswordException.class
    PasswordExpiredException.class
    PasswordInternalException.class
    PasswordInvalidException.class
    PasswordSizeException.class
    PasswordUsedException.class
    Password.java (modified from previous chapter)

    Java source code files provided by the author of the book:
    STAction.java
    STLogon.java
    StockTracker.java
    User.java
    UserMaintFrame.java

    Files created in chapter for this excercise:
    MakeDB.java
    StockTrackerDB.java

    Created a database called "StockTracker" in Microsoft Access through Control panel- administrative tools - Data sources (ODBC)- system DSN tab - Add - Microsoft Access Driver *.mdb - create database. The database is stored in the same file as all the above files.

    In order to test the program, we must run the STLogon.java file. All the files compiled sucessfully. The following are the steps which I have taken to double check my work...

    1. Double checked the settings for the database in my control panel
    2. Wrote a sample program off the web to see if that could connect through the database driver - the program ran sucessfully.
    3. Printed the 2 files which I hand coded (MakeDB.java and StockTrackerDB.java) and checked for any entry errors.
    4. Copied the files to a flash drive and tried to run the program on another machine. Receievd the same error.

    The only other thing I could think of is maybe there is an issue with the way the java files were compiled or possibly using the wrong jdk. I installed TextPad which came with my text book on a cd. Later on, I installed NetBeans with a more current jdk (for troubleshooting purposes). All the files were compiled in TextPad since the installation of NetBeans. I then saved all those compiled files to a flash drive and copied them on another machine which only has TextPad on it. I guess I could try recompiling on the other machine which only has TextPad installed. BTW, both machines have Oracle Express Edition and Microsoft Visual Basic installed on them. I even tried signing in on both machines as an Administrator. There is no way to sign in as Administrator. However, both accounts on both machines have administrative rights. Both machines are running Windows Vista 32 bit.

    The MakeDB and StockTrackerDB code is listed below (just in case). The connection string is coded in the MakeDB.java file.

    Any advice would be greatly appreciated.



    Code for MakeDB.java file...

    import java.sql.*;
    import java.io.*;
     
    public class MakeDB
    {
    	public static void main(String[] args) throws Exception
    	{
    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     
    		String url = "jdbc:odbc:StockTracker";
     
    		Connection con = DriverManager.getConnection(url);
    		Statement stmt = con.createStatement();
     
    		// The following code deletes each index and table, if they exist.
    		// If they do not exist, a message is displayed and execution continues.
    		System.out.println("Dropping indexes & tables ...");
     
    		try
    		{
    			stmt.executeUpdate("DROP INDEX PK_UserStocks ON UserStocks");
     
    		}
    		catch (Exception e)
    		{
    			System.out.println("Could not drop primary key on UserStocks Table: "
    							+ e.getMessage());
    		}
     
    		try
    		{
    			stmt.executeUpdate("DROP TABLE UserStocks");
    		}
    		catch (Exception e)
    		{
    			System.out.println("Could not drop UserStocks table: "
    							+ e.getMessage());
    		}
     
    		try
    		{
    			stmt.executeUpdate("DROP TABLE Users");
    		}
    		catch (Exception e)
    		{
    			System.out.println("Could not drop Users table: "
    							+ e.getMessage());
    		}
     
    		try
    		{
    			stmt.executeUpdate("DROP TABLE Stocks");
    		}
    		catch (Exception e)
    		{
    			System.out.println("Could not drop Stocks table: "
    							+ e.getMessage());
    		}
     
    		////////// Create the database tables ///////////////
    		System.out.println("\nCreating tables ............");
     
    		// Create Stocks table with primary key index
    		try
    		{
    			System.out.println("Creating Stocks table with primary key index...");
    			stmt.executeUpdate("CREATE TABLE Stocks ("
    								+"symbol TEXT(8) NOT NULL "
    								+"CONSTRAINT PK_Stocks PRIMARY KEY, "
    								+"name TEXT(50)"
    								+")");
    		}
    		catch (Exception e)
    		{
    			System.out.println("Exception creating Stocks table: "
    							+ e.getMessage());
    		}
     
    		// Create Users table with primary key index
    		try
    		{
    			System.out.println("Creating Users table with primary key index...");
    			stmt.executeUpdate("CREATE TABLE Users ("
    								+"userID TEXT(20) NOT NULL "
    								+"CONSTRAINT PK_Users PRIMARY KEY, "
    								+"lastName TEXT(30) NOT NULL, "
    								+"firstName TEXT(30) NOT NULL, "
    								+"pswd LONGBINARY, "
    								+"admin BIT"
    								+")");
    		}
    		catch (Exception e)
    		{
    			System.out.println("Exception creating Users table: "
    							+ e.getMessage());
    		}
     
    		// Create UserStocks table with foreign keys to Users and Stocks tables
    		try
    		{
    			System.out.println("Creating UserStocks table ...");
    			stmt.executeUpdate("CREATE TABLE UserStocks ("
    								+"userID TEXT(20) "
    								+"CONSTRAINT FK1_UserStocks REFERENCES Users (userID), "
    								+"symbol TEXT(8), "
    								+"CONSTRAINT FK2_UserStocks FOREIGN KEY (symbol) "
    								+"REFERENCES Stocks (symbol))");
    		}
    		catch (Exception e)
    		{
    			System.out.println("Exception creating UserStocks table: "
    								+ e.getMessage());
    		}
     
    		// Create UserStocks table primary key index
    		try
    		{
    			System.out.println("Creating UserStocks table primary key index... ");
    			stmt.executeUpdate("CREATE UNIQUE INDEX PK_UserStocks "
    								+"ON UserStocks (userID, symbol) "
    								+"WITH PRIMARY DISALLOW NULL");
    		}
    		catch (Exception e)
    		{
    			System.out.println("Exception creating UserStocks index: "
    								+ e.getMessage());
    		}
     
     
    		// Create one administrative user with password as initial data
    		String userID = "admin01";
    		String firstName = "Default";
    		String lastName = "Admin";
    		String initialPswd = "admin01";
    		Password pswd = new Password(initialPswd);
    		boolean admin = true;
     
    		PreparedStatement pStmt =
    				con.prepareStatement("INSERT INTO Users VALUES (?,?,?,?,?)");
    		try
    		{
    			pStmt.setString(1, userID);
    			pStmt.setString(2, lastName);
    			pStmt.setString(3, firstName);
    			pStmt.setBytes(4, serializeObj(pswd));
    			pStmt.setBoolean(5, admin);
    			pStmt.executeUpdate();
    		}
    		catch (Exception e)
    		{
    			System.out.println("Exception inserting user: "
    								+e.getMessage());
    		}
     
    		pStmt.close();
     
    		// Read and display all User data in the database
    		ResultSet rs = stmt.executeQuery("SELECT * FROM Users");
     
    		System.out.println("Database created.\n");
    		System.out.println("Displaying data from database...\n");
    		System.out.println("Users table contains:");
     
    		Password pswdFromDB;
    		byte[] buf = null;
     
    		while(rs.next())
    		{
    			System.out.println("Logon ID        = "
    								+ rs.getString("userID"));
    			System.out.println("First name		= "
    								+ rs.getString("firstName"));
    			System.out.println("Last name			= "+rs.getString("lastName"));
    			System.out.println("Administrative		= "+rs.getBoolean("admin"));
    			System.out.println("Initial password	= "+initialPswd);
     
    			// Do NOT use with JDK 1.2.2 using JDBC-QDBC Bridge as
    			// SQL NULL data value is not handled correctly.
    				buf = rs.getBytes("pswd");
    				if (buf != null)
    				{
    					System.out.println("password Object	= "
    										+ (pswdFromDB=(Password)deserializeObj(buf)));
    					System.out.println("	AutoExpires		= "+ pswdFromDB.getAutoExpires());
    					System.out.println("	Expiring now	= "+ pswdFromDB.isExpiring());
    					System.out.println("	Remaining Uses	= "
    										+ pswdFromDB.getRemainingUses()+"\n");
    				}
    				else
    					System.out.println("Password Object	= NULL");
    			}
     
    			rs = stmt.executeQuery("SELECT * FROM Stocks");
    			if(!rs.next())
    				System.out.println("Stocks table contains no records.");
    			else
    				System.out.println("Stocks table still contains records!");
     
    			rs = stmt.executeQuery("SELECT * FROM UserStocks");
    			if(!rs.next())
    				System.out.println("UserStocks table contains no records,");
    			else
    				System.out.println("UserStocks table still contains records!");
     
    			stmt.close();	//closing Statement also closes ResultSet
     
    		}	//end of main()
     
    		// Method to write object to byte array and then insert into prepared statement.
    		public static byte[] serializeObj(Object obj)
    								throws IOException
    		{
    			ByteArrayOutputStream baOStream = new ByteArrayOutputStream();
    			ObjectOutputStream objOStream = new ObjectOutputStream(baOStream);
     
    			objOStream.writeObject(obj); // object must be Serializable
    			objOStream.flush();
    			objOStream.close();
    			return baOStream.toByteArray(); // returns stream as byte array
    		}
     
    		// Method to read bytes from result set into a byte array and then
    		// create an input stream and read the data into an object
    		public static Object deserializeObj(byte[] buf)
    								throws IOException, ClassNotFoundException
    		{
    			Object obj = null;
     
    			if (buf != null)
    			{
    				ObjectInputStream objIStream =
    					new ObjectInputStream(new ByteArrayInputStream(buf));
     
    				obj = objIStream.readObject(); // throws IOException, ClassNotFoundException
    			}
    			return obj;
    		}
    	}	// end of class
     
     
    Code for StockTrackerDB.java...
     
    import java.io.*;
    import java.sql.*;
    import java.util.*;
     
    public class StockTrackerDB
    {
    		private Connection con = null;
     
    		// Constructor: makes database connection
    		public StockTrackerDB() throws ClassNotFoundException,SQLException
    		{
    			if(con == null)
    			{
    				String url = "jdbc:odbc:StockTracker";
     
    		try
    		{
    			Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
    		}
    		catch(ClassNotFoundException ex)
    		{
    			throw new ClassNotFoundException(ex.getMessage() +
    						"\nCannot locate sun.jdbc.odbc.JdbcOdbcDriver");
    		}
     
    		try
    		{
    			con = DriverManager.getConnection(url);
    		}
    		catch(SQLException ex)
    		{
    			throw new SQLException(ex.getMessage()+
    					"\nCannot open database connection for "+url);
    		}
    	}
    }
     
    // Close makes database connection; null reference to connection
    public void close() throws SQLException,IOException,ClassNotFoundException
    {
    	con.close();
    	con = null;
    }
     
    // Method to serialize object to byte array
    private byte[] serializeObj(Object obj) throws IOException
    {
    	ByteArrayOutputStream baOStream = new ByteArrayOutputStream();
    	ObjectOutputStream objOStream = new ObjectOutputStream(baOStream);
     
    	objOStream.writeObject(obj); // object must be Serializable
    	objOStream.flush();
    	objOStream.close();
    	return baOStream.toByteArray(); // returns stream as byte array
    }
     
    // Method to deserialize bytes from a byte array into an object
    private Object deserializeObj(byte[] buf)
    					throws IOException, ClassNotFoundException
    {
    	Object obj = null;
     
    	if (buf != null)
    	{
    		ObjectInputStream objIStream =
    			new ObjectInputStream(new ByteArrayInputStream(buf));
     
    		obj = objIStream.readObject(); //IOException, ClassNotFoundException
    	}
    	return obj;
    }
     
    ////////////////////////////////////////////////////////////////////////////
    // Methods for adding a record to a table
    ////////////////////////////////////////////////////////////////////////////
    // add to the Stocks Table
    public void addStock(String stockSymbol, String stockDesc)
    			throws SQLException, IOException, ClassNotFoundException
    {
    	Statement stmt = con.createStatement();
    	stmt.executeUpdate("INSERT INTO Stocks VALUES ('"
    						+stockSymbol+"'"
    						+",'"+stockDesc+"')");
    	stmt.close();
    }
     
    // add to the Users table
    public boolean addUser(User user) throws SQLException,IOException,
    										ClassNotFoundException
    {
    	boolean result = false;
     
    	String dbUserID;
    	String dbLastName;
    	String dbFirstName;
    	Password dbPswd;
    	boolean isAdmin;
     
    	dbUserID = user.getUserID();
     
    	if(getUser(dbUserID) == null)
    	{
    		dbLastName = user.getLastName();
    		dbFirstName = user.getFirstName();
    		Password pswd = user.getPassword();
    		isAdmin = user.isAdmin();
     
    		PreparedStatement pStmt = con.prepareStatement(
    			"INSERT INTO Users VALUES (?,?,?,?,?)");
     
    		pStmt.setString(1, dbUserID);
    		pStmt.setString(2, dbLastName);
    		pStmt.setString(3, dbFirstName);
    		pStmt.setBytes(4, serializeObj(pswd));
    		pStmt.setBoolean(5, isAdmin);
    		pStmt.executeUpdate();
    		pStmt.close();
    		result = true;
    	}
    	else
    		throw new IOException("User exists - cannot add.");
     
    	return result;
    }
     
    // add to the UserStocks table
    public void addUserStocks(String userID, String stockSymbol)
    			throws SQLException,IOException,ClassNotFoundException
    {
    	Statement stmt = con.createStatement();
     
    	stmt.executeUpdate("INSERT INTO UserStocks VALUES ('"
    						+userID+"'"
    						+",'"+stockSymbol+"')");
    	stmt.close();
    }
     
    //////////////////////////////////////////////////////////////////
    // Methods for updating a record in a table
    //////////////////////////////////////////////////////////////////
     
    // updating the Users table
    public boolean updUser(User user) throws SQLException,IOException,
    										ClassNotFoundException
    {
    	boolean result = false;
     
    	String dbUserID;
    	String dbLastName;
    	String dbFirstName;
    	Password dbPswd;
    	boolean isAdmin;
     
    	dbUserID = user.getUserID();
     
    	if(getUser(dbUserID) != null)
    	{
    		dbLastName = user.getLastName();
    		dbFirstName = user.getFirstName();
    		Password pswd = user.getPassword();
    		isAdmin = user.isAdmin();
     
    		PreparedStatement pStmt = con.prepareStatement("UPDATE Users SET lastName = ? "
    								+" firstName = ?, pswd = ?, admin = ? WHERE userID = ?");
     
    		pStmt.setString(1, dbLastName);
    		pStmt.setString(2, dbFirstName);
    		pStmt.setBytes(3, serializeObj(pswd));
    		pStmt.setBoolean(4, isAdmin);
    		pStmt.setString(5, dbUserID);
     
    		pStmt.executeUpdate();
    		pStmt.close();
    		result = true;
    	}
    	else
    	throw new IOException("User does not exist = cannot update.");
     
    	return result;
    }
     
     
    ////////////////////////////////////////////////////////////////////
    // Methods for deleting a record from a table
    ////////////////////////////////////////////////////////////////////
     
    // delete a record from the Stocks table
    private void delStock(String stockSymbol)
    			throws SQLException,IOException,ClassNotFoundException
    {
    	Statement stmt = con.createStatement();
    	stmt.executeUpdate("DELETE FROM Stocks WHERE "
    						+"symbol = '"+stockSymbol+"'");
    	stmt.close();
    }
     
    // delete a record from the Users table
    public void delUser(User user) throws SQLException,IOException,
    										ClassNotFoundException
    {
    	String dbUserID;
    	String stockSymbol;
     
    	Statement stmt = con.createStatement();
     
    	try {
    		con.setAutoCommit(false);
     
    		dbUserID = user.getUserID();
    		if(getUser(dbUserID) != null)  // verify user exists in database
    		{
    			ResultSet rsl = stmt.executeQuery("SELECT userID, symbol "
    							+"FROM UserStocks WHERE userID = '"+dbUserID+"'");
    			while(rsl.next())
    			{
    				try
    				{
    					stockSymbol = rsl.getString("symbol");
    					delUserStocks(dbUserID, stockSymbol);
    				}
    				catch(SQLException ex)
    				{
    					throw new SQLException("Deletion of user stock failed: "
    											+ex.getMessage());
    				}
    			} // end of loop thru UserStocks
     
    			try
    			{  // holdings deleted, now delete user
    				stmt.executeUpdate("DELETE FROM Users WHERE "
    								+"userID = '"+dbUserID+"'");
    			}
    			catch(SQLException ex)
    			{
    				throw new SQLException("User deletion failed: "+ex.getMessage());
    			}
    		}
    		else
    			throw new IOException("User not found in database - cannot delete.");
     
    			try
    			{
    				con.commit();
    			}
    			catch(SQLException ex)
    			{
    				throw new SQLException("Transaction commit failed: "+ex.getMessage());
    			}
    		}
    		catch (SQLException ex)
    		{
    			try
    			{
    				con.rollback();
    			}
    			catch (SQLException sqx)
    			{
    				throw new SQLException("Transaction failed then rollback failed: "
    										+sqx.getMessage());
    			}
     
    			// Transaction failed, was rolled back
    			throw new SQLException("Transaction failed: was rolled back: "
    									+ex.getMessage());
    		}
     
    		stmt.close();
    	}
     
    	// delete a record from the UserStocks table
    	public void delUserStocks(String userID, String stockSymbol)
    				throws SQLException,IOException,ClassNotFoundException
    	{
    		Statement stmt = con.createStatement();
    		ResultSet rs;
     
    		stmt.executeUpdate("DELETE FROM UserStocks WHERE "
    							+"userID = '"+userID+"'"
    							+"AND symbol = '"+stockSymbol+"'");
     
    		rs = stmt.executeQuery("SELECT symbol FROM UserStocks "
    								+"WHERE symbol = '"+stockSymbol+"'");
     
    		if(!rs.next()) // no users have this stock
    			delStock(stockSymbol);
     
    		stmt.close();
     
    	}
     
    /////////////////////////////////////////////////////////////////////
    // Methods for listing record data from a table
    // Ordered by:
    //		methods that obtain individual field(s),
    //		methods that obtain a complete record, and
    //		methods that obtain multiple records
    ////////////////////////////////////////////////////////////////////
     
    // Methods to access one or more individual fields
     
    // get a stock description from the Stocks table
    public String getStockDesc(String stockSymbol)
    				throws SQLException, IOException, ClassNotFoundException
    {
    	Statement stmt = con.createStatement();
    	String stockDesc = null;
     
    	ResultSet rs = stmt.executeQuery("SELECT symbol, name FROM Stocks "
    									+"WHERE symbol = '"+stockSymbol+"'");
    	if(rs.next())
    		stockDesc = rs.getString("name");
    	rs.close();
    	stmt.close();
     
    	return stockDesc;
    }
     
     
    // Methods to access a complete record
     
    // get User data from the Users table
    public User getUser(String userID) throws SQLException, IOException,
    										ClassNotFoundException
    {
    	Statement stmt = con.createStatement();
     
    	String dbUserID;
    	String dbLastName;
    	String dbFirstName;
    	Password dbPswd;
    	boolean isAdmin;
     
    	byte[] buf = null;
    	User user = null;
    	ResultSet rs = stmt.executeQuery("SELECT * FROM Users WHERE userID = '"
    									+userID+"'");
    	if(rs.next())
    	{
    		dbUserID = rs.getString("userID");
    		dbLastName = rs.getString("lastName");
    		dbFirstName = rs.getString("firstName");
     
    		// Do NOT use with JDK 1.2.2 using JDBC-ODBC bridge as
    		// SQL NULL data value is not handled correctly.
    			buf = rs.getBytes("pswd");
    			dbPswd=(Password)deserializeObj(buf);
     
    			isAdmin = rs.getBoolean("admin");
    			user = new User(dbUserID,dbFirstName,dbLastName,dbPswd,isAdmin);
    		}
    		rs.close();
    		stmt.close();
     
    		return user; // User object created for userID
    	}
     
     
    	// Methods to access a list of records
     
    	// get list of selected fields for all records from the Users Table
    	public ArrayList listUsers() throws SQLException,IOException,
    										ClassNotFoundException
    	{
    		ArrayList aList = new ArrayList();
    		Statement stmt = con.createStatement();
     
    		ResultSet rs = stmt.executeQuery("SELECT userID, firstName, lastName, admin "
    										+"FROM Users ORDER BY userID");
     
    		while(rs.next())
    		{
    			aList.add(rs.getString("userID"));
    			aList.add(rs.getString("firstName"));
    			aList.add(rs.getString("lastName"));
    			aList.add(new Boolean(rs.getBoolean("admin")));
    		}
     
    		rs.close();
    		stmt.close();
     
    		return aList;
    	}
     
    	// get all fields in all records for a given user from the Userstocks table
    	public ArrayList listUserStocks(String userID) throws SQLException,IOException,
    														ClassNotFoundException
    	{
    		ArrayList aList = new ArrayList();
    		Statement stmt = con.createStatement();
     
    		ResultSet rs = stmt.executeQuery("SELECT * FROM UserStocks "
    										+"WHERE userID = '"+userID+"' ORDER BY symbol");
    		while(rs.next())
    			aList.add(rs.getString("symbol"));
     
    		rs.close();
    		stmt.close();
     
    		return aList;
    	}
    }
    Last edited by copeg; November 5th, 2010 at 04:57 PM.


  2. #2
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,370
    Thanks
    183
    Thanked 836 Times in 779 Posts
    Blog Entries
    5

    Default Re: Cannot locate sun.jdbc.odbc.jbcOdbc driver

    You need the driver on the classpath, without which the driver cannot be found when you call Class.forName. So, you first must find the driver .jar file for the database you are using, then add it to the classpath (see Classpath)

  3. #3
    Junior Member
    Join Date
    Nov 2010
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Cannot locate sun.jdbc.odbc.jbcOdbc driver

    Thank you copeg for the prompt response. I am reading your comment about the .jar file. I looked at your link on setting the class path and am confused. I tried googling more about the class path on google and came across this link JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver Here is the first paragraph on that site...

    "According to the JDK documentation, sun.jdbc.odbc.JdbcOdbcDriver is the driver class name of the JDBC-ODBC Bridge driver, and the driver class is included in the JDK RTE (Run-Time Environment). So no need to specify any JAR file in the classpath."

    I have no idea where the access database jar file could be. All I know is I saved the database to the same folder as the rest of the files needed to run the application. The thing that confuses me is that most of my class got this program to run with no problems. All they did was create a new database through the Windows Data sources, selected a file directory then compiled all the files and ran the application.

    I don't know where to go from here. Please advise.

  4. #4
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,370
    Thanks
    183
    Thanked 836 Times in 779 Posts
    Blog Entries
    5

    Default Re: Cannot locate sun.jdbc.odbc.jbcOdbc driver

    Should have noticed this before...check the spelling of your driver class. The following...
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
    ...are different.

  5. The Following User Says Thank You to copeg For This Useful Post:

    birdlover2010 (November 5th, 2010)

  6. #5
    Junior Member
    Join Date
    Nov 2010
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Cannot locate sun.jdbc.odbc.jbcOdbc driver

    You are a genius! It was supposed to be an uppercase J in the StockTrackerDB code. I obviously overlookked it. It now works! Many thanks!!!!!!!!!!!!!!!!

  7. #6
    Junior Member
    Join Date
    Nov 2010
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Cannot locate sun.jdbc.odbc.jbcOdbc driver

    Hello again, I hate to write this, but after I responded that the program was working, I received another error from the message dialog box "[Microsoft][ODBC Microsoft Access Driver]Syntax error (missing operator) in query expression ‘Pa_RaM000 firstName = Pa_RaM001’." I tried searching the web to understand what that means. I was reading if you use a prepared statement you don't need single quotes. I guess I am having a hard time understanding how Access communicates with Java in the first place. I have been going over the code in the MakeDB and StockTrackerDB until my eyes are cross eyed. I received another message prior to that about accessing the users table and that it was a syntax error. Am I even looking in the right files for the error? Again, this whole lab was written in my textbook so it should work just from copying the code. I obviously must have made some kind of typo but can't find it.

    Any help would be greatly appreciated.

  8. #7
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,370
    Thanks
    183
    Thanked 836 Times in 779 Posts
    Blog Entries
    5

    Default Re: Cannot locate sun.jdbc.odbc.jbcOdbc driver

    It helps tremendously to provide information about where those errors are being thrown, the full stack trace of any exceptions, and any input you provided.

  9. #8
    Junior Member
    Join Date
    Nov 2010
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Cannot locate sun.jdbc.odbc.jbcOdbc driver

    Thank you copeg for the reply. When I run the application, the first screen that comes up is a logon screen which shows "Stock Tracker" on the title bar. I type the default user which is admin01, default password which is admin01. After I click the logon button to log in, now I am getting the error "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Users'. Make sure it exists and that its name is spelled correctly." There are no other messages that come up.

Similar Threads

  1. How to instal JDBC driver package in eclipse
    By sathish in forum JDBC & Databases
    Replies: 2
    Last Post: September 2nd, 2010, 11:09 AM
  2. How to install a JDBC driver in Eclipse? And where to take it from?
    By noFear in forum Java Theory & Questions
    Replies: 2
    Last Post: August 17th, 2010, 11:51 AM
  3. JDBC
    By Abdul Rasheed in forum JDBC & Databases
    Replies: 1
    Last Post: August 13th, 2010, 08:01 AM
  4. Project using JavaBeans, JSP & ODBC.
    By m.b.taylor in forum Paid Java Projects
    Replies: 0
    Last Post: July 15th, 2010, 10:36 AM
  5. Replies: 6
    Last Post: August 30th, 2009, 05:31 AM