Error to Read Excel for Unix
Hi,
I develop one class for read the sheet Excel and write one table Oracle.
The Class go perfectly i in Windows XP but in Unix go error :
Exception in thread "main" java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at src.GestioneXLS.inserisciFlussi(GestioneXLS.java:108)
at src.GestioneXLS.elaboraFile(GestioneXLS.java:91)
at src.GestioneXLS.esegui(GestioneXLS.java:53)
at src.ContestMain.main(ContestMain.java:29)
The code is :
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Connect to Excel DSN
System.out.println(nomeFile.getPath());
//Statement 108
Connection connection = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ="+nomeFile.getPath()+";DriverID=22;READONLY=false","","");
Statement st=connection.createStatement();
You can Help me ?
thank..
