Appolgies... As I mentioned when I sent the example, I just hacked
together some example code from an old example I had lying around. I
only looked very briefly at the prepareStatement() javadoc and must have
missed an argument.
Lance is right about the correct API.
-Tom
Lance J. Andersen wrote:
> Hi Markus,
>
>> Well there is one bug already as it should throw a SQLException not
>> OperationNotSupportedException
>>
>> You lost me on the :
>>
>> The driver needs an explicit "CONCUR_*"
>>
>> Can you please explain this a little further, what is the statement
>> you were expecting to work?
>
>
> Are you referring to:
>
> PreparedStatement stmt = conn.prepareStatement("select * from
> mytable", java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE);
>
> This is not valid and i suspect it is being executed as:
>
> prepareStatment(String sql, int autoGeneratedKeys)
>
> Which will result in an error as the value for
> java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE is out of range for this
> method.
>
>
> The valid Connection.prepareStatement methods are:
>
> | PreparedStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/PreparedStatement.html>|
> |*prepareStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#prepareStatement%28java.lang.String%29>*(String
> <http://java.sun.com/j2se/1.5.0/docs/api/java/lang/String.html> sql)|
> Creates a |PreparedStatement| object for sending
> parameterized SQL statements to the database.
> | PreparedStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/PreparedStatement.html>|
> |*prepareStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#prepareStatement%28java.lang.String,%20int%29>*(String
> <http://java.sun.com/j2se/1.5.0/docs/api/java/lang/String.html> sql,
> int autoGeneratedKeys)|
> Creates a default |PreparedStatement| object that has the
> capability to retrieve auto-generated keys.
> | PreparedStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/PreparedStatement.html>|
> |*prepareStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#prepareStatement%28java.lang.String,%20int%5B%5D%29>*(String
> <http://java.sun.com/j2se/1.5.0/docs/api/java/lang/String.html> sql,
> int[] columnIndexes)|
> Creates a default |PreparedStatement| object capable of
> returning the auto-generated keys designated by the given array.
> | PreparedStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/PreparedStatement.html>|
> |*prepareStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#prepareStatement%28java.lang.String,%20int,%20int%29>*(String
> <http://java.sun.com/j2se/1.5.0/docs/api/java/lang/String.html> sql,
> int resultSetType, int resultSetConcurrency)|
> Creates a |PreparedStatement| object that will generate
> |ResultSet| objects with the given type and concurrency.
> | PreparedStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/PreparedStatement.html>|
> |*prepareStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#prepareStatement%28java.lang.String,%20int,%20int,%20int%29>*(String
> <http://java.sun.com/j2se/1.5.0/docs/api/java/lang/String.html> sql,
> int resultSetType, int resultSetConcurrency, int resultSetHoldability)|
> Creates a |PreparedStatement| object that will generate
> |ResultSet| objects with the given type, concurrency, and holdability.
> | PreparedStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/PreparedStatement.html>|
> |*prepareStatement
> <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#prepareStatement%28java.lang.String,%20java.lang.String%5B%5D%29>*(String
> <http://java.sun.com/j2se/1.5.0/docs/api/java/lang/String.html> sql,
> String
> <http://java.sun.com/j2se/1.5.0/docs/api/java/lang/String.html>[] columnNames)|
>
> Creates a default |PreparedStatement| object capable of
> returning the auto-generated keys designated by the given array.
>
>
>
> regards
> Lance