Uhmm.. I need to connect to a database by calling the ODBC jar file and getting the password from a textfile..
I'm not sure on how I can do that since I am a newbie with database in Java.. I'm using an access database.. I can retrieve the password and even print it but its the database i'm going to have a problem with..
Any ideas on how I should go about doing this?
Thanks in advance..
-ArchBytes-
First, make a DSN ( DataSource Name ) for the particular .mdb ( Access ) file that you want to connect to ( Data Sources ( ODBC ) under Control Panel in Windows ).
Assuming you give it the name 'MyDSN',
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = null;
try
{
con = DriverManager.getConnection("jdbc:odbc:MyDSN","username","password");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from mytable");
while ( rs.next() )
{
System.out.println(rs.getString(1));
}
}//end of try
catch ( Exception e )
{
System.out.println('Encountered exception " + e );
}//end of catch
finally
{
if ( rs != null )
rs.close();
if ( st != null )
ss.close();
if ( con != null )
con.close();
}//end of finally
That ought to get you started....
More here:
http://www.javacoffeebreak.com/articles/jdbc/
ok so i was able to do those stuff.. when I ran it in eclipse it worked perfectly..
but when I ran it in the command prompt.. it had an exception..
Exception in thread "main" java.lang.NoClassDefFoundError: JarFileCaller
what does this mean..? why won't it run from the command prompt..?
It's working fine on mine....though there are lots of errors in the code I posted!
I think you need to set the classpath correctly. Are you using some other packages? Some JAR files? They may not be in the classpath. Have you tried running just the database connection code?
import java.sql.*;
public class testDB
{
public static void main ( String args[] )
{
testDB tdb = new testDB();
tdb.trythis();
}
public void trythis()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = null;
Statement st = null;
ResultSet rs = null;
try
{
con = DriverManager.getConnection("jdbc:odbc:mytable","username","password");
st = con.createStatement();
rs = st.executeQuery("select * from users");
while ( rs.next() )
{
System.out.println(rs.getString(1));
}
}//end of try
catch ( Exception e )
{
System.out.println("Encountered exception " + e );
}//end of catch
finally
{
try
{
if ( rs != null )
rs.close();
if ( st != null )
st.close();
if ( con != null )
con.close();
}
catch( Exception e )
{
System.out.println("Exception while closing: " + e );
}
}//end of finally
}
catch ( Exception e )
{
}
}
}
If even just this doesn't work, then you're missing the JDBC-ODBC drivers, you'll have to add the path of the JARs to the classpath.
