Outils | Entreprise | Compte-rendus | Humeurs |   

8 août 2009

SQLPlus Remote Launcher

When we are developping some features, we sometimes need to modify a bunch of tables or stored procedure in the database. Once this is done in our development environment, we sometimes forgot to run it on all the other environments (except the production one of course).

That's why I developped SQLPlus Remote Launcher for Oracle / Windows.

Sql_plus_remote_launcher allows you to run a bunch of SQL Oracle scripts in several databases without opening a session for each of them with toad. The instances are committed in a SVN so we won't forget any of them.

More details here

31 juillet 2009

Eclipse plugins for java

My favorite plugins for Eclipse : M2Eclipse for maven, Spring IDE, Subclipse for Subversion, Jadclipse to decompile classes, Java source helper and Properties Editor.


My very short list


M2Eclipse for maven

Resolves the project dependencies with maven, displays the tree of dependencies (why X.jar is returned), makes it easy to add a dependency to the pom by parsing the repository... Also provides a decoration label to display the current version of a project.

http://m2eclipse.sonatype.org/update/

Spring IDE

Autocompletion for classes, properties name and validation.

http://dist.springframework.org/release/IDE

Subclipse for subversion

Subversion options with a synchronizing feature as a bonus : it prevents unfortunate commits to be done. Also "override and update" is useful.

http://subclipse.tigris.org/update_1.6.x or http://subclipse.tigris.org/servlets/ProjectProcess?pageID=p4wYuA

Jadclipse for jad

Opens .class files with jad instead of the annoying "no source found".

http://jadclipse.sf.net/update

Jora for Oracle

Avoids having a greedy Toad opened and provides much better and quicker auto completion (tables, fields). It has less features than toad but it is enough for my use and make the features accessible more easily (SQL History, oracle functions).

http://jora.luenasoft.de/updatesite or http://jora.luenasoft.de

More Unit

Decorates classes that have tests and make you switch from the class to its test in one shortcut (Ctrl+J). I just wish there were also a shortcut to run the test even when we are on the tested class.

http://moreunit.sourceforge.net/org.moreunit.updatesite or http://moreunit.sourceforge.net/

Lire la suite...

25 février 2009

Oracle Administration cheat sheet (part 1)

Nous en avions mangé de l'Oracle à la Miage de Créteil... Voilà que ce que j'y ai appris me sert enfin dans la vie réelle. Résultat : j'ai ressorti une fiche que j'avais faite en maitrise, sur l'administration oracle. Je mettrai celle sur les clusters et l'index quand (si...) je la retrouverai.

Vues

  • INSERT : on peut insérer dans la table des tuples que la vue ne voit pas.
  • DELETE, UPDATE sur vue : marche pas
    • si le tuple n'est pas visible car sont précédés implicitement d'un SELECT. On peut pas effacer/modifier une ligne qu'on voit pas (0 résultat).
    • si vue batie sur plusieurs tables

Lire la suite...