Category Archives: ooRexx

Programming Language

Implementing a MySQL DB connection via ooRexx by using BSF4ooRexx – (3_MySql_connector.rxj)

10/17/2014Content Syndication, ooRexx, ProgrammingMartin Stoppacher

/* ***************************************************************************** */
/* This is a short example of implementing a MySQL DB connection via ooRexx      */ 
/* by using BSF4ooRexx. Using the Java - mysql connector via bean scripting      */
/* in ooRexx                                                                     */
/* created by Martin Stoppacher - 26.12.2009                                     */
/* ***************************************************************************** */

say hello access to a my sql database via java using bsf4rexx
uid = "root";
url = "jdbc:mysql://localhost/test";
pw = "password";

mydrive=.bsf~new('com.mysql.jdbc.Driver')        /* establishe the db connection */
man=bsf.loadClass("java.sql.DriverManager")
man~registerDriver(mydrive)

conn=man~getConnection(url, uid, pw)                  /* connecting the database */

stmt=conn~createStatement                                       /* fetching data */
rset=stmt~executeQuery("select max(Nr)+1 as maximum from mytest")

rset~next; i = rset~getString("maximum"); say i;
stmt~executeUpdate("insert into mytest values(" || i ||",'BSF4ooRexx')") 

rset=stmt~executeQuery("select NR, NAME from mytest")           /* fetching data */

say "NR______NAME"                                                 /* print data */
do while rset~next
say rset~getString("nr")  || ______ || rset~getString("NAME")
end

say end

::requires BSF.CLS                                       /* get the Java support */

/* ***************************************************************************** */

/* This is a short example of implementing a MySQL DB connection via ooRexx */

/* by using BSF4ooRexx. Using the Java - mysql connector via bean scripting */

/* in ooRexx */

/* created by Martin Stoppacher - 26.12.2009 */

/* ***************************************************************************** */

say hello access to a my sql database via java using bsf4rexx

uid = "root";

url = "jdbc:mysql://localhost/test";

pw = "password";

mydrive=.bsf~new('com.mysql.jdbc.Driver') /* establishe the db connection */

man=bsf.loadClass("java.sql.DriverManager")

man~registerDriver(mydrive)

conn=man~getConnection(url, uid, pw) /* connecting the database */

stmt=conn~createStatement /* fetching data */

rset=stmt~executeQuery("select max(Nr)+1 as maximum from mytest")

rset~next; i = rset~getString("maximum"); say i;

stmt~executeUpdate("insert into mytest values(" || i ||",'BSF4ooRexx')")

rset=stmt~executeQuery("select NR, NAME from mytest") /* fetching data */

say "NR______NAME" /* print data */

do while rset~next

say rset~getString("nr") || ______ || rset~getString("NAME")

end

say end

::requires BSF.CLS /* get the Java support */

ooRexx with BSF4ooRexx – “java,net.URL” Classes (2_getinfo.rxj)

08/05/2014Code, Content Syndication, ooRexx, ProgrammingMartin Stoppacher

/* ***************************************************************************** */
/* This is just a short example of implementing the  "java,net.URL" classes      */
/* using BSF4ooRexx                                                              */   
/* created by Martin Stoppacher    26.12.2009                                    */
/* ***************************************************************************** */

say hello this reads a syndfeed
say please type in the url
url= "http://rss.orf.at/fm4.xml"

f=.bsf~new("java.net.URL", url) /* creating a java url object with the above url */

say f~getAuthority()                      /* gets the authority part of this URL */
say f~getDefaultPort()           /* gets the default port number of the protocol */
                                                     /* associated with this URL */
say f~getPort()                              /* gets the port number of this URL */
say f~getFile()                                /* gets the file name of this URL */
say f~getHost()                 /* gets the host name of this URL, if applicable */
say f~getProtocol()                        /* gets the protocol name of this URL */
say f~getQuery()                              /* gets the query part of this URL */
say f~hashCode()          /* creates an integer suitable for hash table indexing */

::requires BSF.cls                            /* get the Java support for ooRexx */

/* ***************************************************************************** */

/* This is just a short example of implementing the "java,net.URL" classes */

/* using BSF4ooRexx */

/* created by Martin Stoppacher 26.12.2009 */

/* ***************************************************************************** */

say hello this reads a syndfeed

say please type in the url

url= "http://rss.orf.at/fm4.xml"

f=.bsf~new("java.net.URL", url) /* creating a java url object with the above url */

say f~getAuthority() /* gets the authority part of this URL */

say f~getDefaultPort() /* gets the default port number of the protocol */

/* associated with this URL */

say f~getPort() /* gets the port number of this URL */

say f~getFile() /* gets the file name of this URL */

say f~getHost() /* gets the host name of this URL, if applicable */

say f~getProtocol() /* gets the protocol name of this URL */

say f~getQuery() /* gets the query part of this URL */

say f~hashCode() /* creates an integer suitable for hash table indexing */

::requires BSF.cls /* get the Java support for ooRexx */

Syndication Feed Reader (1_Read.rxj) – ooRexx with BSF4ooRexx

08/05/2014Code, Content Syndication, ooRexx, ProgrammingMartin Stoppacher

/* ***************************************************************************** */
/* Example of a syndication feed reader using the Project Rome API with          */
/* BSF4ooRexx                                                                    */
/* current version (2009) of Rome: rome1.0.jar   https://rome.dev.java.net/      */
/* You need to implement this API plus the JDOM API                              */
/* jdom.jar  ,   you can find this at     https://jdom.org/                      */
/*                                                                               */
/* This class retrieves a syndfeed from the web by using a precreated            */
/* Java class via BSF4ooRexx "com.sun.syndication.io.SyndFeedInput" methods      */
/* created by Martin Stoppacher       date:  26.12.2009                          */ 
/* ***************************************************************************** */

javaclass = "FeedReader1"                         /* determine Java class to use */
get=.bsf~new(javaClass)                     /* create an instance of "javaClass" */
say get~getfeed             /* calls the getfeed method in the FeedReader1 class */

::requires BSF.CLS                                       /* get the Java support */

/* ***************************************************************************** */

/* Example of a syndication feed reader using the Project Rome API with */

/* BSF4ooRexx */

/* current version (2009) of Rome: rome1.0.jar https://rome.dev.java.net/ */

/* You need to implement this API plus the JDOM API */

/* jdom.jar , you can find this at https://jdom.org/ */

/* */

/* This class retrieves a syndfeed from the web by using a precreated */

/* Java class via BSF4ooRexx "com.sun.syndication.io.SyndFeedInput" methods */

/* created by Martin Stoppacher date: 26.12.2009 */

/* ***************************************************************************** */

javaclass = "FeedReader1" /* determine Java class to use */

get=.bsf~new(javaClass) /* create an instance of "javaClass" */

say get~getfeed /* calls the getfeed method in the FeedReader1 class */

::requires BSF.CLS /* get the Java support */

Content syndication with the Project ROME Java API by using the open object scripting language ooRexx with BSF4ooRexx

02/18/2010Allgemein, Content Syndication, Data Analysis, Engineering, Java, ooRexx, ProgrammingMartin Stoppacher

Content syndication with the Project ROME Java API
by using the open object scripting language ooRexx
with BSF4ooRexx
–
Project Rome in combination with BSF4ooRexx

Martin Stoppacher
2010

Abstract
This text tries to convey a basic understanding and knowledge of concepts, usage and
possibilities of the “Project ROME”(1) (Java) API (2). Furthermore the text provides a description
and documentation about interfacing Java (and therefore the Project ROME API) with ooRexx (4)
by using its extension BSF4ooRexx.
Specifically the text deals with the functionalities Project ROME is providing, as well as its
technical concepts and relations. This functionalities get extended by using BSF4ooRexx and
therefore demonstrate how to use an external Java API in open object Rexx.
As Project ROME deals with the processing of content syndication (3) the first part of the paper
covers the explanation of concepts and basics related to content syndication.
The second part deals with the processing of content syndication via Project Rome by using the
Java programming language. Project Rome will be described and a few example programs in Java will explain its functionalities.
The following parts cover the usage of ooRexx (4) with BSF4ooRexx (5). Therefore a short
introduction to this topic will be given and afterwards the usage of Project Rome with
BSF4ooRexx will be explained through examples.
The final part is built by a collection of several example programs which demonstrate the usage of Project Rome. First some Java examples are shown and second the corresponding ooRexx examples demonstrate how it is possible to use the same classes within ooRexx.

https://wi.wu.ac.at/rgf/diplomarbeiten/BakkStuff/2010/201001_Stoppacher/Project_Rome_in_combination_with_BSF4ooRexx_Paper.pdf

https://kipdf.com/content-syndication-with-project-rome-by-using-oorexx-with-bsf4oorexx_5b35b79c097c475e228b49b0.html

An example of a syndication feed reader using the Project Rome API with BSF4ooRexx – “java.net.URL” feed reader (2_Rome.rxj)

12/11/2009Code, Content Syndication, Java, ooRexx, Programmingcode, ooRexx, programmingMartin Stoppacher

/* ***************************************************************************** */
/* Example of a syndication feed reader using the Project Rome API with          */
/* BSF4ooRexx                                                                    */
/* current version (2009) of Rome: rome1.0.jar        https://rome.dev.java.net/ */
/* You need to implement this API plus the JDOM API                              */
/* jdom.jar,     you can find this at https://jdom.org/                          */
/* This class retrieves a syndfeed from the web and prints some                  */
/* information about the feed using                                              */
/* "com.sun.syndication.io.SyndFeedInput" methods                                */
/* created by Martin Stoppacher     date:   26.12.2009                           */
/* ***************************************************************************** */

say hello this reads a syndfeed 
--say please type in the url        /* possible input statement for the feed URL */ 
--pull url 

--parse arg url                                  /* optional input via arguments */ 

         /* The url String is predefined in this example, to change the feed url */ 
               /* replace to String in this file or use one of the above methods */ 

url= "http://rss.orf.at/fm4.xml" 
feedUrl=.bsf~new("java.net.URL", url)      /* create an instance of java.net.URL */ 
say connecting__ || feedUrl~getAuthority() 

input=.bsf~new("com.sun.syndication.io.SyndFeedInput")/* creates a SyndFeedInput */

xmlr=.bsf~new("com.sun.syndication.io.XmlReader", feedUrl) 
       /* Figures out the charset encoding of the XML document within the stream */ 
feed= input~build(xmlr) 
         /* Builds a SyndFeedImpl from an Reader , also possible with SAX or DOM */ 

say bb~getDefaultEncoding() 
say feed                                              /* returns the feed object */ 

::requires BSF.cls                                       /* get the Java support */

/* ***************************************************************************** */

/* Example of a syndication feed reader using the Project Rome API with */

/* BSF4ooRexx */

/* current version (2009) of Rome: rome1.0.jar https://rome.dev.java.net/ */

/* You need to implement this API plus the JDOM API */

/* jdom.jar, you can find this at https://jdom.org/ */

/* This class retrieves a syndfeed from the web and prints some */

/* information about the feed using */

/* "com.sun.syndication.io.SyndFeedInput" methods */

/* created by Martin Stoppacher date: 26.12.2009 */

/* ***************************************************************************** */

say hello this reads a syndfeed

--say please type in the url /* possible input statement for the feed URL */

--pull url

--parse arg url /* optional input via arguments */

/* The url String is predefined in this example, to change the feed url */

/* replace to String in this file or use one of the above methods */

url= "http://rss.orf.at/fm4.xml"

feedUrl=.bsf~new("java.net.URL", url) /* create an instance of java.net.URL */

say connecting__ || feedUrl~getAuthority()

input=.bsf~new("com.sun.syndication.io.SyndFeedInput")/* creates a SyndFeedInput */

xmlr=.bsf~new("com.sun.syndication.io.XmlReader", feedUrl)

/* Figures out the charset encoding of the XML document within the stream */

feed= input~build(xmlr)

/* Builds a SyndFeedImpl from an Reader , also possible with SAX or DOM */

say bb~getDefaultEncoding()

say feed /* returns the feed object */

::requires BSF.cls /* get the Java support */