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 […]
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 […]
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 […]
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 […]
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 […]
If you happen to rename your folder that contain your jsp and js, don’t forget to update the struts config (and the tiles). This will save your precious time even hours …
For some reason Oracle have no Boolean Since there is no BOOLEAN datatype in Oracle, as far as tables are concerned. CREATE TABLE BooleanTable (MyBool BOOLEAN); return : ORA-00902: invalid datatype But there is a BOOLEAN datatype in PL/SQL. What should we do instead? According to Tom at ThinkOracle you could create the table using […]
How to fix: ERROR – jmeter.save.SaveService: Conversion error com.thoughtworks.xstream.converters.ConversionException
When you are handling string you sometime have single quote in your string. I was looking on how to handle that in Oracle and it’s not pretty but you can cover that case with the chr(39) function, 39 being the code for the single quote. So it you are looking the “it’s” you have to […]
I had in the past had to work with oracle and had to convert it to mysql. Unfortunately (or fortunately) that project was cancel but here are the bit of information I’ve found that I didn’t know about and made me lost a lot of time. Oracle vs mySQL datatype edition From mySQL […]
Recent Comments