H2-Console is not showing in browser

If you have override configure method of Spring Security and you want to use console of h2 database in browser, and after connect h2-console showing loading error as shown in below image.



Then you have to add following line in your overridden configure method.

@EnableWebSecurity
public class SecurityConfig extends WebSecurityConfigurerAdapter {
  Logger logger = LoggerFactory.getLogger(SecurityConfig.class);
  
 //......
  
  
  @Override
  protected void configure(HttpSecurity http) throws Exception {
    http.authorizeRequests().antMatchers("/").permitAll();
    http.authorizeRequests().antMatchers("/imgs/**").permitAll();
    http.authorizeRequests().antMatchers("/admin/**").hasRole("ADMIN");
    http.authorizeRequests().antMatchers("/**").hasRole("USER").and().formLogin();
   
    // add this line to use H2 web console

   http.headers().frameOptions().disable();

  }
}

After adding that BOLD line, your issue would be resolved. :)

Comments

Post a Comment

Popular posts from this blog

Data Bound Controls in ASP.Net - Part 4 (FormView and DetailsView controls)

FormView The FormView control is used to display a single record from a data source. It is similar to the DetailsView control, except it displays user-defined templates instead of row fields. Creating your own templates gives you greater flexibility in controlling how the data is displayed. The FormView control supports the following features: ·          Binding to data source controls, such as SqlDataSource and ObjectDataSource. ·          Built-in inserting, updating and deleting capabilities. ·          Built-in paging capabilities. ·          Programmatic access to the FormView object model to dynamically set properties, handle events, and so on. ·          Customizable appearance through user-defined templates, themes, and styles. Templates For the FormView control ...
Read more

JavaScript - ES2015 (aka ES6)

The ES2015 Since this long time passed between ES5.1 and ES6, the release is full of important new features and major changes in suggested best practices in developing JavaScript programs. To understand how fundamental ES2015 is, just keep in mind that with this version, the specification document went from 250 pages to ~600. In this blog, we describe the most important changes. Arrow Functions A new  this   scope Promises Generators let   and  const Classes Constructor Super Getters and setters Modules Importing modules Exporting modules Template Literals Default parameters The spread operator Destructuring assignments Enhanced Object Literals Simpler syntax to include variables Prototype super() Dynamic properties For-of loop Map and Set New String methods New Object methods Arrow functions Arrow functions since their introduction changed how most JavaScript code looks (and works). Visually, it’s a simple and welcome ...
Read more

Uninstall all Azure PowerShell Modules

Image
With Azure PowerShell modules changing all the time and the recent introduction of the   PowerShell modules being renamed from AzureRm to Az , you may want to totally uninstall all modules and reinstall to make sure you are using the latest and greatest modules. To do so, the following scripit will go through and cleanup all the Azure(RM)(AD) modules.  Simply open up PowerShell as an Administrator and execute the following PowerShell workflow/commands: workflow Uninstall-AzureModules {     $Modules = @() $Modules += (Get-Module -ListAvailable Azure*).Name    $Modules += (Get-Module -ListAvailable Az.*).Name     Foreach -parallel ($Module in ($Modules | Get-Unique))     {         if($Modules)          {                Write-Output ("Uninstalling: $Module")         ...
Read more