Problem in using createStatement with parameters
Hi,
I have a peculiar problem using JDBC-ODBC bridge driver. With this driver I am able to make a connection to the database (Oracle/SQL Server/MS-Access). But when I try to create a statement using the connection, I get an error. The code written by me is below :-
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:tsvt","sa","");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
If I use this constructor fo createStament, I get the following Runtime Exception
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:2494)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:314)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:229)
at accs2oracl.<init>(accs2oracl.java:39)
at accs2oracl.main(accs2oracl.java:166)
If I use just conn.createStatement(), I dont get any error.
Some one help me out where I am going wrong
