Skip to main content

Posts

Showing posts from January, 2021

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

 Problem ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view 12054. 00000 -  "cannot set the ON COMMIT refresh attribute for the materialized view" *Cause:    The materialized view did not satisfy conditions for refresh at commit time. *Action:   Specify only valid options. Solution  You can not use the DISTINCT keyword in your Materialized View query, rather use Group By instead of distinct You can not use the standard JOIN in your query, instead, you should use the old-styled Join like A, B where A.ID = B.ID     

Spring Boot Maven plugin - How to deploy WAR to an external tomcat's webapp folder?

 Introduction Spring Boot Maven plugin by default generates the WAR file inside the target folder. In this post, I will explain how to copy the generated war file to an external Tomcat's webapps folder using Spring Boot Maven plugin. In my earliest post , you can learn how to package a Spring Boot application as WAR.  Solution Step 1  Follow this link to specify the packaging as WAR in pom.xml and also to configure the  SpringBootServletInitializer class Step 2 (optional) Specify a cleaner name for WAR using the finalName tag in pom.xml  <finalName>auth</finalName> Step 3 Specify the outputDirectory directory      <build> <finalname>auth</finalname> <plugins> <plugin>           <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-maven-plugin</artifactid> <configuration>           <outputdirectory>D:/Development Utils/apache-tomcat-9.0.30/webapps</outputdirectory>