Re: chooses not to generate code at all

>> What do
>> you use instead of queries?
> If it is an OO application I would use direct relationship navigation to
> the object with the data from the method needing the data.

Lets say we have a planning application with a event class as follow:
class Event
property resourceid
property starttime
property endtime

Now I have a client that want to show all events in a graphical view
for one resource during one week. I would find the events using this
SQL query:

select * from event
where resourceid=? and ((starttime between ? and ?) or (endtime between
? and ?))

How would your solution look like?

> The point is that one does not need persistence to do <business>
> transaction processing.
That's why you would still need a DBMS event if you don't need
persistence.

> A transaction at the application level is
> nothing more that a message {message ID, address, data packet}
For me a transaction is a number of state changes. If one state change
failes, the rest of them has to be cancelled too.

> Nor does one need a DBMS to handle persistence in <business> transaction
> processing.
Other simpler tools can handle persistence in business transaction
processing. But a DBMS would be a better choice. What tool would you
use for persistence handling in business transactions?

Fredrik Bertilsson
http://butler.sourceforge.net

.

Relevant Pages

  • Re: Application logic and Business logic
    ... > conclusion that nobody needs a DBMS because you didn't need it, ... > transaction commits, all registered records could be saved. ... Transaction is akin to monitor, it is a kind of turned inside out monitor. ... Well, DBMS have their niche. ...
    (comp.object)
  • Re: Application logic and Business logic
    ... >> What do you use instead of a DBMS? ... transaction commits, all registered records could be saved. ... > microcontroller controlling the elevator. ... I would not recommed using a RDBMS in embedded microcontrollers. ...
    (comp.object)
  • Re: The C in ACID
    ... it seems reasonable for the dbms to inflict an order on the ... the logical db has no concept of concurrent updates & queries. ... UPDATE LEDGER ... It permits another transaction to ...
    (comp.databases.theory)
  • Re: CLOS and databases
    ... you get a transaction for every write no ... It also depends on whether you want to be able to rollback object changes. ... (setf object (make-instance 'persistent-user-class)) ... These are some of the fun problems persistence framework guys get to fight ...
    (comp.lang.lisp)
  • Re: Oracle JDBC XA question
    ... > an XAConnection from an XADataSource, get the XAresource and call ... > transaction even if I've not committed the tx? ... Your scheme would force the DBMS to support two separate ...
    (comp.lang.java.programmer)