Creating JAR

[A Alqtn]

Hello All,

I have posted this https://coderanch.com/t/303446/JDBC/java/Creating-JAR topic on the JDBC forum but could not get any help.

I have created a simple Java application (ReadingAccessDB) that reads table rows from MS Access database. The program packages the java class file in jdbc folder (package jdbc; ), and the database file is one level up.

here is the code:

package jdbc;
 
import java.io.File;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
 
public class ReadingAccessDB {
  public static void main(String[] args) {
    Connection conn = null;
 
    try {
      // 1) Load the driver
      String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
      Class.forName(driver);
 
      // 2) Obtain a connection to the contacts database
      File file = new File("carpets.mdb");
      String databaseFile = file.getAbsolutePath();
      System.out.println("database path " + databaseFile);
      String url = "jdbc: odbc: Driver={Microsoft Access Driver (*.mdb)};DBQ=" + databaseFile;
      conn = DriverManager.getConnection(url, "", "");
 
      // 3) Create a JDBC statement for executing SQL expressions
      Statement statement = conn.createStatement();
 
      // 4) Execute an SQL expression and save the result in a ResultSet
      ResultSet result = statement.executeQuery("select * from members");
 
      // 5) Maniplute the result
      System.out.println("Got Results:");
      System.out.println("Member ID\t\tFirst Name\t\tLast Name");
      System.out.println("---------\t\t----------\t\t---------");
      while (result.next()) {
        int memberID = result.getInt("memberID");
        String firstName = result.getString("firstName");
        String lastName = result.getString("lastName");
        System.out.println(memberID + "\t\t\t" + firstName + "\t\t\t" + lastName);
      }
    }
    catch (ClassNotFoundException ex) {
      System.out.println("Failed to load MS Access driver");
    }
    catch (SQLException ex) {
      System.out.println("SQL Exception: " + ex.getMessage());
      ex.printStackTrace();
    }
    finally {
      // 6) Close the connection
      if( conn != null )
        try {
          conn.close();
        }
        catch (SQLException ex) {
          ex.printStackTrace();
        }
    }
  }
}

For example if the class file is in C:\jdbc\ReadingAccessDB.class, the database file "carpets.mdb" is in C:\

when using JVM "C:\java jdbc.ReadingAccessDB", the application works fine. However, I want to archive the application with the database file in a jar file so that it can be executed from any location. Could some one help

Alqtn

[ January 26, 2006: Message edited by: A Alqtn ]

[ January 26, 2006: Message edited by: A Alqtn ]
[ January 26, 2006: Message edited by: A Alqtn ]

[Ambika Kumar]

I think using ANT you can solve it.
As you know using build file can make use of jar file.

Here is a sample program in ANT. I am just tyring, it is not sure. Anyway try...

Description:

Here I have a file called "Hello.java" and it is inside "D:\AnT".
So change it with your file name and directory path to the specified file.

create a build file using this and

1) type -> ant compile
2) type -> ant jar
3) type -> ant run

or replace all with

ant compile jar run

Code is:


<project>

<target name="clean">
<delete dir="build"/>
</target>

<target name="compile">
<mkdir dir="build/classes"/>
<javac srcdir="D:\AnT" destdir="build/classes"/>
</target>

<target name="jar">
<mkdir dir="build/jar"/>
<jar destfile="build/jar/Hello.jar" basedir="build/classes">
<manifest>
<attribute name="Main-Class" value="Hello"/>
</manifest>
</jar>
</target>


<target name="run">
<java jar="build/jar/Hello.jar" fork="true"/>
</target>

</project>

Note:
I am new to ANT, so please forgive me if any mistake

[Maximilian Xavier Stocker]

Well to confirm what was said in your other thread and what I am pretty sure I told you a few days ago on another forum.

You cannot do this. You cannot embed your Access database in a jar and access it with JDBC. There are a number of technical impossibilities that make this a non-starter. You will have to ship the database as a seperate file (although you could deploy in one setup or zip file) and have it reside in a proper Windows directory.

There is no workaround that will make this (Access) work directly from a Jar.