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.
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.
I'm trying to display the data from database in a jtable by following the jtable demo example in Java Tutorials Sample Code; but, I couldn't output the data to the jtable. The following code is what I've done so far.
When i click on 'Add Invoice' button open a dialog box. input data in dialog box. After click on 'Save Invoice' all the data of dialog box is render in primfaces datatable. After that click on 'Save Invoices' all data of primefaces datatable and HTML table data are store in ipsDetail and Invoice object of Managed Bean class.
Here, Problem is ipsDetail elements NULL when click on 'Save Invoice' button in addRow() so that primefaces datatable not updated. So that i can not insert new invoice data in database table.
I can insert data to table by using JSP Scriptlet easily but I have a hard time with servlet.
public class UsertToDatabase() { public boolean inserUser(String name, String email, String pwd) throws SQLException { PreparedStatement pstmt = null; boolean flag = false; System.out.println("start"); openConn(); System.out.println("start_1"); if(conn == null) {
[code]....
I am positive that the above code function fine. The problem is whenever I call UserToDB() class inside the servlet, and I got this error: java.lang.ClassNotFoundException: org.postgresql.
Driver which mean that my conn (connection) is not connected to the database but I have ensure to do so by calling openConn() before start the transaction.
try { is = new FileInputStream(file); data = new byte[(int) file.length()]; is.read(data); String extension = ""; int i = file.getName().lastIndexOf('.'); if(i>0)
[Code] ....
Everything works except transferring the image file.
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;
I have tried this code to insert into datbase if not exists but i get an Exception in thread "main" com.mysql.jdbc. exceptions.jdbc4. MySQL SyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE NOT EXISTS (SELECT teamName FROM Teams WHERE teamName = teamName) LIMIT 1' at line 1
stmt.executeUpdate("INSERT INTO Teams(teamId,teamName,league) VALUES ("+i+",'"+loser+"','"+league2+"')WHERE NOT EXISTS (SELECT teamId,teamName,league FROM Teams WHERE teamName = teamName) LIMIT 1;");
I need getting detailed examples about how I can read/insert into database using JSF code for its different components. I am a beginner in JSF and I have the basics, however, I need the best source which it has useful, easy and detailed steps to understand the techniques for connecting to the DB and how to insert or read data from the database.
I tried to search, but I found the lessons are not useful or not described in details.
I have a simple project to save data to the database. I have successfully mapped the java class with the database table. The code displays no error, it runs very well but it does not save to database, instead it catches an exception and prints out "saving failed". The database is a mysql database.
This is the managed bean code. Save.java(name=bean)
//imports
@ManagedBean(name="bean") @RequestScoped public class Save { private String username,password,msg; Session session = null; Transaction transaction = null; //GETTERS AND SETTERS public Save() {
[Code] ....
This is a screenshot of my Hibernate configuration file : hb.jpg
I am looking to reconcile data between SQL server and Oracle DB post the migration, I need to verify the data (rows/columns) for last 10 years, Before i start writing a Java Utility to accomplish this, My question is are there any existing libraries or API which can accomplish the same ....
I've tried everything but in vain..I want to save the data from the table into the database, I can easily connect to the database. All I want is how to get the values from the table. I've tried this method to get the values but its not working because of the contructor error in the BgTableModel class.
Tried Method public void writeBgEdu() { int last=gtm.getRowCount(); System.out.println(last); for( int i=0;i<last;i++) { if(((String) gtm.getValueAt(i,0))!=null)
I am trying to retrieve data from my database by joining my tables. So far i have managed to join my four tables in my database and retrieve all the information in that table. Now what i want to do is create a prepared statement in java that allows me to retreive certain data. Here is my joining query.
SELECT student.idNumber,student.names, student.surname, course.description, coursemarks.mark, class.form,class.id FROM `student` LEFT JOIN `coursemarks` on student.idNumber = coursemarks.studentid LEFT JOIN `course` on course.courseid = coursemarks.courseid LEFT JOIN `class`on student.idNumber = class.studentID;
What I want is to select all the data depending on the class passed and the form passed, e.g a person might decide to select a certain form only or a certain form and class
