spring - could not extract ResultSet; SQL [n/a] when I tried save entity with Repository -


i try use springrepository , have error.

my entity

@entity @table(name = "mb_subscriber") @getter @setter public class subscriber {     public subscriber() {}     @id     @generatedvalue(strategy = generationtype.sequence, generator = "mb_subscriber_seq")     @sequencegenerator(name = "mb_subscriber_seq", sequencename = "mb_subscriber_seq", allocationsize = 1)     private long id;     @column(name = "datecreated")     private date datecreated;     @column(name = "msisdn")     private string msisdn;     @column(name = "ban")     private string ban;     @column(name = "amount")     private double amount; } 

repository class

public interface subscriberreposetory extends jparepository<subscriber, long> { } 

and when tried subscriber savedsubscriber = subscriberreposetory.save(subscriber);

i error

method threw 'org.springframework.dao.invaliddataaccessresourceusageexception' exception.  not extract resultset; sql [n/a]  org.hibernate.exception.sqlgrammarexception: not extract resultset 

i use oracle db sequence

edit

#basic spring boot config oracle oracle.url=jdbc:oracle:thin:@//mydb:1521/mydb oracle.username=pass oracle.password=login spring.datasource.driver-class-name=oracle.jdbc.oracledriver  #hibernate config spring.jpa.database-platform=org.hibernate.dialect.oracle10gdialect 

i think error because table not create dont know how curectly write configs


Comments