Grails 3.2.6 with spring security. In memory h2 database is not created when saving users -


i didn't find solution other postings although seems problems others have encountered.

this application.yml

--- grails:     profile: web-plugin     codegen:         defaultpackage: bioprofile     spring:         transactionmanagement:             proxies: false info:     app:         name: '@info.app.name@'         version: '@info.app.version@'         grailsversion: '@info.app.grailsversion@' spring:     main:         banner-mode: "off"     groovy:         template:             check-template-location: false  # spring actuator endpoints disabled default endpoints:     enabled: false     jmx:         enabled: true  --- grails:     mime:         disable:             accept:                 header:                     useragents:                         - gecko                         - webkit                         - presto                         - trident         types:             all: '*/*'             atom: application/atom+xml             css: text/css             csv: text/csv             form: application/x-www-form-urlencoded             html:               - text/html               - application/xhtml+xml             js: text/javascript             json:               - application/json               - text/json             multipartform: multipart/form-data             pdf: application/pdf             rss: application/rss+xml             text: text/plain             hal:               - application/hal+json               - application/hal+xml             xml:               - text/xml               - application/xml     urlmapping:         cache:             maxsize: 1000     controllers:         defaultscope: singleton     converters:         encoding: utf-8     views:         default:             codec: html         gsp:             encoding: utf-8             htmlcodec: xml             codecs:                 expression: html                 scriptlets: html                 taglib: none                 staticparts: none endpoints:     jmx:         unique-names: true  --- hibernate:     cache:         queries: false         use_second_level_cache: true         use_query_cache: false         region.factory_class: org.hibernate.cache.ehcache.singletonehcacheregionfactory  datasources:     datasource:         pooled: true         jmxexport: true         driverclassname: org.h2.driver         username: sa         password:         dbcreate: create-drop         dialect : com.hp.opr.hibernate.dialect.h2dialect         url: jdbc:h2:mem:blogdb;mvcc=true;lock_timeout=10000;db_close_on_exit=false      master:         pooled: true         jmxexport: true         driverclassname: org.h2.driver         username: sa         password:         dbcreate: create-drop         url: jdbc:h2:mem:masterdb;mvcc=true;lock_timeout=10000;db_close_on_exit=false

but when application starts , in bootstrap try add users:

    user admin = new user(username: 'admin', password: 'password')     admin.save(flush: true)     user user = new user(username: 'user', password: 'user')     user.save(flsuh:true)      role adminrole = new role(authority: role.role_admin)     adminrole.save(flush:true)      role userrole = new role(authority: role.role_user)     userrole.save(flush:true)      userrole.create(admin, adminrole)     userrole.create(admin, userrole)     userrole.create(user, userrole)

no database created. if open console url: http://localhost:8080/dbconsole database created. idea why ?

you using in-memory configuration of h2 in grails config, no database file created. when open dbconsole, there problably connection string file instead of in-memory configuration, db file created. change config in dbconsole configuration.


Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more