Resolved - @PreUpdate not working in JUnit test.

 



javax.persistence.PreUpdate

object need to be "dirty" to trigger...

obj.setColumn01("text");

repo.save(obj);

then make obj "dirty" before save to trigger @PreUpdate


obj.setColumn01("new text);
repo.save(obj);

Reference URL: https://www.javafixing.com/2021/12/fixed-preupdate-does-not-work-with.html

Solution

As you said, the callback method is called the second time, if the entity is detached or fetched again from DB.

I cannot explain it exactly, but can think of the scenario described here, when no dirty fields are identified before the second save() call and thus the @PreUpdate callback not called. Or it may be simply a bug within your version of EclipseLink.

Setup local Keycloak for development

 




https://stackoverflow.com/a/72600716

Keycloak 18.0.2 doesn't required "/auth" as endpoint

new config:

keycloak.auth-server-url=http://localhost:8080

would be enough

We are sorry... page not found... error

Mandatory Config in Keycloak

while hitting we are sorry page not found error

was using http://localhost:8080/auth for keycloak.auth-server

while testing with https://www.keycloak.org/app/

hit error if didn't fill: https://www.keycloak.org/app/

to:

Root URL: https://www.keycloak.org/app/

If config below never in place, will trigger error: Invalid parameter: redirect_uri

Valid Redirect URIs: *

Respective Keycloak role in Spring Boot authRole config

 





keycloak.securityConstraints[0].authRoles[0]=xyz





Respective config in Keycloak (18.0.2)

In user Role mappings:

Different of SVNs

 SVN




Getting(install) SVN feature from

Eclipse Marketplace... VS  Install New Software






Eclipse Marketplace...

Install New Software

http://subclipse.tigris.org/update_1.6.x

subclipse.tigris.org no longer available...

 

http://subclipse.tigris.org/update_1.10.x

http://subclipse.tigris.org/update_1.6.x

above are not reachable...

Found a post telling to get from Eclipse Marketplace

Help > Eclipse Marketplace...

But during installation, but still retrieve resource from:

- 

"Spring" JPA "native query" java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

 


"Spring" JPA "native query" java.lang.IndexOutOfBoundsException: Index: 1, Size: 1



Exception Snippet:

java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

at java.util.ArrayList.rangeCheck(ArrayList.java:659)

at java.util.ArrayList.get(ArrayList.java:435)

at org.springframework.data.repository.query.ResultProcessor$ProjectingConverter.toMap(ResultProcessor.java:278)

at org.springframework.data.repository.query.ResultProcessor$ProjectingConverter.getProjectionTarget(ResultProcessor.java:266)

at org.springframework.data.repository.query.ResultProcessor$ProjectingConverter.convert(ResultProcessor.java:253)

at org.springframework.data.repository.query.ResultProcessor$ChainingConverter$1.convert(ResultProcessor.java:201)

at org.springframework.data.repository.query.ResultProcessor$ChainingConverter.convert(ResultProcessor.java:212)

...

Throw error with:

List<Map<String, Object>> getNativeQueryList();

or

List<Tuple> getNativeQueryList();

Work around with:

List<Object[]> getNativeQueryList();

JUnit test - Caused by: javax.persistence.RollbackException: Transaction marked as rollbackOnly

 

Exception snippet:

12:02:34.849|WARN |Caught exception while allowing TestExecutionListener [org.springframework.test.context.transaction.TransactionalTestExecutionListener@1a84f40f] to process 'after' execution for test: method [public void test.com.tiongnam.repositories.TestInvoicePackageRepo.testListPossiblePackageWithInvoiceIdAndSummary()], instance [test.com.tiongnam.repositories.TestInvoicePackageRepo@ca2cd5e], exception [java.lang.IndexOutOfBoundsException: Index: 1, Size: 1]|main|org.springframework.test.context.TestContextManager

org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction marked as rollbackOnly

at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:526)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)

at org.springframework.test.context.transaction.TransactionContext.endTransaction(TransactionContext.java:128)

at org.springframework.test.context.transaction.TransactionalTestExecutionListener.afterTestMethod(TransactionalTestExecutionListener.java:227)

at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:319)

at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:94)

at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)

at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)

at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)

...

Caused by: javax.persistence.RollbackException: Transaction marked as rollbackOnly

at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:58)

at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)

... 26 common frames omitted

@Rollback(false)
MyJUnitTestClass

Calling a @Transactional Repo

change
@Rollback(true)

Alternative - Error Code: 1093. You can't specify target table 'YOUR_TABLE' for update in FROM clause

 

Error Code: 1093. You can't specify target table 'YOUR_TABLE' for update in FROM clause

UPDATE YOUR_TABLE SET columnA = 'def' WHERE id IN (SELECT id AS MMID FROM YOUR_TABLE WHERE columnA = 'abc');

UPDATE YOUR_TABLE SET columnA = 'def' WHERE id IN ( SELECT MMID FROM ( SELECT id AS MMID FROM YOUR_TABLE WHERE columnA = 'abc' ) AS YOUR_ALIAS );

JasperReport, always get blank PDF?

 
line below with new JREmptyDataSource() will get pdf as per expected.

jasperPrint = JasperFillManager.fillReport(report, jrParam, new JREmptyDataSource());



vs

where as using static _DATA_SOURCE_EMPTY, will always get blank pdf.

private static JREmptyDataSource _DATA_SOURCE_EMPTY = new JREmptyDataSource();

...

jasperPrint = JasperFillManager.fillReport(report, jrParam, _DATA_SOURCE_EMPTY);

...

Multiple JasperPrint into a pdf with output as file and byte[]

 Multiple JasperPrint into a pdf with output as file and byte[]

JasperExportManager.exportReportToPdf vs JRPdfExporter.exportReport()








Found: https://community.jaspersoft.com/questions/526021/how-merge-multiple-pdf-jasper-reports-one

Found: https://www.programcreek.com/java-api-examples/?api=net.sf.jasperreports.engine.export.JRPdfExporter

Multiple JasperPrint into a file

setCreatingBatchModeBookmarks

public void pdf() throws JRException { long start = System.currentTimeMillis(); List<JasperPrint> jasperPrintList = new ArrayList<JasperPrint>(); jasperPrintList.add((JasperPrint)JRLoader.loadObjectFromFile("build/reports/Report1.jrprint")); jasperPrintList.add((JasperPrint)JRLoader.loadObjectFromFile("build/reports/Report2.jrprint")); jasperPrintList.add((JasperPrint)JRLoader.loadObjectFromFile("build/reports/Report3.jrprint")); JRPdfExporter exporter = new JRPdfExporter(); exporter.setExporterInput(SimpleExporterInput.getInstance(jasperPrintList)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput("build/reports/BatchExportReport.pdf")); SimplePdfExporterConfiguration configuration = new SimplePdfExporterConfiguration(); configuration.setCreatingBatchModeBookmarks(true); exporter.setConfiguration(configuration); exporter.exportReport(); System.err.println("PDF creation time : " + (System.currentTimeMillis() - start)); }

JRPdfExporter to byte array

Found: https://www.tabnine.com/code/java/methods/net.sf.jasperreports.engine.export.JRPdfExporter/setParameter

public byte[] exportToPdf(JasperPrint jasperPrint) throws JRException { ByteArrayOutputStream baos = new ByteArrayOutputStream(); JRPdfExporter exporter = new JRPdfExporter(jasperReportsContext); exporter.setExporterInput(new SimpleExporterInput(jasperPrint)); exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(baos)); exporter.exportReport(); return baos.toByteArray(); }

more Java JRPdfExporter.exportReport方法代碼示例

Found: https://vimsky.com/zh-tw/examples/detail/java-method-net.sf.jasperreports.engine.export.JRPdfExporter.exportReport.html

示例1: export

示例2: savePDFReportToOutputStream

示例3: concatPDFReport

示例4: concatPDFReportEncrypted

Billson: file

示例5: pdf

Resolved: No qualifying bean of type 'org.springframework.boot.web.client.RestTemplateBuilder'

 
JUnit

TestCase

Spring Boot

Add annotation of 

@AutoConfigureWebClient

to your test case.

org.springframework.boot.test.autoconfigure.web.client.AutoConfigureWebClient

Together with

@ContextConfiguration(classes = {LocalConfig.class})

org.springframework.test.context.ContextConfiguration

public class LocalConfig {

/**

* 

*/

public LocalConfig() {

}

@Bean

public RestTemplate restTemplate(RestTemplateBuilder builder) {

   // Do any additional configuration here

   return builder.build();

}

}

to resolve this.

Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'org.springframework.boot.web.client.RestTemplateBuilder' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {}

org.springframework.beans.factory.BeanFactory.getBean( ) with args

 

org.springframework.beans.factory.BeanFactory.getBean( ) with args


Source URL: https://www.programcreek.com/java-api-examples/?class=org.springframework.beans.factory.BeanFactory&method=getBean

public static void main(String[] args) {
    // 配置 XML 配置文件
    // 启动 Spring 应用上下文
    BeanFactory beanFactory = new ClassPathXmlApplicationContext("classpath:/META-INF/bean-instantiation-context.xml");
    User user = beanFactory.getBean("user-by-static-method", User.class);
    User userByInstanceMethod = beanFactory.getBean("user-by-instance-method", User.class);
    User userByFactoryBean = beanFactory.getBean("user-by-factory-bean", User.class);
    System.out.println(user);
    System.out.println(userByInstanceMethod);
    System.out.println(userByFactoryBean);

    System.out.println(user == userByInstanceMethod);
    System.out.println(user == userByFactoryBean);

}

Details at:

1. https://github.com/mercyblitz/geekbang-lessons
2. https://www.programcreek.com/java-api-examples/?project_name=mercyblitz%2Fgeekbang-lessons
3. 
   

@RunWith vs @SpringBootTest

 

https://stackoverflow.com/questions/58901288/springrunner-vs-springboottest

URL: https://stackoverflow.com/a/58902051

@RunWith(SpringRunner.class) : You need this annotation to just enable spring boot features like @Autowire, @MockBean etc.. during junit testing

is used to provide a bridge between Spring Boot test features and JUnit. Whenever we are using any Spring Boot testing features in our JUnit tests, this annotation will be required.

@SpringBootTest : This annotation is used to load complete application context for end to end integration testing

The @SpringBootTest annotation can be used when we need to bootstrap the entire container. The annotation works by creating the ApplicationContext that will be utilized in our tests.

Here is the article with clear examples on both scenarios Baeldung

Resolved: Caused by: java.lang.IllegalStateException: Unable to retrieve @EnableAutoConfiguration base packages

 




Referring to URL below:
https://github.com/spring-projects/spring-boot/issues/10465#issuecomment-336397898

 
Added @AutoConfigurationPackage to avoid error: Caused by: java.lang.IllegalStateException: Unable to retrieve @EnableAutoConfiguration base packages

into the class u made as:

org.springframework.context.annotation.Configuration




Relevant reads:

1. https://blog.csdn.net/wuqingsssss/article/details/113115809
2. https://its401.com/article/wuqingsssss/113115809
3. 
   

Regex to split htop details

 

^( *\d+) (\w+) +(\d+) +(-?\d+) +(\d+.?\d?\w?) +(\w+) +(\w+) +S +(\d+.?\d+) +(\d+.?\d+) +(\d+h?:?\d?\d?:?\.?\d?\d?) +[├│└][\+─ ] (.*)$

Web characters - emoji

 

Emoji 14.0

2021-09-14

Unicode 14.0

E14.0

🌏🗺🧭

🦷
➀➁➂➃➄➅➆➇➈➉

🏀

🎮🕹🎮🕹

🔋

🉑

more at: https://www.w3schools.com/charsets/ref_utf_dingbats.asp




🇲🇾
more at: https://unicode.org/emoji/charts/full-emoji-list.html

Emoji Versions

Emoji Version	Date	Unicode Version	Data File Comment
N/A	various	various	E0.0
N/A	2010-10-11	Unicode 6.0	E0.6
N/A	2014-06-16	Unicode 7.0	E0.7
Emoji 1.0	2015-06-09	Unicode 8.0	E1.0
Emoji 2.0	2015-11-12	Unicode 8.0	E2.0
Emoji 3.0	2016-06-03	Unicode 9.0	E3.0
Emoji 4.0	2016-11-22	Unicode 9.0	E4.0
Emoji 5.0	2017-06-20	Unicode 10.0	E5.0
Emoji 11.0	2018-05-21	Unicode 11.0	E11.0
Emoji 12.0	2019-03-05	Unicode 12.0	E12.0
Emoji 12.1	2019-10-21	Unicode 12.1	E12.1
Emoji 13.0	2020-03-10	Unicode 13.0	E13.0
Emoji 13.1	2020-09-15	Unicode 13.0	E13.1
Emoji 14.0	2021-09-14	Unicode 14.0	E14.0