String index out of range. Java Spring Boot

Question

I am trying to run a query using a Data Access Object within a Spring Application but I get a String index out of range error.

This is my DAO

public class UserDao {

   private JdbcTemplate jdbcTemplate;

   public void setJdbcTemplate(JdbcTemplate jdbcTemplate){
       this.jdbcTemplate = jdbcTemplate;
   }

   public int saveUser(User u){
    
     String query = "INSERT INTO `users` VALUES('"+u.getFirstName()+"','"+u.getLastName()+"','"
         +u.getEmail()+"','"+u.getCreatedAt()+"','"+u.getCreatedBy()+"','"+u.getUpdatedAt()+"','"+u.getUpdatedBy()+"')";
 
    return jdbcTemplate.update(query);
  }

}

This is the error

This is my Database table structure

Even if I substitute the getter methods with actual values I still get the error

Are you sure, that you use the correct driver implementation? You tagged question as 'mysql', but in stacktrace I see oracle driver — Anton Shelenkov
– Anton Shelenkov, Commented Sep 21, 2020 at 7:03
Does this answer your question? String out of index with SQL developer — Sudhir Ojha
– Sudhir Ojha, Commented Sep 21, 2020 at 7:04
A bit of off-topic advice is to use PreparedStatement for building queries, avoid concatenating string yourself for SQL queries. This could lead to SQL Injection attacks. docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html — miiiii
– miiiii, Commented Sep 21, 2020 at 7:28
Turns out I was using the wrong DRIVER implementation. I followed this tutorial spring.io/guides/gs/accessing-data-mysql and everything works fine now. Thanks! — RynohRR
– RynohRR, Commented Sep 21, 2020 at 8:36

marc_s · Accepted Answer · 2020-09-24 04:46:41Z

0

Try using syntax like this:

String.format("INSERT INTO USERS(first_name, last_name, etc...) VALUES(%s, %s, etc...);

It will return a string dynamically created by String.format() method.

Because if you are not defined column names you have to maintain the order in values, and it could be bad because you are missing the id column.

P.S. %d - stands for numbers, %s - stands for strings

edited Sep 24, 2020 at 4:46

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 21, 2020 at 8:43

Vielen Danke

1871 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

String index out of range. Java Spring Boot

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related