Hi all,

I tried to insert a new row into a table with the following code:
[code]
protected void  insertField(ArrayList field) throws SQLException {
        try {
            Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                                 ResultSet.CONCUR_UPDATABLE);
            ResultSet rs = stmt.executeQuery("select * from marketing");
            rs.moveToInsertRow();
            rs.updateString(1, field.get(COMPANY).toString());
            rs.updateString(2, field.get(CONTACT).toString());
            rs.updateString(3, field.get(EMAIL).toString());
            rs.updateString(4, field.get(COUNTRY).toString());
            rs.updateString(5, field.get(CATEGORY).toString());
            rs.updateString(6, field.get(CAMPAIGN).toString());
            rs.updateString(7, field.get(HAS_LINK).toString());
            rs.updateString(8, field.get(COMMENT).toString());
            rs.insertRow();
            stmt.close();
        }
        finally {
            con.close();
        }
    }
[/code]
In the catalina.out I found the following SQLException:
[code]
org.apache.derby.client.am.SqlException: Driver not capable
at org.apache.derby.client.am.ResultSet.moveToInsertRow(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.moveToInsertRow(DelegatingResultSet.java:499)
at bardubitzki.bulkemail.servlet.DBManagement.insertField(DBManagement.java:84)
at bardubitzki.bulkemail.servlet.DatabaseServlet.processRequest(DatabaseServlet.java:58)
at bardubitzki.bulkemail.servlet.DatabaseServlet.doPost(DatabaseServlet.java:110)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
bardu: org.apache.derby.client.am.SqlException: Driver not capable
[/code]

Could somebody explain to me for what the driver isn't capable.

Thanks in advance.

Stephan