Hello again,
I've continued troubleshooting the problem I'm having and have used the
java -verbose option to find out what is going on in with the program.
It looks to me like the HSSFCell symbol is loaded but then the program
bails out. I was wondering if anyone could verify whether this is true.
I've attached the output of the java launching.
It looks like the only remedy to this problem is to update to JDK 1.6
because it looks like the javac executable is causing the problems. Any
opinions?
Here is the output of running the program at the command line with java
-verbose. If you do a search the symbols look like they're loaded:
HSSFCell, HSSFWorkbook etc. But, in the end it says they're not found
in STDERR. (Below are the STDERR output and the STDOUT output.)
STDERR:
Exception in thread "main" java.lang.Error: Unresolved compilation
problems:
The import org.apache cannot be resolved
The import org.apache cannot be resolved
The import org.apache cannot be resolved
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
HSSFCellStyle cannot be resolved to a type
The method getWorkbook() from the type ExcelConnection refers to
the missing type HSSFWorkbook
HSSFDataFormat cannot be resolved
HSSFCellStyle cannot be resolved to a type
The method getWorkbook() from the type ExcelConnection refers to
the missing type HSSFWorkbook
HSSFDataFormat cannot be resolved
HSSFCell cannot be resolved to a type
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
HSSFCell cannot be resolved to a type
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
The method getCell(int, short) from the type ExcelConnection
refers to the missing type HSSFCell
at org.snbw.util.sql.QueryExec.<init>(QueryExec.java:9)
at
org.snbw.util.sql.DirectoryQueryBatch.fillReport(DirectoryQueryBatch.
java:468)
at
org.snbw.util.sql.DirectoryQueryBatch.<init>(DirectoryQueryBatch.java
:143)
at
org.snbw.util.sql.DirectoryQueryBatch.main(DirectoryQueryBatch.java:7
68)
STDOUT:
C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\util\sql>set
classpath=C:\excel_poi\poi-2.5.1-final-20040804.jar;C:\APACHE-ANT-1.6.5\
LIB\ANT.JAR;C:\Program
Files\Corel\jPdox\webform\jars\PdxJdbc.jar;C:\Documents and
Settings\jbyrne\workspace\snbw.org\dest
C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\util\sql>echo here's the
classpath!
here's the classpath!
C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\util\sql>echo
C:\excel_poi\poi-2.5.1-final-20040804.jar;C:\APACHE-ANT-1.6.5\LIB\ANT.JA
R;C:\Program Files\Corel\jPdox\webform\jars\PdxJdbc.jar;C:\Documents and
Settings\jbyrne\workspace\snbw.org\dest
C:\excel_poi\poi-2.5.1-final-20040804.jar;C:\APACHE-ANT-1.6.5\LIB\ANT.JA
R;C:\Program Files\Corel\jPdox\webform\jars\PdxJdbc.jar;C:\Documents and
Settings\jbyrne\workspace\snbw.org\dest
C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\util\sql>java -verbose
org.snbw.util.sql.DirectoryQueryBatch C:\temp\LauraVerizon2009Q4_New
[Opened C:\Program Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Opened C:\Program Files\Java\jdk1.5.0_06\jre\lib\jsse.jar]
[Opened C:\Program Files\Java\jdk1.5.0_06\jre\lib\jce.jar]
[Opened C:\Program Files\Java\jdk1.5.0_06\jre\lib\charsets.jar]
[Loaded java.lang.Object from shared objects file]
[Loaded java.io.Serializable from shared objects file]
[Loaded java.lang.Comparable from shared objects file]
[Loaded java.lang.CharSequence from shared objects file]
[Loaded java.lang.String from shared objects file]
[Loaded java.lang.reflect.GenericDeclaration from shared objects file]
[Loaded java.lang.reflect.Type from shared objects file]
[Loaded java.lang.reflect.AnnotatedElement from shared objects file]
[Loaded java.lang.Class from shared objects file]
[Loaded java.lang.Cloneable from shared objects file]
[Loaded java.lang.ClassLoader from shared objects file]
[Loaded java.lang.System from shared objects file]
[Loaded java.lang.Throwable from shared objects file]
[Loaded java.lang.Error from shared objects file]
[Loaded java.lang.ThreadDeath from shared objects file]
[Loaded java.lang.Exception from shared objects file]
[Loaded java.lang.RuntimeException from shared objects file]
[Loaded java.security.ProtectionDomain from shared objects file]
[Loaded java.security.AccessControlContext from shared objects file]
[Loaded java.lang.ClassNotFoundException from shared objects file]
[Loaded java.lang.LinkageError from shared objects file]
[Loaded java.lang.NoClassDefFoundError from shared objects file]
[Loaded java.lang.ClassCastException from shared objects file]
[Loaded java.lang.ArrayStoreException from shared objects file]
[Loaded java.lang.VirtualMachineError from shared objects file]
[Loaded java.lang.OutOfMemoryError from shared objects file]
[Loaded java.lang.StackOverflowError from shared objects file]
[Loaded java.lang.ref.Reference from shared objects file]
[Loaded java.lang.ref.SoftReference from shared objects file]
[Loaded java.lang.ref.WeakReference from shared objects file]
[Loaded java.lang.ref.FinalReference from shared objects file]
[Loaded java.lang.ref.PhantomReference from shared objects file]
[Loaded java.lang.ref.Finalizer from shared objects file]
[Loaded java.lang.Runnable from shared objects file]
[Loaded java.lang.Thread from shared objects file]
[Loaded java.lang.Thread$UncaughtExceptionHandler from shared objects
file]
[Loaded java.lang.ThreadGroup from shared objects file]
[Loaded java.util.Dictionary from shared objects file]
[Loaded java.util.Map from shared objects file]
[Loaded java.util.Hashtable from shared objects file]
[Loaded java.util.Properties from shared objects file]
[Loaded java.lang.reflect.AccessibleObject from shared objects file]
[Loaded java.lang.reflect.Member from shared objects file]
[Loaded java.lang.reflect.Field from shared objects file]
[Loaded java.lang.reflect.Method from shared objects file]
[Loaded java.lang.reflect.Constructor from shared objects file]
[Loaded sun.reflect.MagicAccessorImpl from shared objects file]
[Loaded sun.reflect.MethodAccessor from shared objects file]
[Loaded sun.reflect.MethodAccessorImpl from shared objects file]
[Loaded sun.reflect.ConstructorAccessor from shared objects file]
[Loaded sun.reflect.ConstructorAccessorImpl from shared objects file]
[Loaded sun.reflect.DelegatingClassLoader from shared objects file]
[Loaded sun.reflect.ConstantPool from shared objects file]
[Loaded java.lang.Iterable from shared objects file]
[Loaded java.util.Collection from shared objects file]
[Loaded java.util.AbstractCollection from shared objects file]
[Loaded java.util.List from shared objects file]
[Loaded java.util.AbstractList from shared objects file]
[Loaded java.util.RandomAccess from shared objects file]
[Loaded java.util.Vector from shared objects file]
[Loaded java.lang.Appendable from shared objects file]
[Loaded java.lang.AbstractStringBuilder from shared objects file]
[Loaded java.lang.StringBuffer from shared objects file]
[Loaded java.lang.StackTraceElement from shared objects file]
[Loaded java.nio.Buffer from shared objects file]
[Loaded sun.misc.AtomicLong from shared objects file]
[Loaded sun.misc.AtomicLongCSImpl from shared objects file]
[Loaded java.lang.Boolean from shared objects file]
[Loaded java.lang.Character from shared objects file]
[Loaded java.lang.Number from shared objects file]
[Loaded java.lang.Float from shared objects file]
[Loaded java.lang.Double from shared objects file]
[Loaded java.lang.Byte from shared objects file]
[Loaded java.lang.Short from shared objects file]
[Loaded java.lang.Integer from shared objects file]
[Loaded java.lang.Long from shared objects file]
[Loaded java.lang.management.MemoryUsage from shared objects file]
[Loaded java.lang.StrictMath from shared objects file]
[Loaded java.io.ObjectStreamField from shared objects file]
[Loaded java.util.Comparator from shared objects file]
[Loaded java.lang.String$CaseInsensitiveComparator from shared objects
file]
[Loaded java.security.Guard from shared objects file]
[Loaded java.security.Permission from shared objects file]
[Loaded java.security.BasicPermission from shared objects file]
[Loaded java.lang.RuntimePermission from shared objects file]
[Loaded java.util.AbstractMap from shared objects file]
[Loaded sun.misc.SoftCache from shared objects file]
[Loaded java.lang.ref.ReferenceQueue from shared objects file]
[Loaded java.lang.ref.ReferenceQueue$Null from shared objects file]
[Loaded java.lang.ref.ReferenceQueue$Lock from shared objects file]
[Loaded java.util.HashMap from shared objects file]
[Loaded java.io.ObjectStreamClass from shared objects file]
[Loaded java.security.PrivilegedAction from shared objects file]
[Loaded sun.reflect.ReflectionFactory$GetReflectionFactoryAction from
shared objects file]
[Loaded java.security.AccessController from shared objects file]
[Loaded java.util.Stack from shared objects file]
[Loaded sun.reflect.ReflectionFactory from shared objects file]
[Loaded java.util.Map$Entry from shared objects file]
[Loaded java.util.HashMap$Entry from shared objects file]
[Loaded java.lang.IncompatibleClassChangeError from shared objects file]
[Loaded java.lang.NoSuchMethodError from shared objects file]
[Loaded java.lang.annotation.Annotation from shared objects file]
[Loaded java.lang.reflect.ReflectPermission from shared objects file]
[Loaded java.lang.ref.Reference$Lock from shared objects file]
[Loaded java.lang.ref.Reference$ReferenceHandler from shared objects
file]
[Loaded java.lang.ref.Finalizer$FinalizerThread from shared objects
file]
[Loaded java.util.Enumeration from shared objects file]
[Loaded java.util.Hashtable$EmptyEnumerator from shared objects file]
[Loaded java.util.Iterator from shared objects file]
[Loaded java.util.Hashtable$EmptyIterator from shared objects file]
[Loaded java.util.Hashtable$Entry from shared objects file]
[Loaded sun.misc.Version from shared objects file]
[Loaded java.io.Closeable from shared objects file]
[Loaded java.io.InputStream from shared objects file]
[Loaded java.io.FileInputStream from shared objects file]
[Loaded java.io.FileDescriptor from shared objects file]
[Loaded java.io.Flushable from shared objects file]
[Loaded java.io.OutputStream from shared objects file]
[Loaded java.io.FileOutputStream from shared objects file]
[Loaded java.io.FilterInputStream from shared objects file]
[Loaded java.io.BufferedInputStream from shared objects file]
[Loaded java.util.concurrent.atomic.AtomicReferenceFieldUpdater from
shared objects file]
[Loaded
java.util.concurrent.atomic.AtomicReferenceFieldUpdater$AtomicReferenceF
ieldUpdaterImpl from shared objects file]
[Loaded sun.misc.Unsafe from shared objects file]
[Loaded sun.reflect.Reflection from shared objects file]
[Loaded java.util.Collections from shared objects file]
[Loaded java.util.Random from shared objects file]
[Loaded java.util.concurrent.atomic.AtomicLong from shared objects file]
[Loaded java.lang.Class$3 from shared objects file]
[Loaded java.lang.reflect.Modifier from shared objects file]
[Loaded sun.reflect.LangReflectAccess from shared objects file]
[Loaded java.lang.reflect.ReflectAccess from shared objects file]
[Loaded java.util.Set from shared objects file]
[Loaded java.util.AbstractSet from shared objects file]
[Loaded java.util.Collections$EmptySet from shared objects file]
[Loaded java.util.Collections$EmptyList from shared objects file]
[Loaded java.util.Collections$EmptyMap from shared objects file]
[Loaded java.util.Collections$ReverseComparator from shared objects
file]
[Loaded java.util.Collections$SynchronizedMap from shared objects file]
[Loaded sun.reflect.misc.ReflectUtil from C:\Program
Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Loaded java.io.FilterOutputStream from shared objects file]
[Loaded java.io.PrintStream from shared objects file]
[Loaded java.io.BufferedOutputStream from shared objects file]
[Loaded java.io.Writer from shared objects file]
[Loaded java.io.OutputStreamWriter from shared objects file]
[Loaded sun.nio.cs.StreamEncoder from shared objects file]
[Loaded sun.io.Converters from shared objects file]
[Loaded sun.security.action.GetPropertyAction from shared objects file]
[Loaded java.nio.charset.Charset from shared objects file]
[Loaded java.nio.charset.spi.CharsetProvider from shared objects file]
[Loaded sun.nio.cs.FastCharsetProvider from shared objects file]
[Loaded sun.nio.cs.StandardCharsets from shared objects file]
[Loaded sun.util.PreHashedMap from shared objects file]
[Loaded sun.nio.cs.StandardCharsets$Aliases from shared objects file]
[Loaded sun.nio.cs.StandardCharsets$Classes from shared objects file]
[Loaded sun.nio.cs.StandardCharsets$Cache from shared objects file]
[Loaded java.lang.ThreadLocal from shared objects file]
[Loaded java.lang.StringBuilder from shared objects file]
[Loaded sun.nio.cs.HistoricallyNamedCharset from shared objects file]
[Loaded sun.nio.cs.MS1252 from shared objects file]
[Loaded java.lang.Class$1 from shared objects file]
[Loaded sun.reflect.ReflectionFactory$1 from shared objects file]
[Loaded sun.reflect.NativeConstructorAccessorImpl from shared objects
file]
[Loaded sun.reflect.DelegatingConstructorAccessorImpl from shared
objects file]
[Loaded sun.misc.VM from shared objects file]
[Loaded sun.nio.cs.StreamEncoder$CharsetSE from shared objects file]
[Loaded java.nio.charset.CharsetEncoder from shared objects file]
[Loaded sun.nio.cs.SingleByteEncoder from shared objects file]
[Loaded sun.nio.cs.MS1252$Encoder from shared objects file]
[Loaded java.nio.charset.CodingErrorAction from shared objects file]
[Loaded java.nio.charset.CharsetDecoder from shared objects file]
[Loaded sun.nio.cs.SingleByteDecoder from shared objects file]
[Loaded sun.nio.cs.MS1252$Decoder from shared objects file]
[Loaded java.nio.ByteBuffer from shared objects file]
[Loaded java.nio.HeapByteBuffer from shared objects file]
[Loaded java.nio.Bits from shared objects file]
[Loaded java.lang.Runtime from shared objects file]
[Loaded java.nio.ByteOrder from shared objects file]
[Loaded java.lang.Readable from shared objects file]
[Loaded java.nio.CharBuffer from shared objects file]
[Loaded java.nio.HeapCharBuffer from shared objects file]
[Loaded java.nio.charset.CoderResult from shared objects file]
[Loaded java.nio.charset.CoderResult$Cache from shared objects file]
[Loaded java.nio.charset.CoderResult$1 from shared objects file]
[Loaded java.nio.charset.CoderResult$2 from shared objects file]
[Loaded sun.nio.cs.Surrogate$Parser from shared objects file]
[Loaded sun.nio.cs.Surrogate from shared objects file]
[Loaded java.io.BufferedWriter from shared objects file]
[Loaded java.io.File from shared objects file]
[Loaded java.io.FileSystem from shared objects file]
[Loaded java.io.Win32FileSystem from shared objects file]
[Loaded java.io.WinNTFileSystem from shared objects file]
[Loaded java.io.ExpiringCache from shared objects file]
[Loaded java.util.LinkedHashMap from shared objects file]
[Loaded java.io.ExpiringCache$1 from shared objects file]
[Loaded java.util.LinkedHashMap$Entry from shared objects file]
[Loaded java.lang.ClassLoader$3 from shared objects file]
[Loaded java.io.ExpiringCache$Entry from shared objects file]
[Loaded java.lang.ClassLoader$NativeLibrary from shared objects file]
[Loaded java.lang.Terminator from shared objects file]
[Loaded sun.misc.SignalHandler from shared objects file]
[Loaded java.lang.Terminator$1 from shared objects file]
[Loaded sun.misc.Signal from shared objects file]
[Loaded sun.misc.NativeSignalHandler from shared objects file]
[Loaded sun.misc.JavaLangAccess from shared objects file]
[Loaded java.lang.System$2 from shared objects file]
[Loaded sun.misc.SharedSecrets from shared objects file]
[Loaded java.lang.NullPointerException from shared objects file]
[Loaded java.lang.ArithmeticException from shared objects file]
[Loaded java.lang.Compiler from shared objects file]
[Loaded java.lang.Compiler$1 from shared objects file]
[Loaded sun.misc.Launcher from shared objects file]
[Loaded java.net.URLStreamHandlerFactory from shared objects file]
[Loaded sun.misc.Launcher$Factory from shared objects file]
[Loaded java.security.SecureClassLoader from shared objects file]
[Loaded java.net.URLClassLoader from shared objects file]
[Loaded sun.misc.Launcher$ExtClassLoader from shared objects file]
[Loaded sun.security.util.Debug from shared objects file]
[Loaded java.util.StringTokenizer from shared objects file]
[Loaded java.security.PrivilegedExceptionAction from shared objects
file]
[Loaded sun.misc.Launcher$ExtClassLoader$1 from shared objects file]
[Loaded sun.net.www.ParseUtil from shared objects file]
[Loaded java.util.BitSet from shared objects file]
[Loaded java.net.URL from shared objects file]
[Loaded java.util.Locale from shared objects file]
[Loaded java.lang.CharacterDataLatin1 from shared objects file]
[Loaded java.net.Parts from shared objects file]
[Loaded java.net.URLStreamHandler from shared objects file]
[Loaded sun.net.www.protocol.file.Handler from shared objects file]
[Loaded java.util.HashSet from shared objects file]
[Loaded sun.misc.URLClassPath from shared objects file]
[Loaded java.util.ArrayList from shared objects file]
[Loaded sun.net.www.protocol.jar.Handler from shared objects file]
[Loaded sun.misc.Launcher$AppClassLoader from shared objects file]
[Loaded sun.misc.Launcher$AppClassLoader$1 from shared objects file]
[Loaded java.lang.SystemClassLoaderAction from shared objects file]
[Loaded java.lang.StringCoding from shared objects file]
[Loaded java.lang.ThreadLocal$ThreadLocalMap from shared objects file]
[Loaded java.lang.ThreadLocal$ThreadLocalMap$Entry from shared objects
file]
[Loaded java.lang.StringCoding$StringDecoder from shared objects file]
[Loaded java.lang.StringCoding$CharsetSD from shared objects file]
[Loaded java.net.URLClassLoader$1 from shared objects file]
[Loaded sun.misc.URLClassPath$3 from shared objects file]
[Loaded sun.misc.URLClassPath$Loader from shared objects file]
[Loaded sun.misc.URLClassPath$JarLoader from shared objects file]
[Loaded sun.misc.FileURLMapper from shared objects file]
[Loaded java.util.zip.ZipConstants from shared objects file]
[Loaded java.util.zip.ZipFile from shared objects file]
[Loaded java.util.jar.JarFile from shared objects file]
[Loaded sun.misc.JavaUtilJarAccess from shared objects file]
[Loaded java.util.jar.JavaUtilJarAccessImpl from shared objects file]
[Loaded sun.misc.JarIndex from shared objects file]
[Loaded sun.misc.ExtensionDependency from shared objects file]
[Loaded java.util.zip.ZipEntry from shared objects file]
[Loaded java.util.jar.JarEntry from shared objects file]
[Loaded java.util.jar.JarFile$JarFileEntry from shared objects file]
[Loaded java.io.DataInput from shared objects file]
[Loaded java.io.DataInputStream from shared objects file]
[Loaded java.util.zip.ZipFile$ZipFileInputStream from shared objects
file]
[Loaded java.util.zip.InflaterInputStream from shared objects file]
[Loaded java.util.zip.ZipFile$2 from shared objects file]
[Loaded java.util.zip.Inflater from shared objects file]
[Loaded java.lang.Math from shared objects file]
[Loaded java.security.PrivilegedActionException from shared objects
file]
[Loaded sun.misc.URLClassPath$FileLoader from shared objects file]
[Loaded sun.misc.Resource from shared objects file]
[Loaded sun.misc.URLClassPath$FileLoader$1 from shared objects file]
[Loaded java.lang.Package from shared objects file]
[Loaded sun.nio.ByteBuffered from shared objects file]
[Loaded java.security.CodeSource from shared objects file]
[Loaded java.security.PermissionCollection from shared objects file]
[Loaded java.security.Permissions from shared objects file]
[Loaded java.net.URLConnection from shared objects file]
[Loaded sun.net.www.URLConnection from shared objects file]
[Loaded sun.net.www.protocol.file.FileURLConnection from shared objects
file]
[Loaded java.net.ContentHandler from shared objects file]
[Loaded java.net.UnknownContentHandler from shared objects file]
[Loaded sun.net.www.MessageHeader from shared objects file]
[Loaded java.io.FilePermission from shared objects file]
[Loaded java.io.FilePermission$1 from shared objects file]
[Loaded java.io.FilePermissionCollection from shared objects file]
[Loaded java.security.AllPermission from shared objects file]
[Loaded java.security.UnresolvedPermission from shared objects file]
[Loaded java.security.BasicPermissionCollection from shared objects
file]
[Loaded java.security.Principal from shared objects file]
[Loaded java.security.cert.Certificate from shared objects file]
[Loaded org.snbw.util.sql.DirectoryQueryBatch from
file:/C:/Documents%20and%20Settings/jbyrne/workspace/snbw.org/dest/]
[Loaded java.io.IOException from shared objects file]
[Loaded java.io.FileNotFoundException from shared objects file]
[Loaded java.lang.IllegalAccessException from shared objects file]
[Loaded java.lang.InstantiationException from shared objects file]
[Loaded java.sql.SQLException from C:\Program
Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Loaded java.lang.IndexOutOfBoundsException from shared objects file]
[Loaded java.lang.StringIndexOutOfBoundsException from shared objects
file]
[Loaded java.io.FilenameFilter from shared objects file]
[Loaded java.util.regex.Pattern from shared objects file]
[Loaded java.util.regex.Pattern$Node from shared objects file]
[Loaded java.util.regex.Pattern$LastNode from shared objects file]
[Loaded java.util.regex.Pattern$GroupHead from shared objects file]
[Loaded java.util.regex.Pattern$Slice from shared objects file]
[Loaded java.util.regex.Pattern$Dot from C:\Program
Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Loaded java.util.regex.Pattern$Curly from shared objects file]
[Loaded java.util.regex.Pattern$Ctype from shared objects file]
[Loaded java.util.regex.Pattern$Single from shared objects file]
[Loaded java.util.regex.Pattern$BnM from C:\Program
Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Loaded java.util.regex.Pattern$SliceS from C:\Program
Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Loaded java.util.Properties$LineReader from shared objects file]
[Loaded org.snbw.util.logger.Logger from
file:/C:/Documents%20and%20Settings/jbyrne/workspace/snbw.org/dest/]
[Loaded java.io.FileWriter from shared objects file]
[Loaded java.io.PrintWriter from shared objects file]
[Loaded java.util.Hashtable$Enumerator from shared objects file]
[Loaded java.util.HashMap$KeySet from shared objects file]
[Loaded java.util.HashMap$HashIterator from shared objects file]
[Loaded java.util.HashMap$KeyIterator from shared objects file]
[Loaded org.snbw.util.sql.DirectoryQueryBatch$1 from
file:/C:/Documents%20and%20Settings/jbyrne/workspace/snbw.org/dest/]
[Loaded java.lang.reflect.Array from shared objects file]
ClientsServed.sql
ClientsWith15OrMoreServices.sql
ClientsWithRestrainingOrder.sql
ClientWithLegalServices.sql
ClientWithSafetyPlans.sql
[Loaded java.util.SortedMap from shared objects file]
[Loaded java.util.TreeMap from shared objects file]
[Loaded java.util.Hashtable$EntrySet from shared objects file]
[Loaded java.util.Collections$SynchronizedCollection from shared objects
file]
[Loaded java.util.Collections$SynchronizedSet from shared objects file]
[Loaded java.util.TreeMap$Entry from shared objects file]
[Loaded java.util.TreeMap$1 from shared objects file]
[Loaded java.util.TreeMap$PrivateEntryIterator from shared objects file]
[Loaded java.util.TreeMap$KeyIterator from shared objects file]
[Loaded org.snbw.util.excel.ExcelConnection from
file:/C:/Documents%20and%20Settings/jbyrne/workspace/snbw.org/dest/]
[Loaded sun.misc.URLClassPath$JarLoader$1 from shared objects file]
[Loaded java.util.jar.Manifest from shared objects file]
[Loaded java.io.ByteArrayInputStream from shared objects file]
[Loaded java.util.jar.Attributes from shared objects file]
[Loaded java.util.jar.Manifest$FastInputStream from shared objects file]
[Loaded sun.nio.cs.UTF_8 from shared objects file]
[Loaded sun.nio.cs.UTF_8$Decoder from shared objects file]
[Loaded sun.nio.cs.Surrogate$Generator from shared objects file]
[Loaded java.util.jar.Attributes$Name from shared objects file]
[Loaded sun.misc.ASCIICaseInsensitiveComparator from shared objects
file]
[Loaded java.util.jar.JarVerifier from shared objects file]
[Loaded java.io.ByteArrayOutputStream from shared objects file]
[Loaded sun.security.util.ManifestEntryVerifier from shared objects
file]
[Loaded java.security.Provider from shared objects file]
[Loaded sun.security.provider.Sun from shared objects file]
[Loaded java.security.Provider$ServiceKey from shared objects file]
[Loaded java.security.Provider$EngineDescription from C:\Program
Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Loaded sun.security.provider.Sun$1 from shared objects file]
[Loaded java.security.Security from shared objects file]
[Loaded java.security.Security$1 from shared objects file]
[Loaded java.util.concurrent.ConcurrentMap from shared objects file]
[Loaded java.util.concurrent.ConcurrentHashMap from shared objects file]
[Loaded java.util.concurrent.locks.Lock from shared objects file]
[Loaded java.util.concurrent.locks.ReentrantLock from shared objects
file]
[Loaded java.util.concurrent.ConcurrentHashMap$Segment from shared
objects file]
[Loaded java.util.concurrent.locks.AbstractQueuedSynchronizer from
shared objects file]
[Loaded java.util.concurrent.locks.ReentrantLock$Sync from shared
objects file]
[Loaded java.util.concurrent.locks.ReentrantLock$NonfairSync from shared
objects file]
[Loaded java.util.concurrent.locks.AbstractQueuedSynchronizer$Node from
shared objects file]
[Loaded java.util.concurrent.ConcurrentHashMap$HashEntry from shared
objects file]
[Loaded sun.misc.FloatingDecimal from shared objects file]
[Loaded sun.misc.FloatingDecimal$1 from shared objects file]
[Loaded java.util.regex.Pattern$GroupTail from shared objects file]
[Loaded java.util.regex.Pattern$BitClass from shared objects file]
[Loaded java.util.regex.Pattern$Ques from shared objects file]
[Loaded java.util.regex.Pattern$Dummy from shared objects file]
[Loaded java.util.regex.Pattern$Branch from shared objects file]
[Loaded java.util.regex.Pattern$categoryNames from shared objects file]
[Loaded java.util.regex.Pattern$Category from shared objects file]
[Loaded java.util.regex.Pattern$Range from shared objects file]
[Loaded java.util.regex.Pattern$All from shared objects file]
[Loaded java.util.regex.Pattern$JavaTypeClass from shared objects file]
[Loaded java.util.regex.Pattern$JavaLowerCase from shared objects file]
[Loaded java.util.regex.Pattern$JavaUpperCase from shared objects file]
[Loaded java.util.regex.Pattern$JavaTitleCase from shared objects file]
[Loaded java.util.regex.Pattern$JavaDigit from shared objects file]
[Loaded java.util.regex.Pattern$JavaDefined from shared objects file]
[Loaded java.util.regex.Pattern$JavaLetter from shared objects file]
[Loaded java.util.regex.Pattern$JavaLetterOrDigit from shared objects
file]
[Loaded java.util.regex.Pattern$JavaJavaIdentifierStart from shared
objects file]
[Loaded java.util.regex.Pattern$JavaJavaIdentifierPart from shared
objects file]
[Loaded java.util.regex.Pattern$JavaUnicodeIdentifierStart from shared
objects file]
[Loaded java.util.regex.Pattern$JavaUnicodeIdentifierPart from shared
objects file]
[Loaded java.util.regex.Pattern$JavaIdentifierIgnorable from shared
objects file]
[Loaded java.util.regex.Pattern$JavaSpaceChar from shared objects file]
[Loaded java.util.regex.Pattern$JavaWhitespace from shared objects file]
[Loaded java.util.regex.Pattern$JavaISOControl from shared objects file]
[Loaded java.util.regex.Pattern$JavaMirrored from shared objects file]
[Loaded java.util.regex.Pattern$Begin from shared objects file]
[Loaded java.util.regex.Pattern$First from shared objects file]
[Loaded java.util.regex.Pattern$Start from shared objects file]
[Loaded java.util.regex.Pattern$TreeInfo from shared objects file]
[Loaded sun.security.provider.NativePRNG from shared objects file]
[Loaded sun.misc.CharacterDecoder from shared objects file]
[Loaded sun.misc.BASE64Decoder from shared objects file]
[Loaded sun.security.util.SignatureFileVerifier from shared objects
file]
[Loaded org.apache.poi.poifs.dev.POIFSViewable from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.POIFSFileSystem from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
Working on workbook: Verizon.xls and worksheet: Sheet1
Will try to read the existing workbook
[Loaded org.apache.poi.poifs.property.Child from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.property.Parent from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.property.Property from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.property.DirectoryProperty from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.property.RootProperty from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.Entry from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.DirectoryEntry from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.BlockList from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.property.DocumentProperty from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded sun.misc.Cleaner from shared objects file]
[Loaded java.lang.Enum from shared objects file]
[Loaded org.apache.poi.poifs.filesystem.BATManaged from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.BlockWritable from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.property.PropertyTable from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.util.Arrays from shared objects file]
[Loaded org.apache.poi.util.FixedField from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.ShortField from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.lang.ArrayIndexOutOfBoundsException from shared objects
file]
[Loaded org.apache.poi.util.ByteField from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.IntegerField from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.LittleEndianConsts from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.LittleEndian from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.LittleEndian$BufferUnderrunException from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hpsf.ClassID from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.ListManagedBlock from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.SmallDocumentBlock from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.HeaderBlockConstants from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.HeaderBlockReader from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.IOUtils from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.LongField from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.BlockListImpl from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.RawDataBlockList from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.RawDataBlock from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.BlockAllocationTableReader from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.IntList from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.BigBlock from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.BATBlock from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.property.PropertyFactory from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.SmallBlockTableReader from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.SmallDocumentBlockList from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.util.AbstractList$Itr from shared objects file]
[Loaded org.apache.poi.poifs.filesystem.EntryNode from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.DirectoryNode from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.DocumentEntry from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.DocumentNode from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.POIFSDocumentPath from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.lang.IllegalArgumentException from shared objects file]
[Loaded org.apache.poi.poifs.filesystem.POIFSDocument from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.storage.DocumentBlock from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.POIFSDocument$SmallBlockStore
from file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.usermodel.HSSFWorkbook from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.poifs.filesystem.DocumentInputStream from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.POILogFactory from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.POILogger from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.NullLogger from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.eventmodel.EventRecordFactory from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.RecordFormatException from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.Record from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.UnknownRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.CellValueRecordInterface from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.RKRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.NumberRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.BOFRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.InterfaceHdrRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.MMSRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.InterfaceEndRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.WriteAccessRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.CodepageRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DSFRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.TabIdRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.FnGroupCountRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.WindowProtectRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.ProtectRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PasswordRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.ProtectionRev4Record from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PasswordRev4Record from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.WindowOneRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.BitField from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.BackupRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.HideObjRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DateWindow1904Record from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PrecisionRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.RefreshAllRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.BookBoolRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.FontRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.FormatRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.ExtendedFormatRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.StyleRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.UseSelFSRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.BoundSheetRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.CountryRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.SSTRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.lang.IllegalStateException from shared objects file]
[Loaded org.apache.poi.hssf.record.ExtSSTRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.EOFRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.IndexRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.CalcModeRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.CalcCountRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.RefModeRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.IterationRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DeltaRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.SaveRecalcRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PrintHeadersRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PrintGridlinesRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.GridsetRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.GutsRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DefaultRowHeightRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.WSBoolRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.HeaderRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.FooterRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.HCenterRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.VCenterRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PrintSetupRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DefaultColWidthRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DimensionsRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.RowRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.LabelSSTRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DBCellRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.WindowTwoRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.SelectionRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.ContinueRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.LabelRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.BlankRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.ColumnInfoRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.MulRKRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.MulBlankRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.MergeCellsRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.BoolErrRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.ExternSheetRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.NameRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.lang.UnsupportedOperationException from shared objects
file]
[Loaded org.apache.poi.hssf.record.formula.Ptg from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.formula.Area3DPtg from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.formula.Ref3DPtg from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.Margin from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.LeftMarginRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.RightMarginRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.TopMarginRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.BottomMarginRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PaletteRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.StringRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.SharedFormulaRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded sun.reflect.UnsafeFieldAccessorFactory from shared objects file]
[Loaded sun.reflect.FieldAccessor from shared objects file]
[Loaded sun.reflect.FieldAccessorImpl from shared objects file]
[Loaded sun.reflect.UnsafeFieldAccessorImpl from shared objects file]
[Loaded sun.reflect.UnsafeStaticFieldAccessorImpl from shared objects
file]
[Loaded sun.reflect.UnsafeQualifiedStaticFieldAccessorImpl from shared
objects file]
[Loaded sun.reflect.UnsafeQualifiedStaticShortFieldAccessorImpl from
C:\Program Files\Java\jdk1.5.0_06\jre\lib\rt.jar]
[Loaded org.apache.poi.hssf.record.RecordFactory from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.FormulaRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DrawingRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.AbstractEscherHolderRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DrawingGroupRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherSerializationListener from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherRecordFactory from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.DrawingSelectionRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.ObjRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.TextObjectBaseRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.TextObjectRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.io.UnsupportedEncodingException from shared objects file]
[Loaded org.apache.poi.hssf.record.RecalcIdRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.PageBreakRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.HorizontalPageBreakRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.VerticalPageBreakRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.StringUtil from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.lang.InternalError from shared objects file]
[Loaded sun.nio.cs.ISO_8859_1 from shared objects file]
[Loaded sun.nio.cs.ISO_8859_1$Decoder from shared objects file]
[Loaded sun.reflect.ClassFileConstants from shared objects file]
[Loaded sun.reflect.AccessorGenerator from shared objects file]
[Loaded sun.reflect.MethodAccessorGenerator from shared objects file]
[Loaded java.lang.Void from shared objects file]
[Loaded sun.reflect.ByteVectorFactory from shared objects file]
[Loaded sun.reflect.ByteVector from shared objects file]
[Loaded sun.reflect.ByteVectorImpl from shared objects file]
[Loaded sun.reflect.ClassFileAssembler from shared objects file]
[Loaded sun.reflect.UTF8 from shared objects file]
[Loaded sun.reflect.Label from shared objects file]
[Loaded sun.reflect.Label$PatchInfo from shared objects file]
[Loaded sun.reflect.MethodAccessorGenerator$1 from shared objects file]
[Loaded sun.reflect.ClassDefiner from shared objects file]
[Loaded sun.reflect.ClassDefiner$1 from shared objects file]
[Loaded sun.reflect.GeneratedConstructorAccessor1 from
__JVM_DefineClass__]
[Loaded sun.reflect.BootstrapConstructorAccessorImpl from shared objects
file]
[Loaded org.apache.poi.hssf.record.ExternSheetSubRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.BinaryTree from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.util.BinaryTree$Node from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.SSTDeserializer from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.model.Model from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.model.Workbook from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherProperty from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherSimpleProperty from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherBoolProperty from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherRGBProperty from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherDggRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherOptRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherSplitMenuColorsRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.ddf.EscherContainerRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.SupBookRecord from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.model.WorkbookRecordList from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.model.Sheet from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.aggregates.RowRecordsAggregate from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
from file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.record.aggregates.ColumnInfoRecordsAggregate
from file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.usermodel.HSSFSheet from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.util.TreeMap$2 from shared objects file]
[Loaded java.util.TreeMap$ValueIterator from shared objects file]
[Loaded org.apache.poi.hssf.usermodel.HSSFRow from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.apache.poi.hssf.usermodel.HSSFCell from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded java.lang.NumberFormatException from shared objects file]
[Loaded org.apache.poi.hssf.usermodel.HSSFCellStyle from
file:/C:/excel_poi/poi-2.5.1-final-20040804.jar]
[Loaded org.snbw.util.sql.SQL_Constants from
file:/C:/Documents%20and%20Settings/jbyrne/workspace/snbw.org/dest/]
[Loaded org.snbw.util.sql.QueryReader from
file:/C:/Documents%20and%20Settings/jbyrne/workspace/snbw.org/dest/]
[Loaded java.io.Reader from shared objects file]
[Loaded java.io.InputStreamReader from shared objects file]
[Loaded java.io.FileReader from shared objects file]
[Loaded java.io.BufferedReader from shared objects file]
[Loaded sun.nio.cs.StreamDecoder from shared objects file]
[Loaded sun.nio.cs.StreamDecoder$CharsetSD from shared objects file]
[Loaded java.io.StreamTokenizer from shared objects file]
[Loaded java.util.regex.MatchResult from shared objects file]
[Loaded java.util.regex.Matcher from shared objects file]
[Loaded java.util.Hashtable$KeySet from shared objects file]
current file: C:\temp\LauraVerizon2009Q4_New\ClientsServed.sql
running query: select distinct C.udfilenumber, C.lastname, C.firstname
from D$_Clients C join D$_Services S on C.clientnumber = S.clientnumber
where S.servicedate >= '10/1/09' and S.servicedate < '11/15/09' and
C.clientnumber not in ( select C.clientnumber from D$_Clients C join
D$_Services S on C.clientnumber = S.clientnumber where S.servicedate >
'12/1/08' and S.servicedate < '10/1/09' )
[Loaded org.snbw.util.sql.QueryExec from
file:/C:/Documents%20and%20Settings/jbyrne/workspace/snbw.org/dest/]
[Loaded java.lang.Shutdown from shared objects file]
[Loaded java.lang.Shutdown$Lock from shared objects file]
-----Original Message-----
From: John Byrne [mailto:[email protected]]
Sent: Monday, November 16, 2009 2:07 PM
To: POI Users List
Subject: HSSFCell and HSSFWorkbook symbols not found
Hello all,
This seems like it's an easy problem but I don't think it is. I'm
getting an error in both eclipse and when I compile using Ant.
I've added the poi 2.5.1 library in the classpath. It looks like it is
imported properly. What am I doing wrong? Anyone?
The error messages are:
compile:
[depend] Deleted 1 out of date files in 1 seconds
[javac] Compiling 1 source file to C:\Documents and
Settings\jbyrne\workspac
e\snbw.org\dest
[javac] C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\uti
l\excel\ExcelConnection.java:483: cannot access HSSFWorkbook
[javac] file HSSFWorkbook.class not found
[javac] return new HSSFRegion(cell_start, cell_end,
getWorkbook(
), getWorkSheet());
[javac] ^
[javac] C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\uti
l\excel\ExcelConnection.java:556: cannot access Region
[javac] file Region.class not found
[javac] getWorkbook().setRepeatingRowsAndColumns(0,
(int) hssf_r
egion.getColumnFrom(), (int) hssf_region.getColumnTo(),
hssf_region.getRowFrom()
, hssf_region.getRowTo());
[javac]
^
[javac] C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\uti
l\excel\ExcelConnection.java:556: cannot find symbol
[javac] symbol : method getColumnTo()
[javac] location: class org.snbw.util.excel.HSSFRegion
[javac] getWorkbook().setRepeatingRowsAndColumns(0,
(int) hssf_r
egion.getColumnFrom(), (int) hssf_region.getColumnTo(),
hssf_region.getRowFrom()
, hssf_region.getRowTo());
[javac]
^
[javac] C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\uti
l\excel\ExcelConnection.java:556: cannot find symbol
[javac] symbol : method getRowFrom()
[javac] location: class org.snbw.util.excel.HSSFRegion
[javac] getWorkbook().setRepeatingRowsAndColumns(0,
(int) hssf_r
egion.getColumnFrom(), (int) hssf_region.getColumnTo(),
hssf_region.getRowFrom()
, hssf_region.getRowTo());
[javac]
^
[javac] C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\snbw\uti
l\excel\ExcelConnection.java:556: cannot find symbol
[javac] symbol : method getRowTo()
[javac] location: class org.snbw.util.excel.HSSFRegion
[javac] getWorkbook().setRepeatingRowsAndColumns(0,
(int) hssf_r
egion.getColumnFrom(), (int) hssf_region.getColumnTo(),
hssf_region.getRowFrom()
, hssf_region.getRowTo());
[javac]
^
[javac] Note: C:\Documents and
Settings\jbyrne\workspace\snbw.org\src\org\sn
bw\util\sql\DirectoryQueryBatch.java uses unchecked or unsafe
operations.
[javac] Note: Recompile with -Xlint:unchecked for details.
[javac] 5 errors
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
