Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 2988 invoked from network); 17 Feb 2006 07:26:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 17 Feb 2006 07:26:19 -0000 Received: (qmail 36461 invoked by uid 500); 17 Feb 2006 07:26:17 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 36434 invoked by uid 500); 17 Feb 2006 07:26:17 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 36423 invoked by uid 99); 17 Feb 2006 07:26:17 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Feb 2006 23:26:17 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [198.235.201.66] (HELO yk-pvtmailprd-01.internal.messaging) (198.235.201.66) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Feb 2006 23:26:15 -0800 Received: from yk-asavprd-01.northwestel.net ([172.19.112.40]) by yk-pvtmailprd-01.internal.messaging (Sun ONE Messaging Server 6.0 Patch 1 (built Jan 28 2004)) with ESMTP id <0IUT00MH1LW09F10@yk-pvtmailprd-01.internal.messaging> for derby-user@db.apache.org; Fri, 17 Feb 2006 00:24:00 -0700 (MST) Received: from localhost (localhost [127.0.0.1]) by yk-asavprd-01.northwestel.net (8.12.11/8.12.11) with ESMTP id k1H7O08U012080 for ; Fri, 17 Feb 2006 00:24:00 -0700 Received: from yk-asavprd-01.northwestel.net ([127.0.0.1]) by localhost (yk-asavprd-01 [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 11352-10 for ; Fri, 17 Feb 2006 00:23:58 -0700 (MST) Received: from 192.168.0.101 (whthyt228-243.northwestel.net [207.189.228.243]) by yk-asavprd-01.northwestel.net (8.12.11/8.12.11) with ESMTP id k1H7KnqG010171 for ; Fri, 17 Feb 2006 00:20:56 -0700 Date: Fri, 17 Feb 2006 00:34:02 -0800 From: Software Subject: Driver not capable To: derby-user@db.apache.org Reply-to: software@bardubitzki.com Message-id: <1140165242.2850.8.camel@localhost> Organization: BARDUBITZKI Software MIME-version: 1.0 X-Mailer: Ximian Evolution 1.4.6.330 Content-type: multipart/alternative; boundary="Boundary_(ID_mSSCCxAElBbnnMQkBMaUjw)" X-Virus-Scanned: by amavisd-new at northwestel.net X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --Boundary_(ID_mSSCCxAElBbnnMQkBMaUjw) Content-type: text/plain Content-transfer-encoding: 7BIT 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 --Boundary_(ID_mSSCCxAElBbnnMQkBMaUjw) Content-type: text/html; charset=utf-8 Content-transfer-encoding: 7BIT 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 --Boundary_(ID_mSSCCxAElBbnnMQkBMaUjw)--