Java

SqlXMLReader.java

/*
* SqlXMLReader.java
*
* Created on April 29, 2007, 12:07 PM
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.arpu.opencds.datatransformation;

import java.io.*;
import java.net.URL;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import org.xml.sax.*;
import org.xml.sax.helpers.*;

/** A utility class that parses a Result Set Value
* and outputs its contents using SAX2 events.
* For simple values, the SQL Result Set file may look like this:
*

SqlInputSource.java

/*
* SqlInputSource.java
*
* Created on April 29, 2007, 5:24 PM
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.arpu.opencds.datatransformation;

import java.sql.ResultSet;
import org.xml.sax.InputSource;

/**
* a class that extends InputSource.
* The intent of this class is to just holds a copy of the ResultSet object
* for the XML reader to use it.
* @author aabdelaziz
* http://www.aliabdelaziz.org/
*/
public class SqlInputSource extends InputSource {

/**

AbstractXMLReader.java

/*
* AbstractXMLReader.java
*
* Created on April 29, 2007, 12:20 PM
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.arpu.opencds.datatransformation;

/**
*
* @author aabdelaziz
* http://www.aliabdelaziz.com/
*/
import java.io.IOException;
import java.util.*;
import org.xml.sax.*;

/**
* An abstract class that implements the SAX2 XMLReader interface. The
* intent of this class is to make it easy for subclasses to act as
* SAX2 XMLReader implementations. This makes it possible, for example, for

Converting your old CMS database to XML format that can be imported into OpenCDS.

As we are currently working on migration from my company old CMS to OpenCDS so I have to migrate the old data from the old CMS database (MSSQL Server) to OpenCDS database (Oracle) and offcourse the two ERDs are completely different.
So the solution that I follow is to export the data from my old CMS to XML files then use XML_Submission to insert this data into OpenCDS and this will guarantee that the relation for each piece of content is created correctly.

I will discuess in this Article how to export the data from your old CMS database to XML files with format that can be imported into OpenCDS.

OpenCDS Devices profiles transformation

I have used XSLT as a transformation engine to transform the Devices profiles from the manufacture form to the OpenCDS form.

Handsets Profiles Links:

A few Notes on the Following XSLT:

Java Developers Conference 2007 - [NetBeans Session (ONE HAND NEtBeans DEMO) ]

In The Last Saturday [20 of January 2007] the first Java Developers Conference (JDC) was held in Egypt.
On thing worth to mention it was the first time for me to attend Session, Seminar, Or Conferencec at -4 Floor, yes the conference was held in Cairo at Saraya Hall in Intercontinental City Stars Cairo - which at -4 floor.
it was one of the the best days in the life of any Java Geek, as there was a good Collections of Java Sessions, I will speak in this post about NetBeans Session as it was the most Exciting Session at least for me, But I'm sure that others will share the same opinion with me at least the guys who got NETBEANS 5.5 T-Shirts ;).

Taking backups should represent 10% of doing CONTROLE + S .

Thanx God, Thanx God.
After I finished the development of mifos Holiday module my Supervisore Karim asked me to list the files I added (java, xml, properties, sql) and what changes I did on existing files(java, xml, properties, sql).

Java Developer Conference

Welcome to Java Developer Conference

For the first time in Egypt, the Egyptian Software Engineers Association (ESEA) together with the Egyptian Java Users Group (EGJUG) are jointly organizing the Java Developer Conference JDC in Cairo. JDC will be held at the Saraya Hall in InterContinental Citystars Cairo on the 20th of January 2007.

Expert Speakers

Raghu kodali(ORACLE)

Roman Stroble (SUN)

Chuk Munn Lee (SUN)

Rob Harwood (JET-BRAINS)

Reverse engineer DataBase (episode 2) Generating Class Diagram Image from XMI.

in my last article (Reverse engineer DataBase to XMI.)

I wrote how to reverse  engineer DataBase and produce XMI file from the data base using andromda Schema2xmi plug-in.

in this article I will speak about how to produce PNG (Portable Network Graphics) Image or any other type of Image that produces the Class Diagram representation from the XMI file that we produced earlier from our Data Base.

ok lets start.

Reverse engineer DataBase to XMI.

In this article I will try to reverse engineer a postgres data base and I think any other database will be the same with small modifications in the config and properties files.

ok lets start.

I will use andromda:schema2xmi plugin to achieve this task.

Prerequisites:

Powered by Drupal - Design by artinet