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
Post a Comment