Hello All,
I recently downloaded a ODBC driver (17th Aug 2001 release) called LinkBook for QuickBooks. The driver when used with
JAVA(JDK1.1.8 ) ie accessed using JDBC-ODBC Bridge works fine and allows me to acess data stored inside .QBW files of QuickBooks.
But when I try to run the same code using JDK1.3,it throws me an exception saying
"Exception in
thread "main" java.sql.SQLException: The result set type is not supported.
at sun.jdbc.odbc.JdbcOdbcStatement.initialize(JdbcOdbcStatement.java:154)
at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.java:420)
at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.java:394)
at checkQuickBook.main(checkQuickBook.java:16)"
If any one has accessed QuickBooks .QBW files by any means using JAVA,I would like to hear from u.Kindly help me,its urgent.
here is the code that I have written.Kindly help me solve this problem.
CODE
----------------------------------------------------------------------------------------------------------------------------------
import java.sql.*;
public class checkQuickBook
{
public static void main(
String args[]) throws Exception
{
String url = "jdbc

dbc:myfirstlinktoquickbooks";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url,"","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Budgets");//Budgets is a table in default DB that comes with QuickBooks
while(rs.next())
{
System.out.println(rs.getString(1));
}
}
}