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> […]
Posted in error, java | Tagged java, java8, mapstruts, maven |
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 […]
Posted in db | Tagged List, oracle, sql, where |
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 […]
Posted in db | Tagged batch, listagg, oracle, sql |
By Chris on October 19, 2014
My coworker was moving files around in our SVN repo and we end up losing the history of the file. It seem it was because of our IDE (eclipse svn at the time), after some searching we manage to find a way to do it by using the svn command rename & move. Doing everything […]
Posted in prog | Tagged source control, svn |
By Chris on October 12, 2014
While trying to remove a element after creating a List from a array using the Array.asList(array[]) method I’ve stumbled on that error. java.lang.UnsupportedOperationException at java.util.AbstractList.add(AbstractList.java:131) at java.util.AbstractList.add(AbstractList.java:91) Then I remember this, list created by the Arrays.asList method are immutable Same goes for empty lists. So instead create a arraylist : List<String> list = new ArrayList<String>(Arrays.asList(split));
Posted in java, prog | Tagged arraylist, java, java.util.List |
By Chris on October 5, 2014
Our build server (jenkins) had that error BUILD FAILED com.jcraft.jsch.JSchException: java.net.NoRouteToHostException: No route to host Full stack trace below if you really need it. I assume there was a problem with where Jenkins was deploying the apps or at a issue trying to run integration test on the remote server. After talking to IT […]
Posted in prog | Tagged build server, java, jenkins |
By Chris on September 28, 2014
Comparing and sorting Strings might not work out like you expected specially when your dealing with a language other than English. Normally comparing strings in done with simple Unicode ordering. If you want to have localized ordering (the kind expected by an end user) you need to use a Collator. Commonly used String methods such […]
Posted in java, prog | Tagged collator, java, sorting, String |
By Chris on September 20, 2014
My god sometime I bang my head on the wall to do something simple on oracle. So oracle don’t support limit so to do something simple has : SELECT f_name, l_name, age from employee_data ORDER BY age DESC LIMIT 20 become : SELECT f_name, l_name, age FROM ( SELECT f_name, l_name, age, ROWNUM r FROM […]
Posted in db, prog | Tagged limit, oracle, sql |
By Chris on September 13, 2014
I was trying to update a table that using sql join but I kept getting ORA-00933 I tried the following: Using A SQL JOIN In A SQL UPDATE Statement Using A SQL JOIN In A SQL UPDATE Statement (www.bennadel.com) update table using inner join (venushuynh.wordpress.com) but I kept getting the ORA-00933 then tried this Oracle […]
Posted in db | Tagged db, error, oracle |
By Chris on September 7, 2014
Another problem I’ve it recently with saveOrUpdate that can be fix by using the same saveOrUpdate but give the class name. Using the session.saveOrUpdate(myObject) might give you a unknown entity while using the same method with the class name in parameter won’t. session.saveOrUpdate(myObject); //give a unknown entity session.saveOrUpdate(“MyObjectClassName”, MyObject); //Work The important difference between the […]
Posted in db, prog | Tagged db, hibernate |
Recent Comments