Jdbc Videos

V deo gravado no EJES 2009. Persist ncia Java: programando com SQL, Hibernate e BDs n o-relacionais com Paulo Silveira. Carlan Calazans - http://carlancalazans.com

V deo gravado no EJES 2009. Persist ncia Java: programando com SQL, Hibernate e BDs n o-relacionais com Paulo Silveira. Carlan Calazans - http://carlancalazans.com

AJAX Database Connectivity is the Data Access Component of OAT (OpenLink AJAX Toolkit). It s basically an XML for Analysis (XMLA) client that enables the development and deployment of database independent Rich Internet Applications (RIAs). Thus, you can now develop database centric AJAX applications without lock-in at the Operating System, Database Connectivity mechanism (ODBC, JDBC, OLEDB, ADO.NET), or back-end Database levels. XMLA has been around for a long time. Its fundamental goal was to provide Web Applications with Tabular and Multi-dimensional data access before it fell off the radar (a story too long to tell in this post). AJAX Database connectivity only requires your target DBMS to be XMLA (direct), ODBC, JDBC, OLEDB, or ADO.NET accessible. I have attached a Query By Example (QBE) screencast movie enclosure to this post (should you be reading this post Web 1.0 style). The demo shows how Paradox-, Quattro Pro-, Access-, and MS Query-like user friendly querying is achieved using AJAX Database  Connect Connectivity

This screencast demo (enclosure attached) is a continuation from my earlier Ajax and QBE screencast demo. This time the focus is on building Excel like Pivot tables using data exposed via Ajax Database Connectivity.

Another demo. This time around you are looking at a quick and dirty mashup assembled using the OAT FormDesigner. There is a follow-on demo that shows how this was assembled (no coding whatsoever!).

This screencast covers the actual codeless process of building a database centric Web 2.0 mash-up using OAT s database-aware Forms Designer. This is basically the simplicity of Paradox or Microsoft ACCESS form building delivered via Ajax without any database or operating system lock-in. This demo uses the Google Mapping Service (note: there is a Yahoo! Mapping Service screencast demo that follows this post). Also note that fact that in this demonstration I actually incorporate the Pivot building functionality from an earlier Ajax based Pivot Building screencast.

This is a Yahoo! maps variation of the Google Maps based Forms Designer mash-up screencast.