667481 members! Sign up to stay informed.

Sponsored Links


Resources

Enterprise Java
Research Library

Get Java white papers, product information, case studies and webcasts

News News News Messages: 18 Messages: 18 Messages: 18 Printer friendly Printer friendly Printer friendly Post reply Post reply Post reply XML XML XML

OpenToro Version 3.0 Released

Posted by: Moises Daniel D?az on October 27, 2005 DIGG
OpenToro 3.0 is a SourceForge project is web database publisher designed to create web applications that connect directly to a database. OpenToro dispenses the drudgery of having to use JSP and SQL that normal when one is implementing these types of forms based data driven web-based applications.

OpenToro supports the ability to list of database tables and their contents. It also can generate forms that can be used to insert, modify, or delete data. OpenToro works with any SQL-92 compatible database. It currently has been tested to support MySQL, Oracle, Access, and SQL-Server.

In addition to the tutorial, there is a flash demonstration that is avaliable for viewing.

Threaded replies

·  OpenToro Version 3.0 Released by Moises Daniel D?az on Thu Oct 27 11:54:26 EDT 2005
  ·  What???? by Stephen Davisson on Fri Oct 28 10:14:50 EDT 2005
    ·  Toro by Alain Rogister on Fri Oct 28 10:55:59 EDT 2005
      ·  Toro by Amin Mansuri on Fri Oct 28 15:29:23 EDT 2005
        ·  Java snob by Alain Rogister on Fri Oct 28 15:46:16 EDT 2005
          ·  Java snob by Dennis Bekkering on Fri Oct 28 18:21:23 EDT 2005
          ·  Java snob by Moises Daniel D?az on Fri Oct 28 18:47:41 EDT 2005
    ·  related project: DbForms by joachim peer on Sun Oct 30 12:33:42 EST 2005
      ·  related project: DbForms by Romen Law on Sun Oct 30 18:04:37 EST 2005
      ·  related project: DbForms by Moises Daniel D?az on Mon Oct 31 03:27:26 EST 2005
  ·  ???????? by David McCoy on Fri Oct 28 10:22:04 EDT 2005
    ·  ???????? by Phil Kulak on Fri Oct 28 11:12:46 EDT 2005
    ·  ???????? by Tero Vaananen on Fri Oct 28 21:07:46 EDT 2005
  ·  This is not the new that I have posted... and aditional comments by Moises Daniel D?az on Fri Oct 28 14:56:03 EDT 2005
  ·  THIS NEW MUST TO BE REWRITTEN by Moises Daniel D?az on Fri Oct 28 15:26:34 EDT 2005
  ·  OpenToro Version 3.0 Released by Steve Zara on Fri Oct 28 15:41:45 EDT 2005
    ·  OpenToro Version 3.0 Released by Moises Daniel D?az on Fri Oct 28 18:34:05 EDT 2005
      ·  OpenToro Version 3.0 Released by Steve Zara on Fri Oct 28 19:55:22 EDT 2005
  ·  Is this similar to Access Forms? by Siva Papineni on Tue Nov 01 15:10:23 EST 2005
  Message #189495 Post reply Post reply Post reply Go to top Go to top Go to top

What????

Posted by: Stephen Davisson on October 28, 2005 in response to Message #189413
Am I the only one that can't figure out the clever use of English in this post. I've read it 5 times now and am still trying to decipher what it says.

  Message #189497 Post reply Post reply Post reply Go to top Go to top Go to top

????????

Posted by: David McCoy on October 28, 2005 in response to Message #189413
The logical conclusion of the RAD hype that has recently emerged. Let's just bypass even ROR and go straight to the database from the web page.

Pass.

  Message #189508 Post reply Post reply Post reply Go to top Go to top Go to top

Toro

Posted by: Alain Rogister on October 28, 2005 in response to Message #189495
This particular Toro seems to be lacking in the cojones department even though the ability to list the database tables seems appealing. Is Bruce around ? We need him to predict if this will be the Next Big Thing.

  Message #189511 Post reply Post reply Post reply Go to top Go to top Go to top

????????

Posted by: Phil Kulak on October 28, 2005 in response to Message #189497
The logical conclusion of the RAD hype that has recently emerged. Let's just bypass even ROR and go straight to the database from the web page.Pass.

I'm pretty sure this is just a Java PHPMyAdmin.

  Message #189550 Post reply Post reply Post reply Go to top Go to top Go to top

This is not the new that I have posted... and aditional comments

Posted by: Moises Daniel D?az on October 28, 2005 in response to Message #189413
THIS IS the new that I posted yesterday:

OpenToro is a Web Database Publisher, a tool that allows us developing database-driven web applications in an agile and automatic way. Using OpenToro simply means to forget coding countless SQLs and JSPs every time we want to implement a web application with database access.
With Opentoro you will be able to easily:
* Listing Database Tables.
* Visualizing Records.
* Generating Forms for inserting, modifying and deleting records.

OpenToro Works with any SQL-92 compatible database, but if you want to use advanced features of some databases you can use (or develop) specific SQL Engines. OpenToro implements SQL Engines for the following databases:

* MySql.
* Oracle.
* Access.
* SQL-Server.

Do you want to take a fast look? Download the Video Tutorial (1091 kb).

____________________________

Ok, OpenToro is not going to be the next big thing, but I'm sure it is a useful tool.

There are a lot of ocasions where existing databases needs to be published in the web. OpenToro makes it easy.

There are some special characteristis of OpenToro:
 - It don't generates code, so you don't have to maintein code (saves money).
 - It is simple Java, so is easy to deploy, use, and modify. In addition, developers can use it with a medium java knowledge.
 - It has a integrated WebCache, so it is very, very fast.


We are working to develop a tag lib, and a set of JSF components, to make it easier to integrate with other frameworks.


Best Regards!

http://www.moisesdaniel.com

  Message #189555 Post reply Post reply Post reply Go to top Go to top Go to top

THIS NEW MUST TO BE REWRITTEN

Posted by: Moises Daniel D?az on October 28, 2005 in response to Message #189413
I repeat, this is not the new that I posted yesterday (please read my previous post: http://www.theserverside.com/news/thread.tss?thread_id=37321#189550 ).

TheServerSide.com must to change it.

  Message #189556 Post reply Post reply Post reply Go to top Go to top Go to top

Toro

Posted by: Amin Mansuri on October 28, 2005 in response to Message #189508
This particular Toro seems to be lacking in the cojones department even though the ability to list the database tables seems appealing. Is Bruce around ? We need him to predict if this will be the Next Big Thing.

Typical Java snob attitude.. if it doesn't solve world hunger it sucks.. Maybe the project has more humble ambitions?

  Message #189558 Post reply Post reply Post reply Go to top Go to top Go to top

OpenToro Version 3.0 Released

Posted by: Steve Zara on October 28, 2005 in response to Message #189413
OpenToro works with any SQL-92 compatible database. It currently has been tested to support MySQL, Oracle, Access, and SQL-Server

I'm not sure I understand why the restriction to SQL-92 compatible databases. There are JSRs for persistence that are either finalised or close to being finalised (JSR 243-JDO 2.0, JSR 220-EJB 3.0) that allow portable query languages, in addition to SQL, to be used to handle data stores and their contents. There are good open-source implementations of these JSRs (JPOX, OpenAccess, Hibernate). Use of these APIs would allow a very wide range of databases and stores to be supported, and the JSR-implementing products generally include schema analysing tools. A lot of work has been put into these JSRs and the products that implement them; it seems a waste not to make use of products that implement them, and their accompanying tools.

  Message #189559 Post reply Post reply Post reply Go to top Go to top Go to top

Java snob

Posted by: Alain Rogister on October 28, 2005 in response to Message #189556
Maybe the project has more humble ambitions?
Probably. Note that I'm a full-blown snob, not just a Java snob. Excuse me for using a little dose of sarcasm on a serious site like TSS, but I just think it would be more worthwhile to tackle actual unsolved problems rather than re-invent the proverbial wheel for a problem that has been solved about a million times. Editing database tables ? Call me an Office snob, but I would use MS Access for that.

  Message #189571 Post reply Post reply Post reply Go to top Go to top Go to top

Java snob

Posted by: Dennis Bekkering on October 28, 2005 in response to Message #189559
Editing database tables ? Call me an Office snob, but I would use MS Access for that.

I feel like doing the "beyond java" thing again but have to point out that this approach can be a good start of things. As long as there is a good way of customizing the screens it will save a lot of time as opposed to doing everything by hand. I think there is a huge grey area between a webbased db admin tool and doing it the hard way.

  Message #189573 Post reply Post reply Post reply Go to top Go to top Go to top

OpenToro Version 3.0 Released

Posted by: Moises Daniel D?az on October 28, 2005 in response to Message #189558
Hi Steve,
OpenToro 0.1 was released (not publicly) 3 years ago, so we didn't have the tools that you have mentioned.
We finally got a good SQL generator, so we have not changed the way OpenToro access databases.
Anyway, SQL generation have proportionated us a very simple advantage: all people knows SQL. So if you want to change it, or need special development you can do it easily.

We have tried to leave it simple.

In any case, we have discussed about JDO a lot of times, so perhaps we use it in the future.

  Message #189575 Post reply Post reply Post reply Go to top Go to top Go to top

Java snob

Posted by: Moises Daniel D?az on October 28, 2005 in response to Message #189559
Hi Alain,

Again, We knows that OpenToro is not going to be the next big thing, and it's not going to bring us with the world peace, but I think that it is not exactly equal to other applications: the central idea behind OpenToro is applying Reflective Architectures to database maintenance instead of code generation ( http://www.moisesdaniel.com/wri/racg.html ).

When we build the first version, we were not able to find this type of applications (for this purpose) in java.

  Message #189578 Post reply Post reply Post reply Go to top Go to top Go to top

OpenToro Version 3.0 Released

Posted by: Steve Zara on October 28, 2005 in response to Message #189573
Hi Steve,OpenToro 0.1 was released (not publicly) 3 years ago, so we didn't have the tools that you have mentioned.We finally got a good SQL generator, so we have not changed the way OpenToro access databases.Anyway, SQL generation have proportionated us a very simple advantage: all people knows SQL. So if you want to change it, or need special development you can do it easily.We have tried to leave it simple.In any case, we have discussed about JDO a lot of times, so perhaps we use it in the future.

It just seemed to me that it would give you a broader range of databases if you made use of the schema analysis tools and SQL generation capabilities of currently existing JDO 2.0 and EJB 3.0 tools. Targetting, for example, EJBQL (or JDOQL) rather than SQL 92 would potentially allow you to work with a very wide range of relational stores, making your product far more widely applicable.

Although I am a dedicated supporter of JDO, I would personally suggest you look at EJB 3.0, as you appear to be concentrating on relational databases.

  Message #189582 Post reply Post reply Post reply Go to top Go to top Go to top

????????

Posted by: Tero Vaananen on October 28, 2005 in response to Message #189497
The logical conclusion of the RAD hype that has recently emerged. Let's just bypass even ROR and go straight to the database from the web page.Pass.

Well, it is not so crazy as it seems. How about this:

Do all the data access logic in stored procedures and create xml documents right from stored proc calls using DB xml features. Then style it with xslt right to the site as html. The control layer is only a hundred lines of Java code or so for the whole site. The whole site is updated when there are changes to the database using triggers. Session state is kept in a cookie, and all interactive pages are done entirely in Java script including the business logic.

I just know a guy who's thought process of building dynamic database driven sites is exactly like this. Strange? For him it makes perfect sense.

  Message #189613 Post reply Post reply Post reply Go to top Go to top Go to top

related project: DbForms

Posted by: joachim peer on October 30, 2005 in response to Message #189495
if you are interested in a RAD framework that speeds up the development of Web based database applications, i would like to recommend DbForms.

DbForms can be used to create comprehensive database forms, supporting features such as nested forms, client side input validation, sorting, etc. -- blending nicely with JSP and all other parts of the J2EE framework.

here is the web site:

http://jdbforms.sourceforge.net/

user manual can be found at sourceforge as well. Here are some other articles:

http://www.javaworld.com/javaworld/jw-09-2004/jw-0906-unicode_p.html
http://www.onjava.com/pub/a/onjava/2001/07/18/dbforms.html

PS: yes, i am involved in that project :-)

  Message #189626 Post reply Post reply Post reply Go to top Go to top Go to top

related project: DbForms

Posted by: Romen Law on October 30, 2005 in response to Message #189613
I have used DbForms a few years back and liked it a lot. How does Toro compare to DbForms?

cheers
romen

  Message #189638 Post reply Post reply Post reply Go to top Go to top Go to top

related project: DbForms

Posted by: Moises Daniel D?az on October 31, 2005 in response to Message #189613
The central idea behind OpenToro is applying Reflective Architectures to database maintenance instead of code generation ( http://www.moisesdaniel.com/wri/racg.html ). With OpenToro you don't have to code almost nothing. It works like a black box component(with advantages and disadvantages).

I've seen in DBForms' tutorial that you finally, additionally to XML files describing the database, must to code something like this:
.....
<table border="5" width="60%" align="CENTER">
<tr>
<th>ID</th>
<th>Name</th>
<th>Description</th>
<th>Actions</th>
</tr>
</db:header>
<db:body>
<tr>
<td>
<db:textField fieldName="id" size="5"/>
</td>
<td>
<db:textField fieldName="name" size="20"
maxlength="30"/>
</td>
<td>
<db:textField fieldName="description" size="24"
maxlength="255"/>
</td>
<td>
<db:updateButton caption="Update"/>
<db:deleteButton caption="Delete"/>
</td>
</tr>
</db:body>
..........
And that dbforms can do code generation.

OpenToro only need the XML file, that you can basically generates with the web application.

Anyway, I like DbForms too, and at this moment, it have better documentation that us.

  Message #189870 Post reply Post reply Post reply Go to top Go to top Go to top

Is this similar to Access Forms?

Posted by: Siva Papineni on November 01, 2005 in response to Message #189413
Is this simialr to Access forms in functionality for web apps
Thanks,
Siva

New content on TheServerSide.comNew content on TheServerSide.comNew content on TheServerSide.com

Dependency Injection in Java EE 6 - Part 1

Reza Rahman explores the features of the proposed JSR 299, Contexts and Dependency Injection for Java EE (CDI). When approved, it promises to be a key feature of Java EE 6. (November 2, Article)

SAML: It's Not just for Web services

SAML is an XML-based standard for exchanging authentication and authorization data between security domains. The single most important problem that SAML was created to solve is the Web browser Single Sign-On problem. Many organizations are debating whether to stay with version 1.1 or move to 2.0. This article makes observations about both options. (September 28, Article)

Programming is Also Teaching Your Team

Joe Ottinger takes a look at how people learn, and applies it to the practice of programming. He notes that understanding how people learn is an essential part of working in a programming team. (September 22, Article)

Can Java EE Deliver The Asynchronous Web?

Stephen Maryka gave us an article about the Asynchronous Web and posed a number of questions that get examined like an approach to delivering Asynchronous Web capabilities through extensions to existing Java EE technologies. (July 14, Article)

JSF Flex

JavaServer Faces Flex goal is to provide users capability in creating standard Flex components, part of flexSDK which is open sourced through MPL license, as normal JSF components. This article by Ji Hoon Kim will provide an overview of creating a simple multilingual JSF page consisting of JSF Flex tags. (June 29, Article)

The Rules of SOA - A Road to a Successful SOA Implementation

In this session Jeff explores the key characteristics of successful SOA projects. He covers some of the patterns, and anti-patterns, tool sets, and strategies that he himself learned the hard way. Last, he provides a strategy and blueprint for achieving a high likelihood of success in your SOA project. (June 23, Tech Talk)

Ari Zilka Talks About Terracotta 3.1

Ari Zilka, CTO of Terracotta, Inc., talks about the new features in Terracotta 3.1, announced during JavaOne and available now. (June 15, Tech Talk)

Enterprise Application Integration, and Spring

In this Tech Talk, Josh Long explores an integration challenge using Spring Integration and walks through the implementation, employing and expanding on the basic patterns of Enterprise Application Integration to tie together components into a function integration solution, and then demonstrates how Spring Integration helps address the integration requirements. (June 15, Tech Talk)

Google Web Toolkit: An Introduction

In this Tech Talk, David Geary teaches you: The basics of Google Web Toolkit; How to implement Ajax-enabled applications in Java; Internationalization; Hooking into the browser history mechanism; Remote procedure calls. (June 4, Tech Talk)

Just Enough Early Architecture to Guide Development

Jon Kern discusses the best architecture/technical solutions and ensure that they are repeated by all developers. By tackling the architecture up-front in a serial manner, subsequent parallel development will be much more manageable and predictable. (May 28, Tech Talk)

Productive Programmer: On the Lam from the Furniture Police

This keynote describes the frustrations of modern knowledge workers in their quest to actually get some work done, and solutions for how to guard yourself against all those distractions. Neal Ford talks about environments, coding, acceleration, automation, and avoiding repetition as ways to defeat the misguided attempts to sap your ability to produce good work. (May 26, Tech Talk)

Auto-Scaling Your Existing Web Application

Gil demonstrates how new, aggressive uses of already abundant compute capacity by common applications offer competitive value for application designers. (May 21, Tech Talk)

Automating Hibernate Mapping and Queries For Java Web Development

Chris Keene introduces WaveMaker as a new way to automate the ability to generate Hibernate classes in order to more quickly bring OR mapping into an application. (May 19, Article)

Auto-Scaling Your Existing Web Application

In this session Nati Shalom demonstrates how to take a standard Java EE web application and scale it out or down dynamically without changes to the application code. Seeing as most web applications are over-provisioned to meet infrequent peak loads, this is a dramatic change because it enables growing your application as needed, when needed, without paying for unutilized resources. (May 19, Tech Talk)

Free Book PDF Download: Mastering EJB Third Edition

Mastering EJB was one of the original and most influential EJB books in the industry. Mastering EJB III now returns with two new expert co-authors, updated for EJB 2.1 and 30% new chapters including security, integration, best practices, open source, and more.
(Book PDF Download)

Application Server Matrix

The Application Server Matrix is a detailed listing of J2EE vendors and their application server products, with information on latest version numbers, J2EE spec support and licensing, pricing, platform support, and links to product downloads and reviews.
(Application Server Comparison Matrix)

News | Blogs | Discussions | Tech talks | Patterns | Reviews | White Papers | Downloads | Articles | Media kit | About
Java Solutions
All Content Copyright ©2007 TheServerSide Privacy Policy
Site Map