Some Trials & a lot of Errors: I tried a bunch of framework and other language and I usually feel overwhelm when its time to do something real with what I've learned. So that why I created this site, to write my progress and help some noob like me that stumble into the sames problems.

Solving LazyInitializationException with sonar rules @Transactional method called from another method doesn’t obtain a transaction

By Chris on May 12, 2021

We recently added a feature that allowed direct modification on our content for some client vs using the same path (queues) that the batched content is using.
Our user were really happy with it, but after our team implemented the new feature, we started having some LazyInitializationException.

exception for that problem

org.hibernate.LazyInitializationException: could not initialize proxy [com.company.dbservice.model.Image#1004291143] - no Session
     at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:170)
     at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:310)
     at org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor.intercept(ByteBuddyInterceptor.java:45)
     at org.hibernate.proxy.ProxyConfiguration$InterceptorDispatcher.intercept(ProxyConfiguration.java:95)
     at com.company.dbservice.model.Image$HibernateProxy$aWvtUHZY.getContent(Unknown Source)
     at com.company.dbservice.search.resolver.ImageResolver.getImageUrl(ImageResolver.java:50)
     at com.company.dbservice.search.resolver.ImageResolver.getContentImageUrl(ImageResolver.java:34)
     …..
     at com.company.dbservice.aop.ReadOnlyRouteInterceptor.proceed(ReadOnlyRouteInterceptor.java)
     at com.company.dbservice.sqs.reader.MessageHandler.processMessage(MessageHandler.java)
     at com.company.dbservice.sqs.reader.MessageHandler.receiveMessage(MessageHandler.java)

After looking at, it those errors seem to keep happening to object in object in object that were not needed anyway so the unnecessary acces were remove to prevent processing these object. It a solution you might say but this don’t solve the underlying issue.
Here an example of the table surrounding the object.

When I look in new relic the next they I notice that the error were still happening.
This time it was for an object that was needed. After some digging, I found out that the new endpoint for the direct route didn’t have the @Transaction annotation. It was calling the same code to save and process the object the batch part was using though.
For those who don’t know @Transactional tells spring to create a proxy around the object. The proxy intercepts calls to the object from other objects. The proxy does not intercept calls within the object.

So to fixed we had to add @Transactional on the method that is invoked from “outside” and it fixed the problem.

Posted in java | Tagged Exception, hibernate, java, LazyInitializationException | Leave a response

Why does Map.of not allow null keys and values?

By Chris on March 2, 2021

Once upon a time an engineer with years of experience encounter something so basic he doesn’t understand why he didn’t encounter it sooner.

This week we had a strange error in our log stating that should have a null values in a map.

After some digging in the service where that log was found, it seems to be not coming from us…

But why can’t a map have a null values. It’s easy to understand why we can have a null key value but why can’t the value be null?

Well it make sense, why keep an empty record in a key when you could just remove the key and it’s not in the map it means it’s null. That free up the map to make it more efficient.

If you straight up initialize a map with Map.of() and include a null value, it will throw a null pointer exception. However, if you do it with a HashMap it will work fine. You can even have null key that way. Most modern implementation of map won’t allow null in their keys or values.

If you want a better explaination checkout this stackoverflow answer: Why does Map.of not allow null keys and values?

Here the TL;DR:

Allowing null in collections is by now seen as a design error. This has a variety of reasons. A good one is usability, where the most prominent trouble maker is Map::get. If it returns null, it is unclear whether the key is missing or the value was null. Generally speaking, collections that are guaranteed null free are easier to use. Implementation-wise, they also require less special casing, making the code easier to maintain and more performant.

Null elements, keys, and values will be disallowed. (No recently introduced collections have supported nulls.) In addition, prohibiting nulls offers opportunities for a more compact internal representation, faster access, and fewer special cases.

Since HashMap was already out in the wild when this was slowly discovered, it was too late to change it without breaking existing code but most recent implementations of those interfaces (e.g. ConcurrentHashMap) do not allow null anymore and the new collections for the factory methods are no exception.

So disallowing null had some technical reason but it was also done to improve the robustness of the code using the created collections.

Posted in java | Tagged java, java.util.Map, maps, null | Leave a response

Book I’ve read in 2019…

By Chris on February 10, 2021

I know 2019 is like light years away, but I haven’t had the time to write and you will see that I haven’t had much time to read either in 2019. Having a baby who doesn’t sleep will do that to you.

How to be miserable

I got this book after watching CGP Grey’s “7 Ways to Maximize Misery“. I recommend both the video and the book – the video is based on seven of the 40 strategies given in the book.

Excellent reverse psychology to avoid doing the list of actions that will make you miserable. Some of the excerpts had me in tears laughing because I could see what I had been doing without really realizing it. After starting that list I’ve read some part of the book again, I definitely will put that book in my re-read list.

The gift of failure: How the Best Parents Learn to Let Go So Their Children Can Succeed

In our overprotective society, Jessica Lahey warns us that shielding our kids too much from mistakes is not actually helping. We need to let them make their own mistakes in order to learn and be ready later in life. Failure should not be looked at as a negative, but rather a stepping stone to success.

A great book that state the obvious, today kids are so shielded from everything they don’t get to experience what it’s like to live and this might have some dire consequences when they get older and need to leave the nest. It’s helped me worry less about grades (a little less) and everything around them and let them be kids, let them experience the world with their genuine curiosity and thirst for knowledge.

The storm before the storm

From the triumph to the fall of the Roman republic this book goes into the bloody details of what happened during that time.

I was a big fan of Mike Duncan podcast on Roman history and I love how he tells the stories of these Roman citizens. This book is no different, I couldn’t put the book down near the end even though I knew where this was heading and the implication of what would come next.

If you’re a fan of Roman history I highly recommend it. If you want to understand the parallel between that period in history and our current US event you can checkout his interview on Ryan Holiday Daily Stoic podcast.

Posted in book | Tagged 2019, book, How to be miserable, The gift of failure, The storm before the storm | Leave a response

Constructor XXX in enum XXX cannot be applied to given types in mapstruct

By Chris on May 20, 2020

I was having that weird error when I was working with mapstruct, turn out that the default java version for mapstruct is java 6. Since our project was in java 11 I was getting the error “Constructor XXX in enum XXX cannot be applied to given types”.

My starting config was :

        <dependencies>
             <dependency>
                 <groupId>org.mapstruct</groupId>
                 <artifactId>mapstruct</artifactId>
                 <version>${org.mapstruct.version}</version>
             </dependency>
         </dependencies>
         <build>
             <plugins>
                 <plugin>
                     <groupId>org.apache.maven.plugins</groupId>
                     <artifactId>maven-compiler-plugin</artifactId>
                     <version>3.8.0</version>
                     <configuration>
                         <release>${java.version}</release>
                         <source>1.6</source> <!-- or higher, depending on your project -->
                         <target>1.6</target> <!-- or higher, depending on your project -->
                         <annotationProcessorPaths>
                             <path>
                                 <groupId>org.mapstruct</groupId>
                                 <artifactId>mapstruct-processor</artifactId>
                                 <version>${org.mapstruct.version}</version>
                             </path>
                         </annotationProcessorPaths>
                     </configuration>
                 </plugin>
             </plugins>
         </build>

After some research, turn out there a mapstruct version for java 8 and more. You can use the following maven to configure mapstruct for java 8 or higher :

        <dependencies>
             <dependency>
                 <groupId>org.mapstruct</groupId>
                 <!-- use mapstruct-jdk8 for Java 8 or higher --> 
                 <artifactId>mapstruct-jdk8</artifactId> 
                 <version>${org.mapstruct.version}</version>
             </dependency>
         </dependencies>
        <build>
             <plugins>
                 <plugin>
                     <groupId>org.apache.maven.plugins</groupId>
                     <artifactId>maven-compiler-plugin</artifactId>
                     <version>3.8.0</version>
                     <configuration>
                         <release>${java.version}</release>
                          <!-- or higher, depending on your project -->
                         <source>1.11</source> 
                         <target>1.11</target> 
                         <annotationProcessorPaths>
                             <path>
                              <groupId>org.mapstruct</groupId>
                              <artifactId>mapstruct-processor</artifactId>
                              <version>${org.mapstruct.version}</version>
                             </path>
                         </annotationProcessorPaths>
                     </configuration>
                 </plugin>
             </plugins>
         </build>

Let me know if you had that problem and if this helped you.

Posted in error, java | Tagged java, java8, mapstruts, maven | Leave a response

Book Review Autumn 2018

By Chris on January 8, 2019

Perenial Seller:
The Art of Making and Marketing Work that Lasts

I’m subscribed to Ryan Holiday newsletter and read is latest work on stoic philosophy (Obstacle if the way, Ego is the Enemy, Daily stoic) and when he usually get a book out I buy it.
In his book, Perenial Seller, we study on what it takes to create timeless, lasting work. Ignore the trends of the day to focus on what matters and what will lead to real impact.
If you want to write, produce, or build something amazing, read this book.

Principle by Ray Dalio

A big book (600+ page) about one of the great Investor of our time, Ray dalio and is life and work principle.

Ray Dalio is the founder and co-chairman of Bridgewater Associates, which, over the last forty years, has become the largest and best performing hedge fund in the world.
Mr. Dalio let us dive in in this part memoir, part how-to guide and show us what priciple guide is life and business.
My main take away of this book is to pratice radical honesty, which is the ability to open oneself to appreciate pointed criticism and use it to improve and have a sense of humility and introspection.
There 3 main part in the book, is biography to understand where he come from, is life principle and is work principle that he used to build Bridgewater.

Factfulness

I bought this book after seeing Bill Gates recommendation, and my god this book is eye opening. Hans Rosling explains how what we see on the media, our preconceptions and statistical illiteracy make us believe in the wrong worldview. Surprise, surprise, other countries aren’t like they used to be 50 years ago. The book carefully break the 10 most important sources of bias and misconceptions and give ways to avoid them. Forget about the “Developping world”, most countries today would be considered developed. We should categorize the developments in four income level instead and at the end of the book there are examples on what different in the life of a level one vs other level of income. Each countries have average income level that help us determine the problem of the population and the degree of extremes poverty.

Posted in book | Tagged 2018, book | Leave a response

Book review Summer 2018

By Chris on December 22, 2018

No drama discipline

A another parenting book, I’ve read 3 of those in 2017 alone it’s from the same author of the Whole brain child.
Learning to help your child to use their upstairs brain when they are overwhelm in their downstairs brain (emotion). Connect with your child first before trying to do discipline.
See the refrigerator sheet

Da Vinci Code (FR)

By Source, Fair use, Link

Along with the Fiction Book the digital fortress my father gave me a bunch of Dan Brown books. Da Vinci code is probably the most famous of is book and it even been adapted into a Movie. However, I’ve seen the movie age ago when it was out in theater and was surprise how little I remember about it.

I didn’t remember who was the villain, but I did remember the ending and what it was about.

Recession Proof Graduate

Recession proof graduate was a gift from the Play for a living from Kickstarter.

Recent graduates, who have been repeatedly told by elders that long studies entitled them to a good job, are surprised when they realize blindly posting resumes online and hoping a company will hire them does not produce the desired result.

In this book, Charlie describes another way you need to do to land your dream job. And it’s not the advice you will get from your parents, profs, or counsellors.
Charlie mentions that you have to be willing to do free work for people you admire. Because with free work comes low expectations and allow you to get your foot in the door. The book goes into more detail, but with this method, you start building a portfolio, contacts and a reputation.

Even that I’m not a new grad, a lot of principle and strategies he explains in is book can be applied to anyone who wants to have a career or help there business.

Love yourself (59 pages)

Very short self-help book (59 pages) that go to the point. Well the title go to the point, it’s a book about loving yourself and that if you want to help other and be loved by others you should seek your inner love before seeking validation from others. The fact that it’s short make it a great re-read when you’re feeling down or just need a pep-talk.

Posted in book | Tagged 2018, book, Da Vinci Code, Love yourself, No drama discipline, Recession Proof Graduate | Leave a response

How to give a list of value in a where clause in sql (on oracle) ?

By Chris on July 24, 2018

I have a list of guild but I don’t want to call that sql for each guild. (check previous post for the structure)
This one is a little easier, you just have to use the IN (PARAMETER, OPERAND, KEYWORD) instead of equal (=) and you give your list of guild you want in it.

select * where
from USER_TABLE u inner join JOB_ASSIGN assign on u.USER_ID = assign.USER_ID, GUILD_TABLE guild where assign.guildId = guild.id AND assign.guildid = ?

If you want to hand pick the number of guild you can use the KEYWORD IN:
select * where
from USER_TABLE u inner join JOB_ASSIGN assign on u.USER_ID = assign.USER_ID, GUILD_TABLE guild where assign.guildId = guild.id AND assign.guildid IN (12,13,14)

Related : What to do if I want give a list of value in my where clause parameters?

Posted in db | Tagged List, oracle, sql, where | Leave a response

April 2018 Book: Unshakeable

By Chris on April 29, 2018

April was a busy month, I’ve only managed to finish one book. I’ve finished Unsheakable by Tony Robin, a follow-up of is other book Money: Master the game that is shorter and can be read independently.

Unshakeable

A lot of what is said in Money: master the game is re-told in unshakable, it makes me feel that Robin wanted to a shorter book (225 pages vs the 600+ pages for Money: master the game) to reach more people and promote is partnership with Creative Planning which was left out of the other book.

Its start off making you aware of how bad the financial industry is treating you and how to do it on your own or find a good advisor.

First he goes how bad are mutual fund which are outperform by the index most of the time after including the fee you pay (95% of the time according to the book).

He then goes to show how most financial advisor don’t have your interest at heart because they are actually broker and will push product that may give them bigger commission.

Other topic are covered like 401K, how to prepare and take advantage of market correction and bear market, tax efficiency and more.

The last section is about real wealth and how it is emotional, psychological and spiritual. How living a fulfilling life is more important than just success.

This section in my opinion what makes this book and money (it has a similar chapter) stand out compare to most other financial help book out there.

My final take is that if you’re interested to read about your finance this book is a good start, it contains the message of it previous book and is a much lighter read. It will get you started, I found so chapter tedious at the beginning even though he made a good effort of keeping the book interesting.

Posted in book, Review | Tagged 2018, april, book, review, Unshakeable | Leave a response

Books Q1 2018: Sapien, Digital Fortress, Essentialism & Ready Player One

By Chris on April 9, 2018

It’s been three month, so I decided to give a little update on the book of 2018, this is a follow up of my list of book of 2017.

Sapien

Recommended by Bill Gate and many podcast I’ve listened too, Sapien is a brief (a synopsis if you wish) of the history of mankind.
He deconstruct different revolution that the Sapien had and he touch on the drawback of the Sapien expansion. From pre-historic time where the Sapien clashed with the neanderthal, where they drove extinct the mega-fauna of every ecological system they entered, to modern time.
I really liked that he approached some lesser know fact, like that hunter gathered had it better in term of life expectancy, quality of life, health that human in the agricultural revolution.
I love those kinds of read even though it’s a long one.

Digital Fortress

My father is a big Dan Brown fan and lend me some of is book, I started with this one because it seems more in my line of work (computer, cryptography) than the others (The Da Vinci Code & other).
Writen in 1998, what caught my attention was some of event in the book happens recently.
One of the plot point of the book is that a character will release an undecryptable algorithm to the world if the NSA don’t reveal that they have a super computer that read everybody mail and can decrypt all of the current cryptographic algorithm.
Sound like what Snowden did, letting know that the NSA was spying on their own citizen and their allied.

Note to self: I should write a goodread review on this one.
https://www.goodreads.com/book/show/11125.Digital_Fortress

Essentialism

I’ve bought the book from Charlie Hoehn recommendation. When I’ve backed his kickstarter project and he gave the backers the opportunity to tell him what they were struggling with and try to give them advice.
so here my mail

Hi Charlie,

I think my biggest problem right now is not being afraid to say no.
I say yes to everything I’m mildly interested and then I can’t keep up, it’s especialy hard saying no to my spouse and my kids.

Thanks and I can’t wait to get my copy of the book,
Chris

Is respond was swift and short: Buy the book Essentialism and keep reading it.
After reading it, I understand why he said that, the second I’ve finished the book I had to read it again.

What is it about?
It’s about focusing on your priorities instead of letting yourself get sidetracked by the bombardment of secondary demands dictating our everyday lives.
The secret is to concentrate your efforts on your immediate task and prevent others to distract you away from the job at hand.
The author states in so many words that if you don’t make the choice, others will make it for you and that someone else’s choice may mean as an example that you won’t get that report in on time.

Ready player one

A good friend of mine recommended this book last year, I already bought it, but didn’t get around reading it. With the movie adaptation coming out this Easter, I had to read it. In the year 2045, global oil reserve are depleted and for the many the only way to escape this harsh world is to dive in the OASIS, a virtual reality/MMO where you can play, go to school, conduct business, etc.
The creator of the OASIS, just died recently and added a easter egg in it that will give control to the OASIS.
We follow the story of the young Wade, trying to find that legendary artifact along with some friend against an evil global corporation.
If you’re a child of the 80s-90s or into video game in general you will love this one. It’s full of reference to both, pop culture and many more easter egg.

Have any of you read these book, let me know what you liked/disliked about them or learned any special.

Posted in book, inspiration, Review | Tagged 2018, book, Digital Fortress, Essentialism, List, Ready Player One, reviews, Sapien | Leave a response

How to turn a list from a select into a column of another select (Oracle) ?

By Chris on April 2, 2018

A old process we had was fetching a list from a query for each player one by one, and adding it in a excel file with other data needed on the player.

Seeing that process was slow, we decided to turn it into a query.

If we take a close look at the model we have 4 tables, 3 that will be used in the query.

The player table (PLAYER_TABLE), the guild table (GUILD_TABLE), a job table (JOB_TABLE) and a table to link the 3 tables together call job assignation (JOB_ASSIGN).

(note this is a simple representation, the original had around 30+ fields for each of the equivalent of the player and guild table)

What we want is to display all the info of the player and all the job the player have for each guild in one row.

So one row will look like

user_id	server	classname	lv	job list
543123	1	ROGUE	23	diplomat, carpenter, florist
34533	1	MAGE	66	alchemist, diplomat
234334	2	MAGE	34	alchemist, ring maker
776565	3	WARRIOR	5	brewer

All the job are in varchar so what we need it’s to put them in a string separated with a comma instead of having a row for each of them.

Selecting a value from another select

This is a start but the value is a string we need to make a select of the job table and get the list.

this would work for the total of job for the player.

but first we need to know how to select in a select (sql select in a select)

From Stackoverflow example:

SELECT  TypesAndBread.Type, TypesAndBread.TBName,
        (
        SELECT  Count(Sandwiches.[SandwichID]) As SandwichCount
        FROM    Sandwiches
        WHERE   (Type = 'Sandwich Type' AND Sandwiches.Type = TypesAndBread.TBName)
                OR (Type = 'Bread' AND Sandwiches.Bread = TypesAndBread.TBName)
        ) As SandwichCount
FROM    TypesAndBread

This work fine if the select return only on value per entry (player) if there multiple entry and we want to put them in a single line we need something else.

Displaying a list of result (varchar) on a single line.

If we want to display a series of string (varchar) together we need to concatenate them together.

We could try to do something with the concat method, but since Oracle 11g R2 there a another method to concatenate a sql result into a string oracle with a delimiter called LISTAGG.

SELECT job.JOB_ASSIGN_ID,

   LISTAGG( job.JOB_NAME, ',') WITHIN GROUP (ORDER BY job.JOB_ASSIGN_ID)

from JOB_TABLE job  

GROUP BY job.JOB_ASSIGN_ID;

Note: db exception on GROUP BY if your select have more than one row for job.JOB_ASSIGN_ID.

Then you can add this select has a column on the previous select where we calculated the number of job.

select u.USER_ID, u.SERVER, u.CLASSNAME, u.LV, 

(SELECT LISTAGG( job.JOB_NAME, ',') WITHIN GROUP (ORDER BY  assign.USER_ID) As userJobList

from JOB_TABLE job join JOB_ASSIGN assign on job.JOB_ASSIGN_ID = assign.JOB_ASSIGN_ID

where assign.USER_ID= u.USER_ID

GROUP BY assign.USER_ID) As userJobList 

from USER_TABLE u inner join JOB_ASSIGN assign on u.USER_ID = assign.USER_ID where assign.guildid = 12 

Note that you can put compare on column inside the inner select, that how I've separated the value per user.

Posted in db | Tagged batch, listagg, oracle, sql | Leave a response

Some Trials & a lot of Errors

I tried a bunch of framework and other language and I usually feel overwhelm when its time to do something real with what I've learned. So that why I created this site, to write my progress and help some noob like me that stumble into the sames problems.

Solving LazyInitializationException with sonar rules @Transactional method called from another method doesn’t obtain a transaction

Why does Map.of not allow null keys and values?

Book I’ve read in 2019…

How to be miserable

The gift of failure: How the Best Parents Learn to Let Go So Their Children Can Succeed

The storm before the storm

Constructor XXX in enum XXX cannot be applied to given types in mapstruct

Book Review Autumn 2018

Perenial Seller:
The Art of Making and Marketing Work that Lasts

Principle by Ray Dalio

Factfulness

Book review Summer 2018

No drama discipline

Da Vinci Code (FR)

Recession Proof Graduate

Love yourself (59 pages)

How to give a list of value in a where clause in sql (on oracle) ?

April 2018 Book: Unshakeable

Unshakeable

Books Q1 2018: Sapien, Digital Fortress, Essentialism & Ready Player One

Sapien

Digital Fortress

Essentialism

Ready player one

How to turn a list from a select into a column of another select (Oracle) ?

Tags

Recent Comments

Calendar

Archives

May 2021
Mon	Tue	Wed	Thu	Fri	Sat	Sun
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31

I tried a bunch of framework and other language and I usually feel overwhelm when its time to do something real with what I've learned. So that why I created this site, to write my progress and help some noob like me that stumble into the sames problems.

How to be miserable

The gift of failure: How the Best Parents Learn to Let Go So Their Children Can Succeed

The storm before the storm

Perenial Seller: The Art of Making and Marketing Work that Lasts

Principle by Ray Dalio

Factfulness

No drama discipline

Da Vinci Code (FR)

Recession Proof Graduate

Love yourself (59 pages)

Unshakeable

Tags

Recent Comments

Calendar

Archives

Perenial Seller:
The Art of Making and Marketing Work that Lasts