AW: [dbforms] Database refresh problem SOLVED

[Daniel.Feinauer]

Title: Nachricht

SQL Navigator was holding a write lock on the specific table entries while his changes were not committed. 

Unfortunalety, dbforms didn't generate an error message (not even a timeout), but only hanged when trying to access such a locked entry.

 

cheers,

Daniel

 

 -----Ursprüngliche Nachricht-----
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>