Actually Jon,
Torque and crossdb are quite a bit different. Torque is pre generated and requires
some preliminary setup and doesn't deal with SQL statements directly. Whereas crossdb
is on the fly and is an object oriented way of creating SQL statements that are
database independent.
Torque row insert example after generation (taken from tutorial):
Publisher addison = new Publisher();
addison.setName("Addison Wesley Professional");
addison.save();
Author bloch = new Author();
bloch.setFirstName("Joshua");
bloch.setLastName("Bloch");
bloch.save();
crossdb row insert example:
InsertQuery iq = factory.getInsertQuery();
iq.setTable("Employees");
iq.addAutoIncrementColumn("emp_id");
iq.addColumn("emp_name", "Travis Reeder");
iq.addColumn("emp_department", "Development");
iq.execute(conn);
Quite a bit different don't you think?
Tim: I did read that page and thought I covered the more important points. Is there a
formal way of doing these proposals?
Travis
---- Original Message ----
From: Jon Scott Stevens <[EMAIL PROTECTED]>
Sent: 2002-04-21
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Subject: Re: Subproject Proposal - crossdb
If anything, crossdb is something that is a few generations behind Torque in
terms of functionality and design.
http://jakarta.apache.org/turbine/torque/
Funny how all the rage recently seems to be creating these OR tools.
-jon
on 4/21/02 7:29 PM, "Tim Vernum" <[EMAIL PROTECTED]> wrote:
> From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
>
>> On Sun, 2002-04-21 at 21:10, [EMAIL PROTECTED] wrote:
>
>>> The project is called crossdb and can be found at www.crossdb.com.
>>>
>>> What is it?
>>> crossdb is a Java API that is used to create SQL statements
>> that are database independent. So you can write an
>> application and have it run the exact same on any database
>> (ie: MySQL, Oracle, MS SQL Server, etc.)
>
>> Out of morbid curiosity... I couldn't find this answered on the
>> website... How is this different then hsql
>> (hsqldb.sourceforge.net) and
>> why would I want to use it as opposed to hsql?
>
> I have nothing to do with either project, but hsql *is* a database.
> crossdb is a database API
>
> Your question is somewhat akin to "what's the difference between
> jdbc and oracle?"
>
> To the original poster (Travis), if you haven't already done so,
> you should read
> http://jakarta.apache.org/site/newproject.html
> and formulate your proposal to cover all the issues dicussed there.
--
Nixon: "At least with liquor, I don't lose motivation."
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
