Steps for Configuring the HSQLDB in Eclipse using Jar

Step 1:Open Eclipse and add following JARS:

Step 2:Go to lib\hsqldb.jar in eclipse -> expand org.hsqldb -> Right click on Server.class->Run AsJava Application.

Step 3:For Standalone Application :Go to lib\hsqldb.jar in eclipse -> expand org.hsqldb.util->Right click on DatabaseManager.class -> Run As Java Application. For Web Application:Add hsqldb.jar file at WebContent/WEB-INF/lib and libraries. Go to libraries\hsqldb.jar in eclipse -> expand org.hsqldb.util-> Right click on DatabaseManager.class -> Run As Java Application. Then you will get following screen:



Step 4: Select connection Type, Driver , URL , User and Password and then click on Ok button: • For Standalone application select “HSQL Database Engine Standalone”. • For Web application select “HSQL Database Engine Server”.



You will get following screen:


Step 5: Go to “Command“ to Create, Select , Insert ,Update , Delete ,Drop tables.



Links to Download Jar Files:
http://www.findjar.com/index.x
http://www.jarfinder.com/
http://axis.apache.org/axis2/java/core/download.cgi

Comments

Post a Comment

Popular posts from this blog

Edit/Modify existing PDF using Java(iText)

import java.io.FileOutputStream; import java.io.IOException; import com.itextpdf.text.DocumentException; import com.itextpdf.text.pdf.BaseFont; import com.itextpdf.text.pdf.PdfContentByte; import com.itextpdf.text.pdf.PdfReader; import com.itextpdf.text.pdf.PdfStamper; public class EditExistingPDF { public static void main(String[] args) throws IOException, DocumentException { PdfReader reader = new PdfReader("C:\\signed.pdf"); // input PDF PdfStamper stamper = new PdfStamper(reader,new FileOutputStream( "C:\\test.pdf")); // output PDF BaseFont bf = BaseFont.createFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); // set font // loop on pages (1-based) for (int i = 1; i // get object for writing over the existing content; // you can also use getUnderContent for writing in the bottom // layer PdfContentByte over = stamper.getOverContent(i); // write text over.beginText(); over.setFontAndSize(bf, 10); // set font and size over....
Read more

Verify Digital Signature in PDF using Java(iText) and cacerts

Jars Files: itext-2.1.7.jar itextpdf-5.4.2.jar bcprov-ext-jdk14-1.47.jar bcprov-1.39.jar ---------------------------------------------------------------- import java.io.FileNotFoundException; import java.io.IOException; import java.security.KeyStore; import java.security.KeyStoreException; import java.security.NoSuchAlgorithmException; import java.security.SignatureException; import java.security.cert.CertificateException; import java.util.ArrayList; import java.util.Calendar; import java.util.Enumeration; import com.lowagie.text.pdf.AcroFields; import com.lowagie.text.pdf.PdfPKCS7; import com.lowagie.text.pdf.PdfReader; public class VerifySignature { public static void main(String[] args) throws KeyStoreException, NoSuchAlgorithmException, CertificateException, FileNotFoundException, IOException, SignatureException { //loads all the keystore imported in cacerts. To load your certificate from cacerts, first it needs to be imported using k...
Read more

Steps to create SOAP Web service using Eclipse

Image
Step 1 : Go to File -> New -> Dynamic Web Project Step 2 : Enter Project name as “SOAPWebSErvice” as created in below screenshot. Step 3 : Create below packages under src folder: a. com.test.controller b. com.test.model Step 4 : Add Employee.java under package - com.test.model Add EmployeeController.java under package - com.test.controller. Employee.java package com.test.model; public class Employee { private String id; private String name; public String getId() { return id; } public String getName() { return name; } public void setId(String id) { this.id = id; } public void setName(String name) { this.name = name; } } ------------------------------------------------------------------------------------------------------------------ EmployeeController.java package com.test.controller; import com.test.model.Employee; public class EmployeeController { public Employee employee; public Employee setEmployee(...
Read more