OpenDev
08-14-2005, 11:24 PM
Hallo OpenLaszlo Developer Community,
I am new to the OpenLaszlo community and I have request of solution sketches/implementation ideas.
My prior knowledge: XML, Java, {OpenLaszlo30DevGuide, LaszloNextGenWP}.pdf, software: openlaszlo-3.0.2-windows-dev
3.) There is little information how to retrieve information from relational databases,e.g. DB2 or Oracle directly by means of the OpenLaszlo syntax. The only information to be found my is in OpenLaszlo Explorer\Laszlo in 10 minutes\Data\Accessing Databases
"A <dataset> can also point to a server-side program (in this example, a JSP) that generates the XML document dynamically. This is the most popular approach to develop applications that use dynamic data coming from a database or any other datasource. In this example, a JSP (JavaServer Page) is used to retrieve data from a relational database and format the result set as an XML document. A dataset can point to any kind of server-side program that is capable of generating XML dynamically: JavaServer Pages, Servlets, Microsoft Active Server Pages, ColdFusion pages, CGI applications, PHP scripts, etc."
I wonder whether we can make JavaScript JDBC calls from the OpenLaszlo code. Personally I am familiar to JSP and Java Server pages. I am not sure how to use JSP to retrieve data from a relational source, e.g. in particular how to obtain the results generated by the JSP servlet in the OpenLaszlo environment. Another idea might be to call a web service which makes call to the database, converts the result set to a XML file, fixed by a known DTD file, and returns it to the OpenLaszlo environment.
Many thanks for the time devoted!
I am new to the OpenLaszlo community and I have request of solution sketches/implementation ideas.
My prior knowledge: XML, Java, {OpenLaszlo30DevGuide, LaszloNextGenWP}.pdf, software: openlaszlo-3.0.2-windows-dev
3.) There is little information how to retrieve information from relational databases,e.g. DB2 or Oracle directly by means of the OpenLaszlo syntax. The only information to be found my is in OpenLaszlo Explorer\Laszlo in 10 minutes\Data\Accessing Databases
"A <dataset> can also point to a server-side program (in this example, a JSP) that generates the XML document dynamically. This is the most popular approach to develop applications that use dynamic data coming from a database or any other datasource. In this example, a JSP (JavaServer Page) is used to retrieve data from a relational database and format the result set as an XML document. A dataset can point to any kind of server-side program that is capable of generating XML dynamically: JavaServer Pages, Servlets, Microsoft Active Server Pages, ColdFusion pages, CGI applications, PHP scripts, etc."
I wonder whether we can make JavaScript JDBC calls from the OpenLaszlo code. Personally I am familiar to JSP and Java Server pages. I am not sure how to use JSP to retrieve data from a relational source, e.g. in particular how to obtain the results generated by the JSP servlet in the OpenLaszlo environment. Another idea might be to call a web service which makes call to the database, converts the result set to a XML file, fixed by a known DTD file, and returns it to the OpenLaszlo environment.
Many thanks for the time devoted!