It’s also possible to simplify the answer from @chrosciu with this: @Configuration public class WebSecurityConfig extends WebSecurityConfigurerAdapter { @Override protected void configure(HttpSecurity http) throws Exception { http.headers().frameOptions().disable(); } }
As the exception message says, “Database may be already in use”. You need to close all other connection(s), to make sure the database is not open in another process concurrently. By the way, don’t use AUTO_SERVER=TRUE and the server mode at the same time. See the documentation for the automatic mixed mode. Use either one. … Read more
In application.properties, add following setting. spring.h2.console.settings.web-allow-others=true In my case, it works.
Find out what threads are still running (or blocked, waiting to run) by using jstack or sending a signal to the process: kill -3 pid When you know this, you can make whatever it was that started them hook into the shutdown notification to stop the threads. Or make those threads deamon threads. See This … Read more
According to my test, with H2 version 1.3.170, the milliseconds are not actually zero, but 069: select * from test; ID DATE 1 2012-09-17 18:47:52.069 The same happens if you run: call parsedatetime(’17-09-2012 18:47:52.69′, ‘dd-MM-yyyy hh:mm:ss.SS’); If you add a zero then it works: call parsedatetime(’17-09-2012 18:47:52.690′, ‘dd-MM-yyyy hh:mm:ss.SS’); H2 internally uses java.text.SimpleDateFormat, so it … Read more
For testing, you can insert literal hex bytes or use the RAWTOHEX(string) function, as shown below. create table a(id integer, item blob); insert into a values(1,’54455354′); insert into a values(2, RAWTOHEX(‘Test’)); select UTF8TOSTRING(item) from a; TEST Test Addendum: For loading BLOB fields from a file, FILE_READ(fileNameString) may be a useful alternative. insert into a values(3, … Read more
This is now automatically enabled since version 1.4.177 Beta (2014-04-12). You can disable it by adding ;MV_STORE=FALSE and ;MVCC=FALSE to the database URL By default, the MV_STORE option is enabled, so it is using the new MVStore storage. The MVCC setting is by default set to the same values as the MV_STORE setting, so it … Read more
First: check the case in which you type tables’ names. It’s very important. word_types and WORD_TYPES are two different tables. Second: If you want to check if table exists and if it doesn’t then create one, I recommend you to use the following example: CREATE TABLE IF NOT EXISTS TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
From section 12.1.12. CREATE VIEW Syntax of the MySQL 5.0 Reference Manual: CREATE VIEW Syntax CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = { user | CURRENT_USER }] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] The CREATE VIEW statement creates … Read more
Try to use strategy=GenerationType.IDENTITY instead of the strategy=GenerationType.AUTO Also could be wrong hibernate.dialect Try the hibernate.dialect=org.hibernate.dialect.H2Dialect