Embed MS Access Database With Runnable Jar?

May 13, 2014

my aim is to make a runnable jar. I've made a program using swings which uses MS Access database to fetch records. So, I've used an absolute path to refer to the database for connection. Now, I intend to distribute this runnable jar to other people as well. So I guess the best option would be to embed the MS Access database as well in the jar file. But I don't know how to do that. Where should I keep the database in my Project Explorer ? Should I use a relative path etc.

This is my code:-

Java Code:

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;

[code]....

View Replies


ADVERTISEMENT

Runnable Jar Does Not Show Data From Database

Mar 13, 2014

I am still working on my java course and now we have to create a jar file from a previous project (this is a project where a connection to the database is made and data is shown in a frame).

When I follow the instruction in my course material I don't get it to work. I've tried the following:

1. Open eclipse on windows xp
2. Right click on the project folder in eclipse
3. Click on "export" in the menu that appears
4. Choose "runnable jar"
5. click next
6. I insert the following parameters:

- Launch configuration --> I select my main class
- export destination --> I select the folder D:
- library handling --> Package required libraries into generated jar

7. click Finish

This is what happens when I dbl click the jarfile (wampserver is running):

1. I get an error: "SQL ERROR: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."

2. I click ok on the message and the following message appears: "SQL Error: null"

3. I click ok on this message and the frame with the fields appears without data from the database.

This is a crosspost to: [URL] ...

View Replies View Related

Using MS Access Database In Java

Mar 19, 2014

I want to make a database and use it in my java program. I am thinking of using MS Access database, although I m not very sure, sine I will have to use this data later in the SQL database as part of C# program.

How to start to create and use MS database in java program.

I have seen in one tutorial that the steps are:

1. Install your database management system (DBMS) if needed

2.Install a JDBC driver from the vendor of your database

but I am not familiar with this. Any example, or is this above compulsory?

View Replies View Related

Insert Data Into Access Database

Mar 29, 2014

I need my java program to insert data into my access database. I get no errors in my code, but it never inserts, deletes the data in my database. Here is my code:

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
 public class INS extends Frame implements ActionListener{
Frame f;
Label l1, l2;
TextField t1, t2;
Button b1, b2, b3, b4, b5;
Connection c;

[Code] ....

View Replies View Related

Servlets :: Access List Of Database Records Using JSP?

Apr 3, 2014

How we can get the list of records from database my sql using jsp pages and servlets so that it show results on webpage.

View Replies View Related

Designing Jar File Where Access Of Certain Database Provided Through API

Jan 30, 2015

I'm given a task to generate an API (a jar file) where the access of a certain database is provided through the API. basic functionality: Client sends a query through the API to server and the Server responds with data.Since its and API, do I have to implement the code or is it enough if i gave just interfaces? what are the OOP concepts to focus on when designing a good API.

View Replies View Related

How To Insert Cachedrowset Data Into MS Access Database

Feb 11, 2015

I'm new to java and trying to insert data from a cachedrowset into MS Access database, Below is the error code that I get after running my program.

java.sql.SQLException: Parameter-Set has missing values.

The SQL test table that I am using.

Java Code:

create table book (
TITLE_ID CHAR(3 BYTE)
TITLE_NAME VARCHAR2(40 BYTE)
TYPE VARCHAR2(10 BYTE)
PUB_ID CHAR(3 BYTE)
PAGES NUMBER(38,0)
PRICE NUMBER(5,2)
SALES NUMBER(38,0)
PUBDATE DATE
CONTRACT NUMBER(38,0)
); mh_sh_highlight_all('java');

SQL table values with blanks:

Java Code: TITLE_ID TITLE_NAME TYPE PUB_ID PAGES PRICE SALES PUBDATE CONTRACT
T01Java history P0111121.99 566 01-AUG-001
T02Oracle history P0311419.95 9566 01-APR-981
T03SQL computer P0212239.95 25667 01-SEP-001
T04C++ psychologyP0451112.99 13001 31-MAY-991
T05Python psychologyP041016.95 201440 01-JAN-011

[code]....

Below is the piece of java code that I am using.

Java Code:

public void insertAccessTable(Connection connection, CachedRowSet CRS_insertAccess) throws Exception
{
try
{
RowSetMetaData metaData = (RowSetMetaData)CRS_insertAccess.getMetaData();
ArrayList<ArrayList<String>> TwoDimArrList = new ArrayList<ArrayList<String>>();
TwoDimArrList.add(new ArrayList<String>());
TwoDimArrList.add(new ArrayList<String>());
ArrayList<String> ColArrList = new ArrayList<String>();
for (int column = 1; column <= metaData.getColumnCount(); column++) {

[code]....

View Replies View Related

JSP :: Embed Into HTML Page?

Jan 5, 2015

How to embed jsp into html page?

View Replies View Related

Embed Java Applet In HTML

May 8, 2013

When I embed java applet in html the "ClassNotFoundException" message appear to me, how to overcome this ....

View Replies View Related

Query Embed In JAVA Returns NULL

Oct 4, 2014

I have embed a query in the JAVA to retrieve the data from the back end and I use Oracle for back end. What I'm trying to do is in my query has been shown below. The issue here is that result set returns the NULL. But fine when I change the query "SELECT 5 FROM DUAL" and it returns 5 for me which right. When I try to run the same at the back end as a query I'm getting proper result.
 
public String getReturnPart(String partNumberIn) {
//int returnPartNumber = 0;
  String query =
"SELECT COUNT(*) AS CHECK1 FROM PART_MASTER PM,UNITS_OF_MEASURE UOM WHERE PM.PART_NUMBER = '" +  partNumberIn
  + "' AND PM.UNIT_OF_ISSUE = UOM.UNIT_OF_MEASURE AND UOM.UNIT_TYPE = 0 ";
  //String query = "SELECT 5 AS CHECK1  FROM DUAL"; This returns fine as "5"
  ResultSet result = null;

[Code] ....

View Replies View Related

Servlets :: Create A Service To Embed Widgets On Any Foreign Website

Jan 22, 2015

Its required to create a service to embed widgets on any foreign website(server), using servlets where i'll pass encrypted widgetId and in turn i will get html for displaying it on screen. Also a refresh button with the embedded widget is to be provided so as to fetch updated computed data. The point is that user should copy some html/script code and place it on his website.

I am thinking of following approach.An empty span with id, followed by a js script to make ajax call to the server to get widget HTML.

View Replies View Related

Embed Existing JAVA Applet To New Standalone Swing Application

Oct 9, 2014

I want to embed an existing JAVA applet in to my swing application which is a standalone application. The applet is used in some other application which is not developed by me or my company. The application is open source application (So I have the source code). The entire existing application is basically one of the parts of my new application.

View Replies View Related

Export To Runnable Jar

Oct 29, 2014

My app uses docx4J, XStream, and also uses an image on the start page. I placed all of this external libraries in Java Buid Path and in Eclipse it all works well but when I export all data to runnable jar file it doesn't work.

View Replies View Related

Paint In Thread Or Runnable

Jun 25, 2014

import java.awt.Graphics;
import javax.swing.JFrame;
class node{
node(int a,node next){
this.a=a;this.next=next;

[Code] ....

The code was ran not right, I want it's result is: 1 2 3 4 5 and delay(1000) every time that it prints a number

Example: 1 (delay(1000)) 2 (delay(1000)) ....

And the paint must do that

View Replies View Related

Using JarOutputStream To Create A Runnable Jar File

Apr 26, 2014

How does one use java.util.jar.JarOutputStream to create a jar file on button press? This new jar file, I want to make it runnable so it performs a specific action on run..

View Replies View Related

Running Threads Without Using Runnable Implementation?

Dec 16, 2014

I've seen examples that don't use a separate Runnable Implementation, but Instead Just make a subclass of Thread and override the Thread's runO method. That way,you call the Thread's no--arg constructor when you make the new thread;

Thread t = new Thread(); 1/no Runnable"

Any simple code that demonstrates the same. I haven't fully understood what is said in the text above. I have a hunch that the last line is wrong and it should be Thread t = new <Whatever class extends Thread class and over rides its run method>()

Am I correct or wrong....

View Replies View Related

Multiple Runnable In A Single Class

Aug 1, 2014

I want to have two threads running in my class, one will be downloading info from a website then putting the thread to sleep for a little bit, then repeating. The other will be sending information to a website then putting the thread to sleep for a little bit, then repeating. Is it possible to do this in my main class? I already have one thread using run() for downloading the info and sleeping can i make another?

View Replies View Related

Java-8 :: Deploying Runnable JAR Files

Jan 21, 2015

I recently started working with Java 8.  I have been doing Java development on and off since the early 1990's.  Most recently I have been doing all my current work in Java 6.  I decided to "take the plunge" and to start getting involved with Java 8.  I have an imaging application for geologic research I started working on in Java 6 and Swing, and I am now continuing that development under Java 8.  It was a pleasant surprise that to find that all of my code built without any changes (I'm using Eclipse Luna and just deleted the Java 6 runtime and added the Java 8 runtime after downloading it).  The application launches fine from inside Eclipse.
 
However I ran into a problem when exporting the application from Eclipse to a runnable JAR file and then trying to launch it.  After creating the runnable JAR I was not able to launch it by simply double clicking.  A command line box would open for a second, then close and the application window would never open.  To upgrade from Java 6 to Java 8 I only downloaded the Java 8 runtime environment, not the Java 8 JDK.  I am working in Windows 7 and tried updating the JAR file associations and experimented with various path entries in my environment variables.  No mater what I did I could not simply double click the runnable JAR to launch it.
 
Then I deleted all my Java downloads and started over.  This time all I did was downloaded the Java 8 JDK and installed it.  I then pointed Eclipse to the Java 8 runtime environment that was installed with the Java 8 JDK.  My code built and executed perfectly in the Eclipse environment.  Then I exported the the Eclipse project as a runnable JAR again and tried to launch it.  This time it worked as expected.  Double clicking the runnable JAR launched the application!
 
So my question is if I want to give this application to someone to run (i.e. deploy it) that is not a developer, do I have to have them install the Java 8 JDK?  I assumed that all someone would need to run the application as a runnable JAR is the Java 8 runtime environment, not the JDK.  However, when I had only the Java 8 runtime environment installed I could not launch the runnable JAR.  With the Java 8 JDK I was able to run the runnable JAR as expected, with no problem.

View Replies View Related

Running A Runnable Jar From Command Prompt

Dec 16, 2013

C:Users
swarnajar>java -cp C:PROJECTSDCDEDashboard(WorkingCopy)warWEB-INF
lib*.jar -Ddcde.bootstrap.location=C:PROJECTSDCDEDashboard(WorkingCopy)prop
erties -jar qaqc.jar

[Code]....

View Replies View Related

Creating Instance Of A Class That Implements Runnable

Jul 31, 2014

I'm reading about threads In Head First Java and the way an Instance of a class that Implements Runnable Is created confuses me a little.

public class MyRunnable implements Runnable ......
Runnable ThreadJob = new MyRunnable();

I thought I had to use this syntax :

MyRunnable ThreadJob =new MyRunnable();

View Replies View Related

Export Runnable Jar File That Requires LWJGL

Aug 13, 2014

I'm trying to export a runnable jar file that requires lwjgl. Everything works in eclipse as I'm using

-Djava.library.path=nativewindows

as a VM Argument for the jinput .dll files.

After exporting & launching the jar it doesn't work of course! I get this error:

java.lang.UnsatisfiedLinkError: no junput-dx8 in java.library.path

I'm not sure how to make it work outside of eclipse....

View Replies View Related

Extracting Eclipse Project As Runnable Java Not Working

Feb 5, 2014

I've been working quite a bit with a login system the past couple of months and I now have a version that I would like to try "for real" by extracting it as a runnable .jar or .exe file. I've looked at a couple of guides that told me how to do this properly, but even after following every step precisely it didn't work.

One of the guides I tried: 3 Ways to Create an Executable File from Eclipse - wikiHow

Double clicking the file or selecting it and pressing enter does nothing, the computer loads for a second and then nothing happens. I don't receive any visible errors when extracting the program, either.

However, when running the file from the command prompt I do receive an odd error:
Microsoft Windows [Version 6.2.9200]
(c) 2012 Microsoft Corporation. All rights reserved.

C:UsersUserName>java -jar Login.jar
Exception in thread "main" java.lang.IllegalArgumentException: input == null!
at javax.imageio.ImageIO.read(Unknown Source)
at LoginSystem.Data.updateData(Data.java:347)
at LoginSystem.Data.<init>(Data.java:309)
at LoginSystem.MainFrame.<init>(MainFrame.java:42)
at LoginSystem.MainFrame.main(MainFrame.java:457)

C:UsersUserName>

I must say I don't quite understand the error, it seems to be unable to load an image which is odd considering the program works fine without any errors at all in Eclipse.

View Replies View Related

Slick2D Runnable Jar Not Running (Unsatisfied Link Error)

May 3, 2014

When I try to run my runnable jar file, it wont do anything. And when I try to run it from the console, it says

"java.lang.UnsatisfiedLinkError: no LWJGL in java.library.path..."

How do I fix this?

I've specified the path by properties > Libraries > lwjgl.jar > Native Library Location > .... And I chose the right paths. But I still get that java.lang.UnsatisfiedLinkError.

It says I'm getting an error on line 34 which is:

appgc = new AppGameContainer(new Game(gamename));

My whole main class is:

package net.battleboy;
import org.newdawn.slick.*;
import org.newdawn.slick.state.*;
 public class Game extends StateBasedGame {
 public static final String gamename = "Battle Boy 1.0 ALPHA";
public static final int menu = 0;
public static final int play = 1;
public static final int settings = 2;
 
[Code] .....

View Replies View Related

Embed HTML File Into Applet Java File

Jan 18, 2014

I want to know can we put the data of html file example

<html>
<body><applet code="classname" width="100" height="100">
</applet>
</body>
</html>

into my Applet's java file it can be done i have read it somewhere and have also implemented it ..... but now unable to memorize it

View Replies View Related

Ball Object Which Implements Runnable Interface And Traces Various Positions Of A Ball

Feb 11, 2014

a) I have a Ball Object which implements the Runnable interface and traces the various positions of a ball.

b) I then have a Ball_Bounce JPanel inside a JFrame which creates two instances of the Ball object and then paints them to the JPanel.

As per my understanding, when the main() program in Ball_Bounce.java is started, there a total of three threads running in this program, one for each ball and one for the main(). What I cannot understand is whenever the balls collide, I end up getting the "Collision" message twice even though the collision is checked only in the main() thread.

[#]public class Ball implements Runnable
{
private boolean xUp, yUp, xUp1, yUp1;
private int x, y, xDx, yDy;
private final int MAX_X = 500, MAX_Y = 500;
private boolean flag = true;
private static Thread ball;
 
[code]...

View Replies View Related

Calling Method Of Another Class Which Is Implemented By Runnable Class

Aug 11, 2014

i am having a problem while calling a method..i am having a class

Java Code:

public class MySer implements Runnable {
public void getMessage(String msg)
{
...,
}..,
} mh_sh_highlight_all('java');
i use the above class in another class

[code]....

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved