AW: [dbforms] Database refresh problem

[Daniel.Feinauer]

Title: Nachricht

Yes, of course. That's why i tried several browsers and different webservers (!) So there can't be no cache. Neither on the client nor on the server.

 

cheers,

Daniel

 

-----Urspr�ngliche Nachricht-----
Von: Henner Kollmann [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 9. Mai 2005 16:52
An: Feinauer Daniel, TD-210
Betreff: AW: [dbforms] Database refresh problem

Have you refreshed the page? dbforms uses something like a cache if you only navigate trough your dataset.

Only refreshing of the page will refresh this cache.

 

Cheers,

Henner

---

Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED]
Gesendet: Montag, 9. Mai 2005 14:34
An: jdbforms-interest@lists.sourceforge.net
Betreff: [dbforms] Database refresh problem

Hi all,

 

I have an - in my eyes - strange problem with my dbforms-site:

 

I have a page show.jsp which shows me the content of an oracle table (source extract below).

It is also possible to make changes to the database table via dbforms.

If i enter a new value, make changes to an existing value or delete one, there's no problem. On all browser instances the changes are displayed.

But once i make any change to my database via SQL Navigator (add, change, delete) and not via dbforms, no browser recognizes the change.

I thought, dbforms could have the database in a kind of cache on the webserver, but i run my project from completely different webservers and with browsers on completely different machines. The do not have any temporary files in common.

 

So my question is:

Where the hell does dbforms get the content of the table from if not by an ordinary SELECT Statement. And if so, why does it not display the REAL contents of the table but only the changes made by itself?

How can it determine wether one row was inserted by itself or manually in SQL Navigator?

 

I hope anybody has an idea.

 

cheers,

 

Daniel

 

 

 

===

 

show.jsp:

 

<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>
<%@ taglib uri="/WEB-INF/c.tld" prefix="c" %>

 

[...]

 

<db:dbform
    tableName="mytable"
    maxRows="*"
    autoUpdate="true" //same problem without autoUpdate
    followUp="/content/.../show.jsp"
>

 

[...]

 

  <db:body>
    <tr>
     <td>
      <db:updateButton caption="u"/>&nbsp;<db:deleteButton caption="d" />
     </td>    
     <td><db:label fieldName="id"/></td>
     <td><db:textField fieldName="comments" size="40" maxlength="80" nullFieldValue=""/></td>
    </tr>
  </db:body>

 

[...]

 

===

 

dbforms-config.xml:

 

<dbforms-config>

 

[...]

    <table name="mytable">
        <field name="id" fieldType="char" isKey="true" autoInc="true" />
        <field name="comments" fieldType="char" />
    </table>    
        

    <dbconnection contextDataSource="(mydatabaseconnection)" />

 

</dbforms-config>