I'm having some real trouble with a NoClassDefFoundError, and I'm struggling to understand the cause so I can fix it. I think I've set up my class paths correctly, but maybe I'm missing something.
Here is my error:
Here is my code (I've replaced all direct references to my user profile with [USER]):
Also, this is usually called from a UI I created and not command path, but since wasn't getting errors I modified it to run from a command window for testing... since I couldn't quite figure out log4j yet.
import java.io.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.*;
import java.sql.SQLException;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.log4j.Logger;
public class FilePrepMainStart {
//declare variables on the class level
static String fullinpath, fulloutpath, inpath, outpath, infilename, outfilename, outorigfn, delimiter, logfn;
static boolean istextfile, isexcelfile, addrecid;
//static Logger log;
//Create contructor with arguments
public void FilePrepMainStart(String in, String out, boolean txt, boolean exl, boolean rec, String delim) {
this.fullinpath = in;
this.fulloutpath = out;
this.istextfile = txt;
this.isexcelfile = exl;
this.addrecid = rec;
this.delimiter = delim;
}
private static String getPath(String in) {
//Attempts to extract the directory path from the full file path
Pattern pathPattern = createPattern("^([a-z]\\:.*\\\\)([a-zA-Z0-9 \\_\\$\\!\\?\\+\\%\\#\\@\\)\\(\\-\\.]+\\.[a-zA-Z0-9]{3,4})$");
Matcher filePath = pathPattern.matcher(in);
if (filePath.find()){
return filePath.group(1);
}
else {
return null;
}
}
private static String getFileName(String in) {
//Attempts to extract the sile name from the full file path
Pattern namePattern = createPattern("^([a-z]\\:.*\\\\)([a-zA-Z0-9 \\_\\$\\!\\?\\+\\%\\#\\@\\)\\(\\-\\.]+\\.[a-zA-Z0-9]{3,4})$");
Matcher filename = namePattern.matcher(in);
if (filename.find()){
return filename.group(2);
}
else {
return null;
}
}
private static Pattern createPattern(String pattern){
//Creates a compiled Pattern object from a String pattern
//args- pattern: String containing regex pattern to be compiled
Pattern p = Pattern.compile(pattern, Pattern.CASE_INSENSITIVE);
return p;
}
public static String appendOut(String name, String append) {
//Adds the string "append" to the file name on output.
//First checks for a file extension
//Used to create a "_Clean" and "_Original" file
Pattern filePattern = createPattern("(.*)(\\.[a-z0-9]{3,4})$");
Matcher fileMatcher = filePattern.matcher(name);
String outfilename = name;
if (fileMatcher.find()) {
outfilename = fileMatcher.group(1) + append + fileMatcher.group(2);
}
else {
outfilename = outfilename + append;
}
return outfilename;
}
public static String appendOut(String name, String append, boolean excludeext) {
//Overloaded appendOut to allow prevention of adding extension back into the fn
//Adds the string "append" to the file name on output.
//First checks for a file extension
//Used to create a "_Clean" and "_Original" file
//boolean excludeext: True to exclude adding the file extension back into the file name
//False for default (non-overloaded) functionality
Pattern filePattern = createPattern("(.*)(\\.[a-z0-9]{3,4})$");
Matcher fileMatcher = filePattern.matcher(name);
String outfilename = name;
if (fileMatcher.find() && excludeext) {
outfilename = fileMatcher.group(1) + append;
}
else if (fileMatcher.find()) {
outfilename = fileMatcher.group(1) + append + fileMatcher.group(2);
}
else {
outfilename = outfilename + append;
}
return outfilename;
}
private static int chkEXLFile(String name) {
//Checks Excel file type
String pattern = "(.*)\\.([a-z0-9]{3,4})$";
String filename = name;
Pattern p = createPattern(pattern);
Matcher chkFile = p.matcher(filename);
if (chkFile.find()){
String file_ext = chkFile.group(2).toLowerCase();
if (file_ext.equals("xls")) {
//XLS file
return 0;
}
else if (file_ext.equals("xlsx")) {
//XLSX File
return 1;
}
else {
//Unrecognized - Not XLS or XLSX file
return -1;
}
}
else {
//Unrecognized - Not XLS or XLSX file
return -1;
}
}
public static void openXLSFileStream(String input, String output, boolean rec, String worksheet) throws FileNotFoundException, IOException {
//Opens input and output streams and kicks off processing
FileInputStream in = new FileInputStream(input);
HSSFWorkbook inbk = new HSSFWorkbook(in);
FileOutputStream out = new FileOutputStream(output);
HSSFWorkbook outbk = new HSSFWorkbook();
if (rec) {
processXLSFileWithRecID(in, inbk, out, outbk, worksheet);
}
else {
}
}
private static void processXLSFileWithRecID(FileInputStream in, HSSFWorkbook inbk, FileOutputStream out, HSSFWorkbook outbk, String worksheet) throws FileNotFoundException, IOException {
/* Reads in and loops through each excel cell to clean it
* Need to add functionality to create a new workook, could be added for each part of the loop
*/
Pattern pattern = createPattern("[^-a-z_0-9\"/\\t\\.#@\\|, ]");
int sheetnum = -1;
int sheets = inbk.getNumberOfSheets();
//Get the worksheet number for the worksheet requested
for (int i = 0; i < sheets; i++) {
if (worksheet.equals(inbk.getSheetName(i))) {
sheetnum = i;
break;
}
}
//To Do: If no worksheet is present, sheetnum will be -1, and an error should be raised
if (sheetnum == -1) {}
HSSFSheet sheet = inbk.getSheetAt(sheetnum);
int rows = sheet.getPhysicalNumberOfRows();
HSSFSheet outsheet = outbk.createSheet();
//Loop through each row of the sheet
for (int r = 0; r < rows; r++) {
HSSFRow row = sheet.getRow(r);
if (row == null) {
continue;
}
HSSFRow outrow = outsheet.createRow(r);
int cells = row.getPhysicalNumberOfCells();
//Loop through each cell of the sheet
for (int c = 0; c < cells; c++) {
HSSFCell cell = row.getCell(c);
String s = null;
HSSFCell outcell = outrow.createCell(c);
//Grab the cell value and assign it to variable s, based on the cell type
switch(cell.getCellType()) {
case HSSFCell.CELL_TYPE_FORMULA:
s = cell.getCellFormula();
break;
case HSSFCell.CELL_TYPE_NUMERIC:
s = Double.toString(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_STRING:
s = cell.getStringCellValue();
break;
default:
}
Matcher matcher = pattern.matcher(s);
//If a match is found in the string:
if (matcher.find()) {
//Replace all matches
String repl = matcher.replaceAll(" ");
outcell.setCellValue(repl);
}
else {
outcell.setCellValue(s);
}
}
}
outbk.write(out);
out.close();
}
public static void run(String in, String out, boolean txt, boolean exl, boolean rec, String delim, String worksheet) {
//Primary run process
//Takes String args in, out, delim, and worksheet
//in, out are file names for input and output files; delim is delimiter for adding recid on txt files
//worksheet is the name of the worksheet that needs to be processed on Excel type files
//Takes boolean args txt, exl, and rec
//txt and exl indicate file type, diff file types have diff processing
//rec indicates is a record id is requested to be added to the file
try {
delimiter = delim;
outfilename = appendOut(out, "_Clean");
outorigfn = appendOut(out, "_Original");
//For when I add in logging
logfn = appendOut(in, "_LogFile.txt", true);
if (txt) {
openTXTStreams(in, outfilename, outorigfn, delimiter, rec);
}
else if (exl) {
int inflg = chkEXLFile(in);
int outflg = chkEXLFile(out);
if (inflg == 0) {
//throw new Exception("test");
openXLSFileStream(in, out, rec, worksheet);
}
else if (inflg == 1) {
}
else {
}
}
else {
}
}
catch(Exception ex){
ex.printStackTrace();
}
}
public static void main(String[] args) {
String in = "D:\\Users\\[USER]\\Documents\\Java\\FilePrep\\TestFiles\\Name Address Phone.xls";
String out = "D:\\Users\\[USER]\\Documents\\Java\\FilePrep\\TestFiles\\Name Address Phone_Out.xls";
boolean txt = false;
boolean exl = true;
boolean rec = false;
String delim = ",";
String worksheet = "Sheet1";
run(in, out, txt, exl, rec, delim, worksheet);
}
}
Here is the command I use to compile:
"C:\Program Files\Java\jdk1.7.0\bin\javac.exe" -d D:\Users\[USER]\Documents\Java\FilePrep\fileprep -classpath D:\Users\[USER]\Documents\Java\FilePrep\fileprep;D:\Users\[USER]\Documents\Java\FilePrep\fileprep\lib\log4j-1.2.13.jar;D:\Users\[USER]\Documents\Java\Libraries\Apache\poi-3.9\poi-ooxml-3.9-20121203.jar;D:\Users\[USER]\Documents\Java\Libraries\Apache\poi-3.9\poi-3.9-20121203.jar D:\Users\[USER]\Documents\Java\fileprep\sources\fileprep\FilePrepMainStart.java
And lastly, here is the command I am currently using to test run from the app directory:
java FilePrepMainStart -classpath D:\Users\[USER]\Documents\Java\FilePrep\fileprep;lib\log4j-1.2.13.jar;lib\poi-ooxml-3.9-20121203.jar;lib\poi-3.9-20121203.jar;lib\commons-codec-1.5.jar;lib\stax-api-1.0.1.jar;lib\commons-logging-1.1.jar;lib\xmlbeans-2.3.0.jar;lib\dom4j-1.6.1.jar
This is the first real Java program I've attempted to make. The purpose is a simple app to clean special characters from a data file. I've been able to set up the simple text file cleaning correctly, however, I cannot get the program to work with Apache POI for Excel files.
I am working through UltraEdit, as I don't have install permissions to use an IDE like Eclipse or NetBeans while at work. An IDE might really help, though, since I am so new to this. I've struggled with this for a while now and it's a road block that's stopping me from progressing in Java entirely. I've researched the error and tried changing my class paths around. I don't have permissions to change my PATH environment variable, but I don't know if that would cause this or not. I've also tried moving my JAR files to a different location.
Can anyone help me identify what I'm missing or point me in the right direction? I'm losing my mind on this one. I feel like I should be able to figure this out if I were a programmer worth his weight in salt- but clearly I'm not there yet. I appreciate any suggestions.
Thanks!
