Tried your Example1.
Compiles but does not run.
C:\Users\raymo\Desktop\Java\hxtt\demo\src>java Example1
com.hxtt.sql.excel.ExcelDriver
java.lang.ClassNotFoundException: com.hxtt.sql.excel.ExcelDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at Example1.main(Example1.java:7)
C:\Users\raymo\Desktop\Java\hxtt\demo\src>javac -cp "C:\Users\raymo\Desktop\Java\hxtt\lib\Excel_JDBC30.jar" Example1.java
C:\Users\raymo\Desktop\Java\hxtt\demo\src>java -cp "C:\Users\raymo\Desktop\Java\hxtt\lib\Excel_JDBC30.jar" Example1
Error: Could not find or load main class Example1
|
Maybe you should use
java -cp C:\Users\raymo\Desktop\Java\hxtt\lib\Excel_JDBC30.jar;. Example1
if your Example1.class is at C:\Users\raymo\Desktop\Java\hxtt\demo\src.
Maybe
java -cp C:\Users\raymo\Desktop\Java\hxtt\lib\Excel_JDBC30.jar;..\classes Example1
if it's at C:\Users\raymo\Desktop\Java\hxtt\demo\classes.
|
Thank you for your immediate reply.
I put the Excel file, Book1.xls, at same directory as Example1.class, but
this is now the error I'm getting.
C:\Users\raymo\Desktop\Java\hxtt\demo\src>javac -cp C:\Users\raymo\Desktop\Java\hxtt\lib\Excel_JDBC30.jar;. Example1.java
C:\Users\raymo\Desktop\Java\hxtt\demo\src>java -cp C:\Users\raymo\Desktop\Java\hxtt\lib\Excel_JDBC30.jar;. Example1
Invalid Database URL: jdbc:Excel:C:/Users/raymo/Desktop/Java/hxtt/demo/src/Book1.xls
java.sql.SQLException: Invalid Database URL: jdbc:Excel:C:/Users/raymo/Desktop/Java/hxtt/demo/src/Book1.xls
at com.hxtt.global.ar.a(Unknown Source)
at com.hxtt.global.ar.a(Unknown Source)
at com.hxtt.global.ar.if(Unknown Source)
at com.hxtt.sql.HxttDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at Example1.main(Example1.java:21)
C:\Users\raymo\Desktop\Java\hxtt\demo\src>
|
Thank you very much for your assistance.
I was now able to make it work...
C:\Users\raymo\Desktop\Java\hxtt\demo\src>java -cp C:\Users\raymo\Desktop\Java\hxtt\lib\Excel_JDBC30.jar;. Example1
number DOUBLE
name VARCHAR
message VARCHAR
1.0 r3 hello
2.0 rrr world
|
Main
webmaster@hxtt.com