| Author |
Exception - To connect excel sheet
|
bala kumar
Greenhorn
Joined: Sep 13, 2007
Posts: 10
|
|
i got the following error when i get the data from XL sheet to store the data into oracle db in LINUX . Code: String path = "/home/nfsmnt/resource_uploads/web_links/"+fileName; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection = DriverManager.getConnection("jdbc dbc river={Microsoft Excel Driver (*.xls)};DBQ="+path+";DriverID=22;READONLY=false","",""); Statement stmt = connection.createStatement(); Exception: 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:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.thomsonhighereducation.DAO.ResourceOrderDAO.addWeblinkData(ResourceOrderDAO.java:2239) at
|
 |
 |
|
|
subject: Exception - To connect excel sheet
|
|
|