Looking for a framework to access database via AJAX?

views:

106

answers:

Looking for a framework to access database via AJAX?

I'm looking for an AJAX framework to transact to an Oracle database. Preferably the framework will be open source and to at least some degree RESTful or RPC.

Edit(1): I would prefer to deploy in Apache Tomcat.

Edit(2): I would also prefer not to implement a "kitchen sink" framework where I'm either implementing only 2% of the framework or having to completely change the way I do things to adopt the framework's architectural bias.

Edit(3): Having to completely write the DB access is doable, but not a framework. So the likes of jQuery is only half the solution.

Edit(4): Realizing that I'm probably going to get flamed for this, I have an admission to make... I have published a framework which provides the functionality which I described here. I was phishing for, not "competitors", but other similar frameworks which could give me ideas on how to improve.

GWT is a good option, if you feel comfortable with the abstraction it makes. It uses RPC, and can easily be deployed in tomcat.

GWT Oracle introduction

You can also take a look at ICEFaces, this links takes you to an Oracle tutorial.

Usually a framework, specially in Java, is not DBMS specific. There are tons of AJAX frameworks that can be used with Oracle. See this link for more options.

tou 2010-02-01 23:01:20

Taking a look at GWT, it seems it does an awful lot when all I want is to make AJAX calls to Oracle.

dacracot 2010-02-01 23:42:24

I think I understood better now. Then, JQuery is very good JavaScript framework. It has AJAX functions. Just create the corresponding servlet(s) that return the data from the DB, and call them by a JQuery AJAX call. See http://soundcrisis.wordpress.com/2009/04/19/jsp-javaserver-pages-and-jquery-ajax/ for a simple example

tou 2010-02-02 15:09:56

"Just create the corresponding servlet(s) that return the data from the DB"... WOW. I can do this, but when asking for framework that provides functionality, I don't expect to have to write most of it from scratch.

dacracot 2010-02-02 16:37:42

If you don't want to code the backend either, then you can take a look at Netbeans Web capabilites. http://netbeans.org/features/web/web-app.html. It is supposed to be able to connect to Oracle, and it also has a visual editor. You can then use the JMaki plugin.Netbeans also assist you creating Web services. http://netbeans.org/features/web/web-app.html.

tou 2010-02-02 16:51:25

On Tomcat you can deploy applications with more agile and productive languages, such as JRuby (Rails) and Groovy (Grails). Rails has built-in Ajax features, Grails too.

If you want to develop mainly in JS have a look at SproutCore

rtacconi 2010-02-01 23:07:15

I see nothing regarding Oracle here. Where should I look?

dacracot 2010-02-01 23:16:10

Thanks for the -1. Do you know that Rails and Grails are use with several DBMSs, Oracle included of course. It was implicit. For tip and tricks Rails/Oracle: http://railsmagazine.com/issues/4

rtacconi 2010-02-02 22:41:02

ansaurus

tags:

views:

answers:

Looking for a framework to access database via AJAX?

related questions