using tomcat+mysql+xsql

[Jean-Yves]

Hello,
I'm starting to develop en application with laszlo and i use xsql servlet from oracle to retrieve xml from mysql database directly without the need of coding a jsp or a php file to do that.

It works fine to retrieve data, but I don't know how to use the <xsql:insert-request/> or <xsql:delete-request/> <xsql:update-request/>.

Does someone have an idea or an example how to do that?
Thanks for your help.
Jean-Yves

[Jean-Yves]

does nobody use xsql?

[d~l]

I (for one) don't use XSQL .. it is not open source .. but eXist (http://exist.sourceforge.net/) is open source and works on tomcat server with OpenLaszlo.

[Jean-Yves]

thanks for your answer!
I will check it and come back to you.

[Arabian]

I (for one) don't use XSQL .. it is not open source .. but eXist (http://exist.sourceforge.net/) is open source and works on tomcat server with OpenLaszlo.

Thank you I was looking for it ;)

[Jean-Yves]

Hi D~L,
I've read a lot of threads regarding databases, and let's say I don't know anymore where I should begin...
There is so much ways, jsp php , hibernate, Laszlo on Rails, laszlo/RIFE and what about the http://wiki.openlaszlo.org/Database_Connector?

Is there a best practice? What do you personnaly use to access databases?
I need to make a choice, but it must be something reliable and scalable.

Thanks for helping a newbie...
Merry Christmas!
Jean-Yves

[d~l]

This article (http://www.rpbourret.com/xml/XMLAndDatabases.htm) might help you to choose between .. relational DB, XML DB, or a hybrid.

The personal choice depends on a number of factors ..


what servers you have available ... Apache, Tomcat or both
PHP5 available?
document structure
etc.


With the latest MySQL + PHP5 you have XML functionality.

But eXist is also a good choice .. if you have a Tomcat server.

Look also at www.flash-db.com (http://www.flash-db.com)

[Jean-Yves]

Thank you for your quick reply.
I have both apache and tomcat.
I can make PHP5 available. (don't know how use it but I have book on it to study).

But let's say I'm more confortable whith oracle Db than mySql ( I was formerly an oracle forms developer and unfortunately not java), and so oracle XE db is also not so bad for me.

I don't want to re-inventing the wheel, but to be sure of chosing the right and the simpliest way to do.
I need master-details forms, need to acces stored procedures, need to control commit and rollback etc...

So php is it the way?

Thanks

[d~l]

"So php is it the way?"

I would say yes .. and in particular PHP5 which has XML, and SQL, extensions.

...

Plenty of sites on PHP5 + Oracle DB connection.

Also, in my list of options I should have mentioned haxe and neko (http://haxe.org).
Check them out (haxe + neko) for an interesting "one stop" language.

[hminsky]

I am most comfortable developing a server side database connector using PHP, with XML extensions.

My Laszlo app sends REST requests to the server, If my laszlo client app is sending structured data, I may send it as XML, and parse that in PHP. JSON is also a possibility these days. My php script parses the request, and then I make database calls. Then I package up the response as XML (or JSON) and return it to the client.

There may be more automated ways to do this, but I like to do it explicitly, so I have full control over the whole end to end process of manipulating the data.

So i write everything by hand. Maybe not the most efficient way to work, but it works for me for the scale of applications I write.

[hipik]

Just curious here,

Does anyone use java and if yes you might want to look into xStream api here
http://xstream.codehaus.org/.

Cheers.

Hipik ZM