I thing this is the best solution. When can we get it :-)??? I am working with interbase - there you can define updatable views, too. But this is not the best way...
Regards, Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] Im > Auftrag von Luca Fossato > Gesendet: Mittwoch, 16. Oktober 2002 14:27 > An: dbforms-interest mailing list > Betreff: [dbforms] proposal: Pluggable events system > > > Hi, > > I resolved my "view -> parent table" problems. > I had think about a "general solution"; the best one could be > a pluggable events > system. > > Here's why: > to switch between my view and the related table to obtain a > successfull delete > operation (choose the record from the view, delete it from > its original table)*, > I modified the DeleteEvent class. > The modification I did is (IMHO) too much related to the > application I'm > developing, so I cannot return a contribution back to the > dbforms community. > > The best thing to do (IMHO) is to provide a system where a > developer can write > its own event classes and then configure dbforms to: > > a) set up the default event classes > b) override those settings for a particular table > > For example, the configuration file of the Jakarta Struts > framework defines a set of global forward elements that can > be used by all the defined actions. Any action can define its > forward elements, and those elements can ovverride the > elements defined into the global-forwards section. > > So, the dbforms-config file could be extended in this manner: > > ------------------------------------------------------- > > <?xml version="1.0" encoding="ISO-8859-1" ?> > > <dbforms-config> > > <date-format>dd/MM/yyyy</date-format> > > <!-- table configuration --> > <table name="MYTABLE1"> > <field name="MYID" fieldType="int" size="8" isKey="true"/> > ... > > <!-- the related interceptor --> > <interceptor className = "my.interceptors.MyInterceptorClass"/> > > <!-- custom events used by this table --> > <events> > <!-- override the insert event using my own class --> > <event type="insert" class="my.events.CustomInsertEvent" /> > </events> > </table> > > <!-- this table will use the default event classes --> > <table name="MYTABLE2"> > <field name="MYID2" fieldType="int" size="8" isKey="true"/> > ... > </table> > > ... > > <!-- > - default event classes > - > - see org.dbforms.event.EventEngine class src > - for the list of supported events > --> > <events> > <event type="insert" class="org.dbforms.event.InsertEvent" /> > <event type="delete" class="org.dbforms.event.DeleteEvent" /> > ... > </events> > > > <!-- > - well, the preview of the configuration of > - [multiple connection + connectionProvider] > - system > --> > <dbconnection > id = "jakarta-commons-dbcp" > isJndi = "false" > isPow2 = "true" > defaultConnection = "true" > connectionProviderClass = "com.pow2.dao.JakartaConnectionProvider" > connectionPoolURL = "" > conClass = "org.postgresql.Driver" > name = > "jdbc:postgresql://myhost/mydb?charSet=ISO-8859-1" > username = "postgres" > password = ""/> > > </dbforms-config> > > ------------------------------------------------------- > > > [*] > At the moment I'm using Postgresql, and it's possible to > define rules to get "updatable views". But to do that, > postgresql uses its own non sql-92 > extensions... > > > > Any comment ? > > Thank you, > Luca > > > > ------------------------------------------------------- > This sf.net email is sponsored by: viaVerio will pay you up > to $1,000 for every account that you consolidate with us. > http://ad.doubleclick.net/clk;4749864;7604308;> v? > http://www.viaverio.com/consolidator/osdn.cfm _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms ------------------------------------------------------- This sf.net email is sponsored by: viaVerio will pay you up to $1,000 for every account that you consolidate with us. http://ad.doubleclick.net/clk;4749864;7604308;v? http://www.viaverio.com/consolidator/osdn.cfm _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
