Spring H2 Database, Not Creating table in Database -


the following code creating test.mv.db file. run , show has inserted data in database.

schema:

create table customer (     id identity,     firstname varchar(20) not null,     lastname varchar(20) not null );

main class:

public class app {      public static void main(string[] args) {          annotationconfigapplicationcontext ctx = new annotationconfigapplicationcontext(config.class);          customerrepository repo = ctx.getbean(customerrepository.class);          customer c1 = new customer("john", "doe");         customer c2 = new customer("jane", "doe");          // insert         c1 = repo.save(c1);         c2 = repo.save(c2);          for(customer t : repo.findall()) {             system.out.println(t.getfirstname()+", "+t.getlastname());         }         ctx.close();     }  }

config:

@configuration @componentscan public class config {      @bean     public datasource datasource() {         drivermanagerdatasource ds = new drivermanagerdatasource();          ds.setdriverclassname("org.h2.driver");         ds.seturl("jdbc:h2:~/test;db_close_delay=-1;db_close_on_exit=false");          resource schema = new classpathresource("schema.sql");         resourcedatabasepopulator dbp = new resourcedatabasepopulator();         dbp.addscript(schema);         databasepopulatorutils.execute(dbp, ds);          return ds;     }      @bean     public jdbcoperations jdbctemplate(datasource ds) {         return new jdbctemplate(ds);             }  }

customer class:

public class customer {      private long id;     private string firstname;     private string lastname;      public customer() {}      public customer(long id, string firstname, string lastname) {         super();         this.id = id;         this.firstname = firstname;         this.lastname = lastname;     }      public customer(string firstname, string lastname) {         super();         this.firstname = firstname;         this.lastname = lastname;     }      public long getid() {         return id;     }      public void setid(long id) {         this.id = id;     }      public string getfirstname() {         return firstname;     }      public void setfirstname(string firstname) {         this.firstname = firstname;     }      public string getlastname() {         return lastname;     }      public void setlastname(string lastname) {         this.lastname = lastname;     }    }

customerrepository interface:

public interface customerrepository {      customer findone(long id);      customer save(customer cust);      list<customer> findall();      int update(customer cust);      int delete (customer cust);  }

customerrepositoryimpl:

@repository public class customerrepositoryimpl implements customerrepository {      @autowired     private jdbcoperations jdbc;      private static final string sql_insert = "insert customer (firstname, lastname) values (?, ?)";     private static final string sql_update = "update customer set firstname=?, lastname=? id=?";     private static final string sql_find_one = "select * customer id = ?";     private static final string sql_find_all = "select * customer order lastname";     private static final string sql_delete_one = "delete customer id = ?";       public customer findone(long id) {         return jdbc.queryforobject(sql_find_one, new customerrowmapper(), id);     }      public customer save(final customer cust) {          keyholder holder = new generatedkeyholder();          int rows = jdbc.update(new preparedstatementcreator() {              public preparedstatement createpreparedstatement(connection conn) throws sqlexception {                 preparedstatement ps = conn.preparestatement(sql_insert, new string[]{"id"});                  ps.setstring(1,  cust.getfirstname());                 ps.setstring(2, cust.getlastname());                  return ps;             }         }, holder);          if(rows == 1) { // success, apply id customer object             cust.setid((long)holder.getkey());             return cust;         }          return null;      }      public list<customer> findall() {         return jdbc.query(sql_find_all, new customerrowmapper());     }      public int update(customer cust) {         return jdbc.update(sql_update, cust.getfirstname(), cust.getlastname(), cust.getid());     }      public int delete(customer cust) {         return jdbc.update(sql_delete_one, cust.getid());     }      private class customerrowmapper implements rowmapper<customer> {          public customer maprow(resultset rs, int row) throws sqlexception {              return new customer(rs.getlong("id"), rs.getstring("firstname"), rs.getstring("lastname"));           }      } }

stacktrace:

aug 14, 2017 9:45:42 pm org.springframework.context.annotation.annotationconfigapplicationcontext preparerefresh info: refreshing org.springframework.context.annotation.annotationconfigapplicationcontext@b81eda8: startup date [mon aug 14 21:45:42 bdt 2017]; root of context hierarchy aug 14, 2017 9:45:43 pm org.springframework.jdbc.datasource.drivermanagerdatasource setdriverclassname info: loaded jdbc driver: org.h2.driver aug 14, 2017 9:45:43 pm org.springframework.jdbc.datasource.init.scriptutils executesqlscript info: executing sql script class path resource [schema.sql] aug 14, 2017 9:45:43 pm org.springframework.jdbc.datasource.init.scriptutils executesqlscript info: executed sql script class path resource [schema.sql] in 28 ms. aug 14, 2017 9:45:43 pm org.springframework.context.annotation.annotationconfigapplicationcontext doclose info: closing org.springframework.context.annotation.annotationconfigapplicationcontext@b81eda8: startup date [mon aug 14 21:45:42 bdt 2017]; root of context hierarchy john, doe jane, doe

problem

but on second run saved data no more there. first checked dbeaver, if there table within database named customer. not find any.

then commented out following lines - 

c1 = repo.save(c1); c2 = repo.save(c2);

from app.java

becasue, if there data read there 

for(customer t : repo.findall()) {     system.out.println(t.getfirstname()+", "+t.getlastname()); }

but no luck here well.

what can problem please?

a working solution derby welcome database saved in pc.


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more