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
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
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
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
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
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
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
Jan 5, 2015
How to embed jsp into html page?
View Replies
View Related
May 8, 2013
When I embed java applet in html the "ClassNotFoundException" message appear to me, how to overcome this ....
View Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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