Novice in JDBC

[Rashid Ali]

I want to make connection to my database file of MS Access with my Java application but it is not being established even after i have followed up the book instructions.
Could anybody guide me how could i do it easily or can suggest a tutorial or article which can help me to do so.
Thanks in advance for your time and suggestion
Raashed Ali

[Nathanael Ulrick]

I've been able to do this successfully... what did the instructions in the book say?

[Rashid Ali]

Thanks for your reply. I am try to connect with my 'Book.mdb' file through the following code. I created the 'User DSN' connection of Book.mdb and it's appearing well in the list.
Further, when I try to run the code it runs and shows the runtime error something like below on DOS but creates the GUI well as desired:
"java.sql.SQLException: [...][Microsoft Access Driver Manager]Data source name or the established driver which is appointed are not found." something like this as far as i remember.
Could anybody suggest me what i am mistaking in establishing the connection with my database.
Thank you very much in advance for your help...
Rashid Ali
==========

package Database;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.util.*;
public class TryDatabase extends JFrame
{
   Connection connection ;
   private Statement statement ;
   private JTable table ;
   private ResultSet resultSet ;
   private JTextArea inputQuery ;
   private ResultSetMetaData rsMetaData ;
   public TryDatabase()
   {
      // load the driver to allow connection to database
      try
      {
          Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
          String sourceURL = "jdbc   [img]http://www.javaranch.com/ubb/redface.gif[/img]dbc:Books" ;
          connection = DriverManager.getConnection( sourceURL ) ;
      }
      catch( ClassNotFoundException cnfe )
      {
          System.err.println( cnfe ) ;
      }
      catch( SQLException sqle )
      {
          System.err.println( "Unable to connect" ) ;
          sqle.printStackTrace() ;
          System.exit( 1 ) ; // terminate the program
      }
      inputQuery = new JTextArea( "SELECT * FROM Books" , 4 , 30 ) ;
      final JButton submitQuery ;
      submitQuery = new JButton( "Submit Query" ) ;
      submitQuery.addActionListener(
          new ActionListener()
          {
              public void actionPerformed( ActionEvent e )
              {
                  if ( e.getSource() == submitQuery )
                  getTable();
              }
          }
      );
      JPanel topPanel = new JPanel() ;
      topPanel.setLayout( new BorderLayout() );
      topPanel.add( new JScrollPane( inputQuery ) ,
          BorderLayout.CENTER ) ;
      topPanel.add( submitQuery, BorderLayout.SOUTH ) ;
      table = new JTable ( 4 , 4 ) ;
      Container c = getContentPane() ;
      c.setLayout( new BorderLayout() ) ;
      c.add( topPanel , BorderLayout.NORTH ) ;
      c.add( table , BorderLayout.CENTER ) ;
      getTable() ;
      setSize( 500 , 500 ) ;
      show() ;
    }
   private void getTable()
   {
        try
        {
            String query = inputQuery.getText();
            statement = connection.createStatement();
            resultSet = statement.executeQuery( query ) ;
            displayResultSet( resultSet ) ;
        }
        catch ( SQLException sqlex )
        {
            sqlex.printStackTrace() ;
        }
   }
   private void displayResultSet( ResultSet rs )
         throws SQLException
   {
         boolean moreRecords = rs.next() ;
         if ( ! moreRecords )
         {
             JOptionPane.showMessageDialog( this,
                "ResultSet contained no records" ) ;
             setTitle( "No records to display" ) ;
             return ;
         }
         Vector columnHeads = new Vector() ;
         Vector rows        = new Vector() ;
         try
         {
             // get column heads
             ResultSetMetaData rsmd = rs.getMetaData() ;
             for ( int i = 1 ; i <= rsmd.getColumnCount() ; ++i )
                 columnHeads.addElement( rsmd.getColumnName( i ) ) ;
             // get row data
             do
             {
                 rows.addElement( getNextRow( rs , rsmd ) ) ;
             }
             while ( rs.next() ) ;
             // display table with ResultSetContents
             table = new JTable(rows , columnHeads ) ;
             JScrollPane scroller = new JScrollPane( table ) ;
             Container c = getContentPane() ;
             c.remove( 1 ) ;
             c.add( scroller , BorderLayout.CENTER ) ;
             c.validate() ;
         }
         catch ( SQLException sqlex )
         {
             sqlex.printStackTrace() ;
         }
   }
   private Vector getNextRow( ResultSet rs ,
                               ResultSetMetaData rsmd )
        throws SQLException
   {
        Vector currentRow = new Vector() ;
        for( int i = 1 ; i <= rsmd.getColumnCount() ; ++i )
            switch( rsmd.getColumnType( i ) )
            {
                case Types.VARCHAR :
                case Types.LONGVARCHAR :
                    currentRow.addElement( rs.getString( i ) ) ;
                  break ;
                case Types.INTEGER :
                    currentRow.addElement(
                       new Long( rs.getString( i ) ) ) ;
                  break ;
                default :
                  System.out.println( "Type was : " +
                      rsmd.getColumnTypeName( i ) ) ;
            }
        return currentRow ;
   }
   public void shutDown()
   {
        try
        {
            connection.close() ;
        }
        catch ( SQLException sqlex )
        {
            System.err.println( "Unable to disconnect" ) ;
            sqlex.printStackTrace() ;
        }
   }
   public static void main( String args[] )
   {
       final TryDatabase app = new TryDatabase() ;
       app.addWindowListener(
          new WindowAdapter()
          {
              public void windowClosing( WindowEvent e )
              {
                  app.shutDown();
                  System.exit( 0 );
              }
          }
       );
   }
}

[This message has been edited by Rashid Ali (edited August 20, 2001).]
[This message has been edited by Rashid Ali (edited August 21, 2001).]

[Jamie Robertson]

can't tell what your url actually is due to the smilie face formatting, but you may be missing a colon.
String sourceURL = "jdbc dbc:Books" ;
NOPE! I just read mine after the formatting and it turned out the same! I don't use the smilies too much so I wasn't sure...eek ! , I guess I was a little confused .
Jamie

[This message has been edited by Jamie Robertson (edited August 20, 2001).]

[Jamie Robertson]

Tutorial from sun: http://java.sun.com/docs/books/tutorial/jdbc/basics/connecting.html
Jamie

[Rashid Ali]

Thanks Jamie for your kind replies but the problem is still there... I have gone through the tutorial as suggested but i have set all the requirement of it and even it is not establishing the connection. Please look into the above example ???
Please help...
Kind regards
Rashid

[Nathanael Ulrick]

I noticed you're trying to get the connection without using a username or password. What happens if you specify the username and password as arbitrary String fields?

[Marcos Maia]

Nathanael is problably right just try leaving the place for the username and password empty if you don�t have to autenticate this is a commom mistake try it like this:
connection = DriverManager.getConnection( sourceURL,"","");

[Ming_chen]

Your data source name is "Book.mdb", but you use "jdbc dbc:Books" in your DriverManager.getConnection(), remove "s" of "Books", it should work, otherwise you should check if your data source is created correctly.
[This message has been edited by Ming_chen (edited August 22, 2001).]

[Rashid Ali]

Thank you all very very much for your kind help and suggestions.
Actually the problem was that I was not giving the correct table name but was only providing the database name which caused that the connection could not establish due to the wrong table name and it did not work even though all the codes was okay and the file name was also ok but the table name was not Now it works fine and provide the desired results...
Thank you very much again for participating and helping...
Kind regards
Rashid ali
I LOVE JAVARANCH