Home

java.sql.SQLException: Non supported SQL92 token at position: 377:


Solution:

The syntax is not correct for executing a database query, function, procedure, or package. Make corrections to your query.

Like -

 CallableStatement call = con.prepareCall("{call docnumber_generation(?,?,?,?,?,?,?,?)}"); 

// Here inside string 'call' is important to call the procedure

1 comment:

4. org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract java.util.List com.roman.demo.ProgrammerRepo.ProgrammerRepo.findN(java.lang.String)

 Solution :  Add below query annotation  @Query(value="SELECT * FROM programmer WHERE name = ?1", nativeQuery = true ) instead of ...