db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Software <softw...@bardubitzki.com>
Subject Driver not capable
Date Fri, 17 Feb 2006 08:34:02 GMT
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

Mime
View raw message