|

»

»

Apache Ode User

Database scripts

View: New views

8 Messages — Rating Filter: Alert me

	Database scripts by Heiko Braun-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message I am looking for the DB scripts to initialize the table structure on any other DB then derby. We are using the 1.x branch of ODE and the 1.3.3 release scripts don't seem to work (at least on mysql). Also, do JPA and Hibernate require different schemas? If so, what should the scripts in the distribution be used for? Can anyone point in the right direction? Thanks a lot, Heiko
	Re: Database scripts by Milinda Pathirage :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi Helko, After building ODE 1.x you will find hibernate SQL scripts at ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at ODE_ROOT/dao-jpa-ojpa-derby/target directory. Thanks Milinda On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <hbraun@...> wrote: > > I am looking for the DB scripts to initialize the table structure on any > other DB then derby. > We are using the 1.x branch of ODE and the 1.3.3 release scripts don't seem > to work (at least on mysql). > > Also, do JPA and Hibernate require different schemas? > If so, what should the scripts in the distribution be used for? > > Can anyone point in the right direction? > > > Thanks a lot, > Heiko > -- Milinda Pathirage Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps WSO2 Inc.; http://wso2.com E-mail: milinda@..., milinda.pathirage@... Web: http://mpathirage.com Blog: http://blog.mpathirage.com
	Re: Database scripts by Jeff Yu :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message It seems the mysql db script still doesn't work well, below is what I got when i am trying to run it. (my mysql version is 5.0.84) [sql] Failed to execute: create table LARGE_DATA (ID bigint not null auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK integer not null, primary key (ID)) [sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2G), INSERT_TIME datetime, MLOCK integer not null, primary key (ID))' at line 1 I am testing against 1.x trunk. Seems this issue was existed for a long time?? (http://mmondora.mondora.com/2009/01/apache-ode-jboss-and-mysql.html) Regards Jeff On Wed, Oct 14, 2009 at 1:16 AM, Milinda Pathirage < milinda.pathirage@...> wrote: > Hi Helko, > > After building ODE 1.x you will find hibernate SQL scripts at > ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at > ODE_ROOT/dao-jpa-ojpa-derby/target directory. > > Thanks > Milinda > > On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <hbraun@...> wrote: > > > > > I am looking for the DB scripts to initialize the table structure on any > > other DB then derby. > > We are using the 1.x branch of ODE and the 1.3.3 release scripts don't > seem > > to work (at least on mysql). > > > > Also, do JPA and Hibernate require different schemas? > > If so, what should the scripts in the distribution be used for? > > > > Can anyone point in the right direction? > > > > > > Thanks a lot, > > Heiko > > > > > > -- > Milinda Pathirage > Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps > WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com > E-mail: milinda@..., milinda.pathirage@... > Web: http://mpathirage.com > Blog: http://blog.mpathirage.com > -- Cheers, Jeff Yu ---------------- blog: http://jeff.familyyu.net
	Re: Database scripts by Jeff Yu :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message simply update the blob(2G) to blob will work for mysql case, but I found the postgres.sql doesn't work either. [sql] Failed to execute: CREATE TABLE ode_job ( jobid CHAR(64) NOT NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), scheduled int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, details blob, PRIMARY KEY(jobid)) [sql] org.postgresql.util.PSQLException: ERROR: type "blob" does not exist Regards Jeff On Fri, Oct 30, 2009 at 12:16 PM, Jeff Yu <jeff.yuchang@...> wrote: > It seems the mysql db script still doesn't work well, below is what I got > when i am trying to run it. (my mysql version is 5.0.84) > > [sql] Failed to execute: create table LARGE_DATA (ID bigint not null > auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK integer not > null, primary key (ID)) > [sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have > an error in your SQL syntax; check the manual that corresponds to your MySQL > server version for the right syntax to use near '2G), INSERT_TIME datetime, > MLOCK integer not null, primary key (ID))' at line 1 > > I am testing against 1.x trunk. Seems this issue was existed for a long > time?? ( > http://mmondora.mondora.com/2009/01/apache-ode-jboss-and-mysql.html) > > Regards > Jeff > > > On Wed, Oct 14, 2009 at 1:16 AM, Milinda Pathirage < > milinda.pathirage@...> wrote: > >> Hi Helko, >> >> After building ODE 1.x you will find hibernate SQL scripts at >> ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at >> ODE_ROOT/dao-jpa-ojpa-derby/target directory. >> >> Thanks >> Milinda >> >> On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <hbraun@...> wrote: >> >> > >> > I am looking for the DB scripts to initialize the table structure on >> any >> > other DB then derby. >> > We are using the 1.x branch of ODE and the 1.3.3 release scripts don't >> seem >> > to work (at least on mysql). >> > >> > Also, do JPA and Hibernate require different schemas? >> > If so, what should the scripts in the distribution be used for? >> > >> > Can anyone point in the right direction? >> > >> > >> > Thanks a lot, >> > Heiko >> > >> >> >> >> -- >> Milinda Pathirage >> Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps >> WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com >> E-mail: milinda@..., milinda.pathirage@... >> Web: http://mpathirage.com >> Blog: http://blog.mpathirage.com >> > > > > -- > Cheers, > Jeff Yu > > ---------------- > blog: http://jeff.familyyu.net > > -- Cheers, Jeff Yu ---------------- blog: http://jeff.familyyu.net twitter: http://www.twitter.com/jeffyuchang
	Re: Database scripts by Jeff Yu :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Update the blob into bytea for postgres.sql will fix this issue. I am wondering how do we generate these db scripts? by using Hibernate built-in tool? Regards Jeff On Fri, Oct 30, 2009 at 12:49 PM, Jeff Yu <jeff.yuchang@...> wrote: > simply update the blob(2G) to blob will work for mysql case, but I found > the postgres.sql doesn't work either. > > [sql] Failed to execute: CREATE TABLE ode_job ( jobid CHAR(64) NOT > NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), scheduled > int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, details blob, > PRIMARY KEY(jobid)) > [sql] org.postgresql.util.PSQLException: ERROR: type "blob" does not > exist > > Regards > Jeff > > > On Fri, Oct 30, 2009 at 12:16 PM, Jeff Yu <jeff.yuchang@...> wrote: > >> It seems the mysql db script still doesn't work well, below is what I got >> when i am trying to run it. (my mysql version is 5.0.84) >> >> [sql] Failed to execute: create table LARGE_DATA (ID bigint not >> null auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK integer >> not null, primary key (ID)) >> [sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have >> an error in your SQL syntax; check the manual that corresponds to your MySQL >> server version for the right syntax to use near '2G), INSERT_TIME datetime, >> MLOCK integer not null, primary key (ID))' at line 1 >> >> I am testing against 1.x trunk. Seems this issue was existed for a long >> time?? ( >> http://mmondora.mondora.com/2009/01/apache-ode-jboss-and-mysql.html) >> >> Regards >> Jeff >> >> >> On Wed, Oct 14, 2009 at 1:16 AM, Milinda Pathirage < >> milinda.pathirage@...> wrote: >> >>> Hi Helko, >>> >>> After building ODE 1.x you will find hibernate SQL scripts at >>> ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at >>> ODE_ROOT/dao-jpa-ojpa-derby/target directory. >>> >>> Thanks >>> Milinda >>> >>> On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <hbraun@...> wrote: >>> >>> > >>> > I am looking for the DB scripts to initialize the table structure on >>> any >>> > other DB then derby. >>> > We are using the 1.x branch of ODE and the 1.3.3 release scripts don't >>> seem >>> > to work (at least on mysql). >>> > >>> > Also, do JPA and Hibernate require different schemas? >>> > If so, what should the scripts in the distribution be used for? >>> > >>> > Can anyone point in the right direction? >>> > >>> > >>> > Thanks a lot, >>> > Heiko >>> > >>> >>> >>> >>> -- >>> Milinda Pathirage >>> Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps >>> WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com >>> E-mail: milinda@..., milinda.pathirage@... >>> Web: http://mpathirage.com >>> Blog: http://blog.mpathirage <http://blog.mpathirage.com> >>> >> >
	Re: Database scripts by Milinda Pathirage :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi Jeff, There were some errors in SQL scripts generated by hibernate, even in MS SQL Server scripts. You'll have to manually fix those errors. AFAIK those scripts are generated hibernate built-in tool. Thanks Milinda On Fri, Oct 30, 2009 at 10:57 AM, Jeff Yu <jeff.yuchang@...> wrote: > Update the blob into bytea for postgres.sql will fix this issue. > > I am wondering how do we generate these db scripts? by using Hibernate > built-in tool? > > Regards > Jeff > > On Fri, Oct 30, 2009 at 12:49 PM, Jeff Yu <jeff.yuchang@...> wrote: > > > simply update the blob(2G) to blob will work for mysql case, but I found > > the postgres.sql doesn't work either. > > > > [sql] Failed to execute: CREATE TABLE ode_job ( jobid CHAR(64) > NOT > > NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), > scheduled > > int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, details > blob, > > PRIMARY KEY(jobid)) > > [sql] org.postgresql.util.PSQLException: ERROR: type "blob" does > not > > exist > > > > Regards > > Jeff > > > > > > On Fri, Oct 30, 2009 at 12:16 PM, Jeff Yu <jeff.yuchang@...> > wrote: > > > >> It seems the mysql db script still doesn't work well, below is what I > got > >> when i am trying to run it. (my mysql version is 5.0.84) > >> > >> [sql] Failed to execute: create table LARGE_DATA (ID bigint not > >> null auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK > integer > >> not null, primary key (ID)) > >> [sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You > have > >> an error in your SQL syntax; check the manual that corresponds to your > MySQL > >> server version for the right syntax to use near '2G), INSERT_TIME > datetime, > >> MLOCK integer not null, primary key (ID))' at line 1 > >> > >> I am testing against 1.x trunk. Seems this issue was existed for a long > >> time?? ( > >> http://mmondora.mondora.com/2009/01/apache-ode-jboss-and-mysql.html) > >> > >> Regards > >> Jeff > >> > >> > >> On Wed, Oct 14, 2009 at 1:16 AM, Milinda Pathirage < > >> milinda.pathirage@...> wrote: > >> > >>> Hi Helko, > >>> > >>> After building ODE 1.x you will find hibernate SQL scripts at > >>> ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at > >>> ODE_ROOT/dao-jpa-ojpa-derby/target directory. > >>> > >>> Thanks > >>> Milinda > >>> > >>> On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <hbraun@...> > wrote: > >>> > >>> > > >>> > I am looking for the DB scripts to initialize the table structure on > >>> any > >>> > other DB then derby. > >>> > We are using the 1.x branch of ODE and the 1.3.3 release scripts > don't > >>> seem > >>> > to work (at least on mysql). > >>> > > >>> > Also, do JPA and Hibernate require different schemas? > >>> > If so, what should the scripts in the distribution be used for? > >>> > > >>> > Can anyone point in the right direction? > >>> > > >>> > > >>> > Thanks a lot, > >>> > Heiko > >>> > > >>> > >>> > >>> > >>> -- > >>> Milinda Pathirage > >>> Senior Software Engineer & Product Manager WSO2 BPS; > http://wso2.org/bps > >>> WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com > >>> E-mail: milinda@..., milinda.pathirage@... > >>> Web: http://mpathirage.com > >>> Blog: http://blog.mpathirage <http://blog.mpathirage.com> > >>> > >> > > > -- Milinda Pathirage Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps WSO2 Inc.; http://wso2.com E-mail: milinda@..., milinda.pathirage@... Web: http://mpathirage.com Blog: http://blog.mpathirage.com
	Re: Database scripts by Karthick Sankarachary-3 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Milinda is right in that those scripts are generated by Hibernate. Just for future reference, shown below are the column types that denote blobs in certain database providers: MySQL - mediumblob Postgres - bytea Ingres - long byte Oracle - blob Derby - blob(2G) DB2 - blob(1073741823) Sybase - IMAGE null SQL Server - image null Hope it helps. Best Regards, Karthick Sankarachary On Fri, Oct 30, 2009 at 3:51 AM, Milinda Pathirage < milinda.pathirage@...> wrote: > Hi Jeff, > > There were some errors in SQL scripts generated by hibernate, even in MS > SQL > Server scripts. You'll have to manually fix those errors. AFAIK those > scripts are generated hibernate built-in tool. > > Thanks > Milinda > > On Fri, Oct 30, 2009 at 10:57 AM, Jeff Yu <jeff.yuchang@...> wrote: > > > Update the blob into bytea for postgres.sql will fix this issue. > > > > I am wondering how do we generate these db scripts? by using Hibernate > > built-in tool? > > > > Regards > > Jeff > > > > On Fri, Oct 30, 2009 at 12:49 PM, Jeff Yu <jeff.yuchang@...> > wrote: > > > > > simply update the blob(2G) to blob will work for mysql case, but I > found > > > the postgres.sql doesn't work either. > > > > > > [sql] Failed to execute: CREATE TABLE ode_job ( jobid CHAR(64) > > NOT > > > NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), > > scheduled > > > int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, details > > blob, > > > PRIMARY KEY(jobid)) > > > [sql] org.postgresql.util.PSQLException: ERROR: type "blob" does > > not > > > exist > > > > > > Regards > > > Jeff > > > > > > > > > On Fri, Oct 30, 2009 at 12:16 PM, Jeff Yu <jeff.yuchang@...> > > wrote: > > > > > >> It seems the mysql db script still doesn't work well, below is what I > > got > > >> when i am trying to run it. (my mysql version is 5.0.84) > > >> > > >> [sql] Failed to execute: create table LARGE_DATA (ID bigint not > > >> null auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK > > integer > > >> not null, primary key (ID)) > > >> [sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You > > have > > >> an error in your SQL syntax; check the manual that corresponds to your > > MySQL > > >> server version for the right syntax to use near '2G), INSERT_TIME > > datetime, > > >> MLOCK integer not null, primary key (ID))' at line 1 > > >> > > >> I am testing against 1.x trunk. Seems this issue was existed for a > long > > >> time?? ( > > >> http://mmondora.mondora.com/2009/01/apache-ode-jboss-and-mysql.html) > > >> > > >> Regards > > >> Jeff > > >> > > >> > > >> On Wed, Oct 14, 2009 at 1:16 AM, Milinda Pathirage < > > >> milinda.pathirage@...> wrote: > > >> > > >>> Hi Helko, > > >>> > > >>> After building ODE 1.x you will find hibernate SQL scripts at > > >>> ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at > > >>> ODE_ROOT/dao-jpa-ojpa-derby/target directory. > > >>> > > >>> Thanks > > >>> Milinda > > >>> > > >>> On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <hbraun@...> > > wrote: > > >>> > > >>> > > > >>> > I am looking for the DB scripts to initialize the table structure > on > > >>> any > > >>> > other DB then derby. > > >>> > We are using the 1.x branch of ODE and the 1.3.3 release scripts > > don't > > >>> seem > > >>> > to work (at least on mysql). > > >>> > > > >>> > Also, do JPA and Hibernate require different schemas? > > >>> > If so, what should the scripts in the distribution be used for? > > >>> > > > >>> > Can anyone point in the right direction? > > >>> > > > >>> > > > >>> > Thanks a lot, > > >>> > Heiko > > >>> > > > >>> > > >>> > > >>> > > >>> -- > > >>> Milinda Pathirage > > >>> Senior Software Engineer & Product Manager WSO2 BPS; > > http://wso2.org/bps > > >>> WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com > > >>> E-mail: milinda@..., milinda.pathirage@... > > >>> Web: http://mpathirage.com > > >>> Blog: http://blog.mpathirage <http://blog.mpathirage.com> > > >>> > > >> > > > > > > > > > -- > Milinda Pathirage > Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps > WSO2 Inc.; http://wso2.com > E-mail: milinda@..., milinda.pathirage@... > Web: http://mpathirage.com > Blog: http://blog.mpathirage.com >
	Re: Database scripts by Jeff Yu :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Thanks Milinda and Karthick. I've just created a jira ( https://issues.apache.org/jira/browse/ODE-690) for the tracking, and also good for others search. Regards Jeff On Sat, Oct 31, 2009 at 1:17 AM, Karthick Sankarachary < sankarachary@...> wrote: > Milinda is right in that those scripts are generated by Hibernate. > > Just for future reference, shown below are the column types that denote > blobs in certain database providers: > > MySQL - mediumblob > Postgres - bytea > Ingres - long byte > Oracle - blob > Derby - blob(2G) > DB2 - blob(1073741823) > Sybase - IMAGE null > SQL Server - image null > > Hope it helps. > > Best Regards, > Karthick Sankarachary > > > On Fri, Oct 30, 2009 at 3:51 AM, Milinda Pathirage < > milinda.pathirage@...> wrote: > > > Hi Jeff, > > > > There were some errors in SQL scripts generated by hibernate, even in MS > > SQL > > Server scripts. You'll have to manually fix those errors. AFAIK those > > scripts are generated hibernate built-in tool. > > > > Thanks > > Milinda > > > > On Fri, Oct 30, 2009 at 10:57 AM, Jeff Yu <jeff.yuchang@...> > wrote: > > > > > Update the blob into bytea for postgres.sql will fix this issue. > > > > > > I am wondering how do we generate these db scripts? by using Hibernate > > > built-in tool? > > > > > > Regards > > > Jeff > > > > > > On Fri, Oct 30, 2009 at 12:49 PM, Jeff Yu <jeff.yuchang@...> > > wrote: > > > > > > > simply update the blob(2G) to blob will work for mysql case, but I > > found > > > > the postgres.sql doesn't work either. > > > > > > > > [sql] Failed to execute: CREATE TABLE ode_job ( jobid > CHAR(64) > > > NOT > > > > NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), > > > scheduled > > > > int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, details > > > blob, > > > > PRIMARY KEY(jobid)) > > > > [sql] org.postgresql.util.PSQLException: ERROR: type "blob" > does > > > not > > > > exist > > > > > > > > Regards > > > > Jeff > > > > > > > > > > > > On Fri, Oct 30, 2009 at 12:16 PM, Jeff Yu <jeff.yuchang@...> > > > wrote: > > > > > > > >> It seems the mysql db script still doesn't work well, below is what > I > > > got > > > >> when i am trying to run it. (my mysql version is 5.0.84) > > > >> > > > >> [sql] Failed to execute: create table LARGE_DATA (ID bigint > not > > > >> null auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK > > > integer > > > >> not null, primary key (ID)) > > > >> [sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You > > > have > > > >> an error in your SQL syntax; check the manual that corresponds to > your > > > MySQL > > > >> server version for the right syntax to use near '2G), INSERT_TIME > > > datetime, > > > >> MLOCK integer not null, primary key (ID))' at line 1 > > > >> > > > >> I am testing against 1.x trunk. Seems this issue was existed for a > > long > > > >> time?? ( > > > >> http://mmondora.mondora.com/2009/01/apache-ode-jboss-and-mysql.html > ) > > > >> > > > >> Regards > > > >> Jeff > > > >> > > > >> > > > >> On Wed, Oct 14, 2009 at 1:16 AM, Milinda Pathirage < > > > >> milinda.pathirage@...> wrote: > > > >> > > > >>> Hi Helko, > > > >>> > > > >>> After building ODE 1.x you will find hibernate SQL scripts at > > > >>> ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at > > > >>> ODE_ROOT/dao-jpa-ojpa-derby/target directory. > > > >>> > > > >>> Thanks > > > >>> Milinda > > > >>> > > > >>> On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <hbraun@...> > > > wrote: > > > >>> > > > >>> > > > > >>> > I am looking for the DB scripts to initialize the table > structure > > on > > > >>> any > > > >>> > other DB then derby. > > > >>> > We are using the 1.x branch of ODE and the 1.3.3 release scripts > > > don't > > > >>> seem > > > >>> > to work (at least on mysql). > > > >>> > > > > >>> > Also, do JPA and Hibernate require different schemas? > > > >>> > If so, what should the scripts in the distribution be used for? > > > >>> > > > > >>> > Can anyone point in the right direction? > > > >>> > > > > >>> > > > > >>> > Thanks a lot, > > > >>> > Heiko > > > >>> > > > > >>> > > > >>> > > > >>> > > > >>> -- > > > >>> Milinda Pathirage > > > >>> Senior Software Engineer & Product Manager WSO2 BPS; > > > http://wso2.org/bps > > > >>> WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com > > > >>> E-mail: milinda@..., milinda.pathirage@... > > > >>> Web: http://mpathirage.com > > > >>> Blog: http://blog.mpathirage <http://blog.mpathirage.com> > > > >>> > > > >> > > > > > > > > > > > > > > > -- > > Milinda Pathirage > > Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps > > WSO2 Inc.; http://wso2.com > > E-mail: milinda@..., milinda.pathirage@... > > Web: http://mpathirage.com > > Blog: http://blog.mpathirage.com > > > -- Cheers, Jeff Yu ---------------- blog: http://jeff.familyyu.net twitter: http://www.twitter.com/jeffyuchang