Error in executeUpdate, Invalid character string format for type long.

[ksco...@gmail.com]

I am trying out this library so this most likely a silly mistake on my part.

Here is my in memory Apache Derby table :

              String sql="CREATE TABLE Author ("
                      + "author_id BIGINT  NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),"
                      + "first_name VARCHAR(40),"
                      + "last_name VARCHAR(40) "
                      //+ "PRIMARY_KEY(author_id)"
                      + ")";

Here is the code I am using.   It does a simple update with a where clause: 

public void update(Author entity)  {
 
       
        String sql="UPDATE author SET first_name=:firstName ,last_name=:lastName WHERE author_id = :authorId";
    
        Long id=entity.getAuthorId();
        log.debug("id="+id );
        try (Connection con = sql2o.open()) {
            int rows=con.createQuery(sql)
                .addParameter("authorId", id )
                .addParameter("firstName", entity.getFirstName() )
                .addParameter("lastName", entity.getLastName() )
                .executeUpdate()
                .getResult();
            log.debug("rows="+rows);
        }
       
    } 

[Николай Митропольский]

Hello!

Probably you should provide additional info, for example about versions of libraries you use. Because in my case your code successfully works.

BR, Nicolay

воскресенье, 29 января 2017 г., 8:42:31 UTC+3 пользователь ksco...@gmail.com написал:

[ksco...@gmail.com]

I re-tested with the latest Apache  Derby v10.13.1.1 and I now have no issues.  So I guess I just picked a bad version from  MVN central.

Thanks,