Guroot

Find and Replace with sed

guroot — Fri, 30 Oct 2009 22:59:04 +0000

A lot of us will have to support code made by newbies or unconscientioius coders. Lately, I had to change the password of a database.
Unfortunately, this pass was hardcoded in a lot of php files.

Nothing’s perfect.

Hopefully, it’s easy to do a find and replace under Linux or Cygwin (or wathever) with sed.

$ find /your/directory/ -type f -exec sed -i 's/old_password/new_password/g' {} \;

This tips can be very usefull.

JDAPI, java library to work on Oracle Forms (. FMB)

guroot — Fri, 27 Feb 2009 00:22:31 +0000

Here is a simple package that I made in Java to proceed to a “search and replace” in the blocks of FMB files. Warning, the following code modifies all FMBs in the specified directory. I give you the JAR file and the code. It’s very useful when needed.

It come with absolutly NO WARRANTY .. be careful. I am not responsible if it causes problems with your files. It may be used for personnal and commercial purpose.. and bla bla bla …

findAndReplace.jar

Have been tested under Micro$soft Windows only.
You must have Java 1.6.0_12 or later and frmjdapi.jar have to be in the “CLASSPATH”.

You can run it the following way :

java -jar findAndReplace.jar c:\fmb\  old_word new_word

 
package findandreplace;
 
/**
 *
 * @author guroot
 * http://www.guroot.com
 */
 
import oracle.forms.jdapi.*;
import java.io.*;
 
class FmbFilter implements FilenameFilter {
    public boolean accept(File dir, String name) {
        return (name.endsWith(".fmb"));
    }
}
 
public class Main {
 
    /**
     * @param args the command line arguments
     */
 
 
 
 
    public static void main(String[] args) {
        // TODO code application logic here
    FormModule fmb;
    String plsql;
    FilenameFilter filter = new FmbFilter();
    File dir = new File(args[0]);
    String[] list = dir.list(filter);
 
    for(int i = 0; i< list.length;i++)
    {
     System.out.print(list[i]);
     fmb = FormModule.open(args[0]+"\\"+list[i]);
     JdapiIterator blocks = fmb.getBlocks();
 
    while(blocks.hasNext()) {
      Block block = (Block)blocks.next();
      // Triggers
      JdapiIterator triggers = block.getTriggers();
        while(triggers.hasNext())
        {
            Trigger trigger = (Trigger)triggers.next();
            plsql = trigger.getTriggerText();
            plsql = plsql.replace(args[1], args[2]);
            trigger.setTriggerText(plsql);
        }
    }
        fmb.destroy();
    } // end for
    }
 
}

Impress your friends with DBMS_XMLDOM

guroot — Fri, 09 Jan 2009 04:11:14 +0000

Oracle has a very interesting package to deal with the XML: DBMS_XMLDOM

I am still not very familiar with this package but with it, I loaded an XML file (multi-level structured) directly into a table. I have not tested on a large volume of data but I think it would be efficient.

I did my tests on an Oracle 9.2.0.4.0 under a CentOS Linux

Here is a very rudimentary procedure :

First, an XML file for the example :

< ?xml version="1.0" standalone="no"?>
>
 lastname="Smith">
 memberid="m1">Sarah>
 memberid="m2">Bob>
 memberid="m3" mom="m1" dad="m2">Joanne>
 memberid="m4" mom="m1" dad="m2">Jim>
>
 lastname="Dupont">
 memberid="m1">Jean>
 memberid="m2">Robert>
 memberid="m3" mom="m1" dad="m2">John>
 memberid="m4" mom="m1" dad="m2">Gary>
>
>

Then, I created a table in the database :

CREATE TABLE personnes
(NOM VARCHAR2(60),
Prenom VARCHAR2(60));

And now, the entire procedured I used to load the data :

CREATE OR REPLACE PROCEDURE chargementXML(dir VARCHAR2, inpfile VARCHAR2,
                                      errfile VARCHAR2) IS
p xmlparser.parser;
doc xmldom.DOMDocument;
 
PROCEDURE insertElements(doc xmldom.DOMDocument) IS
nl xmldom.DOMNodeList;
len NUMBER;
n xmldom.DOMNode;
nnm xmldom.DOMNamedNodeMap;
family VARCHAR2(60);
myElement xmldom.DOMElement;
nodeValue VARCHAR2(60);
 
BEGIN
-- get all elements
nl := xmldom.getElementsByTagName(doc, '*');
 len := xmldom.getLength(nl);
  -- loop through elements
FOR i IN 0..len-1 LOOP
     n := xmldom.item(nl, i);
 
	IF UPPER(xmldom.getNodeName(n))= 'FAMILY' THEN
	myElement := xmldom.makeElement(n);
        family := xmldom.getAttribute(myElement ,'lastname');
	END IF;
      -- get the text node associated with the element node
	 n := xmldom.getFirstChild(n);
     IF xmldom.getNodeType(n) = xmldom.TEXT_NODE THEN
      nodeValue := xmldom.getNodeValue(n);
      INSERT INTO personnes VALUES (family,nodeValue);
      END IF;
   END LOOP;
END insertElements;
 
BEGIN
 
   p := xmlparser.newParser;
 
--  Paramètrages
   xmlparser.setValidationMode(p, FALSE);
   xmlparser.setErrorLog(p, dir || '/' || errfile);
   xmlparser.setBaseDir(p, dir);
 
-- Fichier source
   xmlparser.parse(p, dir || '/' || inpfile);
 
-- Document
   doc := xmlparser.getDocument(p);
 
-- Insertions des elements
   insertElements(doc);
 
END chargementXML;
/

This is the new contents of the table :

SQL> SELECT * FROM personnes;
 
NOM
------------------------------------------------------------
PRENOM
------------------------------------------------------------
Smith
Sarah
 
Smith
Bob
 
Smith
Joanne
 
NOM
------------------------------------------------------------
PRENOM
------------------------------------------------------------
Smith
Jim
 
Dupont
Jean
 
Dupont
Robert
 
NOM
------------------------------------------------------------
PRENOM
------------------------------------------------------------
Dupont
John
 
Dupont
Gary
 
8 rows selected.

With the documentation on oracle.com :http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_xmldo5.htm#1024279 , I’m sure that it’s possible to do fabulous things

Guroot.com now available in english

guroot — Fri, 02 Jan 2009 16:24:58 +0000

Guroot.com is now available in english. Some section are still only available in french but soon, more will be traduced. Excuse my english, I’m French-Canadian and I’m learning.

C# : How to call dynamically a generic method

guroot — Wed, 29 Oct 2008 16:53:54 +0000

Recently, I encountered a problem in C#. I had to invoke a generic method but didn’t know which object would be in entry because I was going to seek it through reflection.

So, I have a method that could be called, for example:

 public bool MyMethod<T>(T x, Tx)

I want to call it but I do not know what is T. T may be several different things depending on the rest of the code. I cannot affect T with anythings. The compiler will not accept, for example:

 bool resultat = MyMethod<this.getType()>(x,y)

After some research on google, I changed the code snippets that I found and it gave me this:

    private object invokeGenericMethod(string typeName,string methodName,object[] parameters)
        {
 
            Type type = System.Type.GetType(typeName);
 
            MethodInfo method = this.GetType().GetMethod(methodName,
                BindingFlags.Public | BindingFlags.Instance);
 
            MethodInfo genericMethod = method.MakeGenericMethod(type);
            return genericMethod.Invoke(this, parameters);
 
        }

So, to invoke dynamically, I can now have something like:

object[] invokeArgs = { "parameter1","parameter2","etc" };
object result = InvokeGenericMethod(this.GetType().Name, "MyMethod", invokeArgs);

I use the first parameter of InvokeGenericMethod to pass the type of class. So the code will always be adapted from the class from which it is called.

HowTo : Install Oracle 11g under CentOS release 5.2

guroot — Thu, 23 Oct 2008 00:57:09 +0000

// This is a copy of the post “Installing Oracle 11g on Fedora 8″ (in french only for the moment)

// Unless he has some changes for

// CentOS 5.2

CentOS is a Linux distribution that I have discovered only recently. It is, in short, an independent project that downloads the sources Redhat, withdraw all references to Redhat, to compile and distribute them free of charge. This gives us a distribution around nearest of Redhat than even Fedora. Very useful for testing Oracle DB on a free platform. It remains a distribution that is not officially supported.

First, I want to say that you should not install Oracle 11g under CentOS except in educational and testing purposes. Oracle is very explicit in its documentation : It should not be installed under a Linux platforms non-supported.

That being said, I will briefly describe my 11g installation in a machine under CentOS x86..:)

First step, download from otn.oracle.com and and move it on the machine CentOS. Then read the installation documentation from the same site (look for the “minimum requierement”) and proceed as follows:

1 – Check for packages required:

Here is a command so you will not have to retype everything. Just copy and paste.

rpm -q binutils
compat-libstdc++-33
elfutils-libelf
elfutils-libelf-devel
glibc
glibc-common
glibc-devel
glibc-headers
gcc
gcc-c++
libaio
libaio-devel
libgcc
libstdc++
libstdc++-devel
make
sysstat
unixODBC
unixODBC-devel

If some packages are missing, it is very easy to add them with the Package Manager of CentOS. Call it whith this command:

pirut &

Also, it is possible to use yum which I think is faster to use.

3 – Create groups and users needed.

# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -g oinstall -G dba oracle

4 – Modify system settings

Add in /etc/ sysctl.conf

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Then proceed with the following command so the
system will make effective the change in /etc/sysctl.conf

/sbin/sysctl -p

Add the following lines in /etc/security/limits.conf file:

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Add the following lines in /etc/pam.d/login file

 /lib/security/pam_limits.so
session required pam_limits.so

Add the following lines in . Bash_profile for Oracle User

(/home/oracle/.bash_profile) :
ulimit -u 16384 -n 65536
umask 022

5 – Start Installation

In the directory where you unpack unzip with Oracle, run Oracle as a user (su – oracle):

You may need to provide access to the X environment to your users.

For lazy in test environment (so it does not care about security):

As root :

xhost+

as oracle user :

Display=localhost:0
./runInstaller &

An error is possible as follows:

xhost : unable to open Display

It is easily corrected by adding (or modifying) the folowing line ot the file :
/etc/gdm/custom.conf

[Security]
<span style="font-family: Lucida Grande;">DisallowTCP=falsespan>

Then reboot Gnome

/usr/sbin/gdm-restart

It is also possible that this error occurs:

java: xcb_xlib.c:50: xcb_xlib_unlock: Assertion `c->xlib.lock' failed.

And that does not install …

This is a bug with the package libxcb

An upgrade of it and the problem should be a thing of the past.

yum install libxcp

You can uncheck the creation of the Starter Database and create a database later with the method of choice (I did).

the install continue …

Normally, all the prerequisites should be managed successfully. If this is not the case, proceed with the appropriate correction.

The following error may occur :

# An unexpected error has been detected by HotSpot Virtual Machine:

# SIGSEGV (0xb) at pc=0xb7e8ad93, pid=13731, tid=3085035200

# Java VM: Java HotSpot(TM) Client VM (1.5.0_11-b03 mixed mode)

# Problematic frame:

# C [libc.so.6+0x6ad93] index+0×63

# An error report file with more information is saved as hs_err_pid13731.log

# If you would like to submit a bug report, please visit:

# http://java.sun.com/webapps/bugreport/crash.jsp

You just have to change the hostname of you server from localhost to anything. Modifiy it in /etc/hosts, /etc/sysconfig/network and use the command hostname . Click Retry in the Oracle Installer and it should be ok.

Finally, the Oracle Installer will ask to execute to script as root and the installation will finish.