sayana
15 years agoNew Contributor
jdbc excel error
I was using the JDBC request step for a particular test case.
I entered the driver as: sun.jdbc.odbc.JdbcOdbcDriver
and connection string as :jdbc:odbc:Driver=Microsoft Excel Driver (*.xls);DBQ=D:/data1.xls
the connectivity was also tested successfully.
on entering the sql query as : select * from [sheet$] where ID = 3
and running the test , I got the following error msg in the request log :
2010-12-21 10:27:49 - Error getting response; null
and the following msg in the error log:
Tue Dec 21 10:27:49 IST 2010:ERROR:java.sql.SQLException: Invalid Fetch Size
java.sql.SQLException: Invalid Fetch Size
at sun.jdbc.odbc.JdbcOdbcStatement.setFetchSize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.setFetchSize(Unknown Source)
at com.eviware.soapui.support.xml.XmlUtils.createJdbcXmlResult(XmlUtils.java:1448)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcResponse.<init>(JdbcResponse.java:36)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.createResponse(JdbcSubmit.java:329)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:198)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:160)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
How do i go about access data from excel using JDBC Request step as I keep getting the null error?
I entered the driver as: sun.jdbc.odbc.JdbcOdbcDriver
and connection string as :jdbc:odbc:Driver=Microsoft Excel Driver (*.xls);DBQ=D:/data1.xls
the connectivity was also tested successfully.
on entering the sql query as : select * from [sheet$] where ID = 3
and running the test , I got the following error msg in the request log :
2010-12-21 10:27:49 - Error getting response; null
and the following msg in the error log:
Tue Dec 21 10:27:49 IST 2010:ERROR:java.sql.SQLException: Invalid Fetch Size
java.sql.SQLException: Invalid Fetch Size
at sun.jdbc.odbc.JdbcOdbcStatement.setFetchSize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.setFetchSize(Unknown Source)
at com.eviware.soapui.support.xml.XmlUtils.createJdbcXmlResult(XmlUtils.java:1448)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcResponse.<init>(JdbcResponse.java:36)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.createResponse(JdbcSubmit.java:329)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:198)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:160)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
How do i go about access data from excel using JDBC Request step as I keep getting the null error?