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" %>
<%@ taglib uri="/WEB-INF/c.tld" prefix="c" %>
[...]
tableName="mytable"
maxRows="*"
autoUpdate="true" //same problem without autoUpdate
followUp="/content/.../show.jsp"
>
[...]
<db:body>
<tr>
<td>
<db:updateButton caption="u"/> <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>
<tr>
<td>
<db:updateButton caption="u"/> <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>
