Hi Henner,
Attached is the config and the generated jsp. The table name is bal_record.
Do you use an IDE to debug, or just use log statements?
It is failing on the getId, which is the statement after the table object
is retrieved. So, it appears that the table name is OK, that something is
finding enough of a Table object to return it, but then the NULL occurs
when getting the ID.
Thanks,
Bill
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Henner Kollmann
Sent: Sunday, April 25, 2004 1:08 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: AW: [dbforms] DevGui Generated Page vs testsuite page
>
> This url displays a page:
> http://www.tribley.org/testsuite/customer_list.jsp
>
> this url errors out at the getId call at DbFormsTag.java line
> 300 (details below):
> http://server/fintest/bal_record_viewTable.jsp
>
What's the name of your table in your page?
Could you debug inside the dbforms tag in the setName line and have a look
why the table is not found?
Could you send me your dbforms-config file?
Thanks,
Henner
<?xml version="1.0" encoding="ISO-8859-1" ?>
<dbforms-config>
<date-format>MM-dd-yyyy</date-format>
<table name="accounts"
defaultVisibleFields="account" >
<field name="account" fieldType="char" size="40" isKey="true"/>
<field name="description" fieldType="char" size="60"/>
<field name="category" fieldType="char" size="30"/>
<field name="budget" fieldType="char" size="30"/>
<field name="status" fieldType="char" size="2"/>
<field name="balance" fieldType="decimal" size="8"/>
<field name="bal_2002" fieldType="decimal" size="8"/>
<field name="bal_2001" fieldType="decimal" size="10"/>
<field name="bal_2000" fieldType="decimal" size="10"/>
<field name="bal_2003" fieldType="decimal" size="10"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="auto_acct_beginning"
defaultVisibleFields="text_beginning" >
<field name="text_beginning" fieldType="char" size="30" isKey="true"/>
<field name="account" fieldType="char" size="30"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="bal_reconcile"
defaultVisibleFields="adj_keynum" >
<field name="header_key" fieldType="char" size="20"/>
<field name="check_num" fieldType="int" size="11"/>
<field name="trans_type" fieldType="char" size="20"/>
<field name="trans_date" fieldType="datetime" size="19"/>
<field name="balance" fieldType="decimal" size="10"/>
<field name="debit" fieldType="decimal" size="10"/>
<field name="credit" fieldType="decimal" size="10"/>
<field name="description" fieldType="char" size="40"/>
<field name="period" fieldType="int" size="11"/>
<field name="account" fieldType="char" size="40"/>
<field name="unique_id" fieldType="char" size="40"/>
<field name="seq" fieldType="int" size="10"/>
<field name="trans_year" fieldType="int" size="11"/>
<field name="stat" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="keynum" fieldType="int" size="11"/>
<field name="adj_keynum" fieldType="int" size="11" isKey="true" autoInc="true"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="bal_record"
defaultVisibleFields="account,period,trans_year" >
<field name="trans_year" fieldType="int" size="11" isKey="true"/>
<field name="period" fieldType="int" size="11" isKey="true"/>
<field name="account" fieldType="char" size="40" isKey="true"/>
<field name="beginning" fieldType="decimal" size="10"/>
<field name="debits" fieldType="decimal" size="10"/>
<field name="credits" fieldType="decimal" size="10"/>
<field name="net_change" fieldType="decimal" size="10"/>
<field name="adj" fieldType="decimal" size="10"/>
<field name="ending" fieldType="decimal" size="10"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="budget_import"
defaultVisibleFields="category,year" >
<field name="year" fieldType="int" size="11" isKey="true"/>
<field name="category" fieldType="char" size="30" isKey="true"/>
<field name="p01" fieldType="decimal" size="8"/>
<field name="p02" fieldType="decimal" size="8"/>
<field name="p03" fieldType="decimal" size="8"/>
<field name="p04" fieldType="decimal" size="8"/>
<field name="p05" fieldType="decimal" size="8"/>
<field name="p06" fieldType="decimal" size="8"/>
<field name="p07" fieldType="decimal" size="8"/>
<field name="p08" fieldType="decimal" size="8"/>
<field name="p09" fieldType="decimal" size="8"/>
<field name="p10" fieldType="decimal" size="8"/>
<field name="p11" fieldType="decimal" size="8"/>
<field name="p12" fieldType="decimal" size="8"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="budget_raw">
<field name="category" fieldType="char" size="30"/>
<field name="p01" fieldType="decimal" size="8"/>
<field name="p02" fieldType="decimal" size="8"/>
<field name="p03" fieldType="decimal" size="8"/>
<field name="p04" fieldType="decimal" size="8"/>
<field name="p05" fieldType="decimal" size="8"/>
<field name="p06" fieldType="decimal" size="8"/>
<field name="p07" fieldType="decimal" size="8"/>
<field name="p08" fieldType="decimal" size="8"/>
<field name="p09" fieldType="decimal" size="8"/>
<field name="p10" fieldType="decimal" size="8"/>
<field name="p11" fieldType="decimal" size="8"/>
<field name="p12" fieldType="decimal" size="8"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="budget_rpt_omit"
defaultVisibleFields="budget" >
<field name="budget" fieldType="char" size="30" isKey="true"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="budget_targets"
defaultVisibleFields="category,period,year" >
<field name="category" fieldType="char" size="30" isKey="true"/>
<field name="year" fieldType="int" size="11" isKey="true"/>
<field name="period" fieldType="int" size="11" isKey="true"/>
<field name="balance" fieldType="decimal" size="8"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="category_report_order">
<field name="category" fieldType="varchar" size="20"/>
<field name="sort" fieldType="varchar" size="4"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="check_register"
defaultVisibleFields="check_num" >
<field name="check_num" fieldType="int" size="11" isKey="true"/>
<field name="check_date" fieldType="date" size="10"/>
<field name="amount" fieldType="decimal" size="11"/>
<field name="payee" fieldType="char" size="40"/>
<field name="note" fieldType="char" size="80"/>
<field name="account" fieldType="char" size="40"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="checking_import"
defaultVisibleFields="unique_id" >
<field name="header_key" fieldType="varchar" size="20"/>
<field name="check_num" fieldType="int" size="4"/>
<field name="trans_type" fieldType="varchar" size="20"/>
<field name="trans_date" fieldType="datetime" size="19"/>
<field name="balance" fieldType="decimal" size="10"/>
<field name="debit" fieldType="decimal" size="10"/>
<field name="credit" fieldType="decimal" size="10"/>
<field name="description" fieldType="varchar" size="120"/>
<field name="period" fieldType="int" size="11"/>
<field name="account" fieldType="varchar" size="40"/>
<field name="unique_id" fieldType="varchar" size="40" isKey="true"/>
<field name="stat" fieldType="varchar" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="credit_card_import"
defaultVisibleFields="unique_id" >
<field name="header_key" fieldType="varchar" size="20"/>
<field name="trans_type" fieldType="varchar" size="20"/>
<field name="trans_date" fieldType="datetime" size="19"/>
<field name="balance" fieldType="decimal" size="10"/>
<field name="debit" fieldType="decimal" size="10"/>
<field name="credit" fieldType="decimal" size="10"/>
<field name="description" fieldType="varchar" size="120"/>
<field name="period" fieldType="int" size="11"/>
<field name="account" fieldType="varchar" size="40"/>
<field name="unique_id" fieldType="varchar" size="40" isKey="true"/>
<field name="stat" fieldType="varchar" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="dave_acct">
<field name="unique_key" fieldType="int" size="11" autoInc="true"/>
<field name="Date" fieldType="date" size="10"/>
<field name="Description" fieldType="varchar" size="60"/>
<field name="Expense" fieldType="decimal" size="6"/>
<field name="Income" fieldType="decimal" size="6"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="header_import"
defaultVisibleFields="header_key" >
<field name="import_type" fieldType="char" size="20"/>
<field name="acct_id" fieldType="char" size="20"/>
<field name="header_key" fieldType="char" size="20" isKey="true"/>
<field name="date_from" fieldType="date" size="10"/>
<field name="date_to" fieldType="date" size="10"/>
<field name="ledger" fieldType="decimal" size="10"/>
<field name="sum_amount" fieldType="decimal" size="10"/>
<field name="sum_credit" fieldType="decimal" size="10"/>
<field name="sum_debit" fieldType="decimal" size="10"/>
<field name="balance_control" fieldType="decimal" size="10"/>
<field name="stat" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="headers"
defaultVisibleFields="header_key" >
<field name="import_type" fieldType="char" size="20"/>
<field name="acct_id" fieldType="char" size="20"/>
<field name="header_key" fieldType="char" size="20" isKey="true"/>
<field name="date_from" fieldType="date" size="10"/>
<field name="date_to" fieldType="date" size="10"/>
<field name="ledger" fieldType="decimal" size="10"/>
<field name="sum_amount" fieldType="decimal" size="10"/>
<field name="sum_credit" fieldType="decimal" size="10"/>
<field name="sum_debit" fieldType="decimal" size="10"/>
<field name="balance_control" fieldType="decimal" size="10"/>
<field name="stat" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="import2db_field"
defaultVisibleFields="import_label,import_method,import_type" >
<field name="import_method" fieldType="varchar" size="30" isKey="true"/>
<field name="import_type" fieldType="varchar" size="20" isKey="true"/>
<field name="import_label" fieldType="varchar" size="20" isKey="true"/>
<field name="db_field" fieldType="varchar" size="30"/>
<field name="stat" fieldType="varchar" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="import2hdr_field"
defaultVisibleFields="import_label,import_type" >
<field name="import_type" fieldType="char" size="20" isKey="true"/>
<field name="import_label" fieldType="char" size="20" isKey="true"/>
<field name="db_field" fieldType="char" size="30"/>
<field name="stat" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="import_ignore"
defaultVisibleFields="import_type,token" >
<field name="import_type" fieldType="char" size="20" isKey="true"/>
<field name="token" fieldType="char" size="30" isKey="true"/>
<field name="status" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="import_tokens"
defaultVisibleFields="import_label,import_method,import_type" >
<field name="import_type" fieldType="varchar" size="20" isKey="true"/>
<field name="import_label" fieldType="varchar" size="20" isKey="true"/>
<field name="import_method" fieldType="varchar" size="30" isKey="true"/>
<field name="token" fieldType="varchar" size="30"/>
<field name="stat" fieldType="varchar" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="import_trans_types"
defaultVisibleFields="file_trans_type,import_type" >
<field name="import_type" fieldType="char" size="20" isKey="true"/>
<field name="file_trans_type" fieldType="char" size="20" isKey="true"/>
<field name="db_trans_type" fieldType="char" size="20"/>
<field name="stat" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="import_type"
defaultVisibleFields="import_type" >
<field name="import_type" fieldType="char" size="20" isKey="true"/>
<field name="acct_id" fieldType="char" size="20"/>
<field name="description" fieldType="char" size="60"/>
<field name="import_table" fieldType="char" size="30"/>
<field name="import_header" fieldType="char" size="30"/>
<field name="contra_income" fieldType="char" size="20"/>
<field name="contra_expense" fieldType="char" size="20"/>
<field name="contra_asset" fieldType="char" size="20"/>
<field name="contra_liability" fieldType="char" size="20"/>
<field name="stat" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="test_trans"
defaultVisibleFields="seq,trans_type,unique_id" >
<field name="header_key" fieldType="char" size="20"/>
<field name="check_num" fieldType="int" size="11"/>
<field name="trans_type" fieldType="char" size="20" isKey="true"/>
<field name="trans_date" fieldType="datetime" size="19"/>
<field name="balance" fieldType="decimal" size="10"/>
<field name="debit" fieldType="decimal" size="10"/>
<field name="credit" fieldType="decimal" size="10"/>
<field name="description" fieldType="char" size="40"/>
<field name="period" fieldType="int" size="11"/>
<field name="account" fieldType="char" size="40"/>
<field name="unique_id" fieldType="char" size="40" isKey="true"/>
<field name="seq" fieldType="int" size="10" isKey="true"/>
<field name="stat" fieldType="char" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="transaction_types"
defaultVisibleFields="trans_type" >
<field name="trans_type" fieldType="char" size="20" isKey="true"/>
<field name="auto_acct_enabled" fieldType="tinyint" size="3"/>
<field name="description" fieldType="char" size="30"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="transactions"
defaultVisibleFields="keynum" >
<field name="header_key" fieldType="varchar" size="20"/>
<field name="check_num" fieldType="int" size="11"/>
<field name="trans_type" fieldType="varchar" size="20"/>
<field name="trans_date" fieldType="datetime" size="19"/>
<field name="balance" fieldType="decimal" size="10"/>
<field name="debit" fieldType="decimal" size="10"/>
<field name="credit" fieldType="decimal" size="10"/>
<field name="description" fieldType="varchar" size="120"/>
<field name="period" fieldType="int" size="11"/>
<field name="account" fieldType="varchar" size="40"/>
<field name="unique_id" fieldType="varchar" size="40"/>
<field name="seq" fieldType="int" size="10"/>
<field name="trans_year" fieldType="int" size="11"/>
<field name="stat" fieldType="varchar" size="10"/>
<field name="deleted" fieldType="char" size="2"/>
<field name="keynum" fieldType="int" size="11" isKey="true" autoInc="true"/>
<field name="modified" fieldType="timestamp" size="14"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<!-- ========== Connection =================================== -->
<!--
uncomment this if you have access to JNDI of an application server (see users guide for more info)
<dbconnection
name = "jdbc/dbformstest"
isJndi = "true"
/>
-->
<dbconnection
name = "jdbc:mysql://localhost:3306/fin/"
isJndi = "false"
conClass = "com.mysql.jdbc.Driver"
username = "bill"
password = "77mhei"
/>
</dbforms-config>
Title: View table --- file: bal_record_viewTable.jsp
<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>
<%int i=0;
boolean showSearchRow;
String sr = request.getParameter("showSearchRow");
if (sr == null)
showSearchRow = false;
else
showSearchRow = (new Boolean(sr)).booleanValue();
%>
">
<% if (showSearchRow) { %>
|
" size="10" class="clsInputStyle" > |
" checked value="and" class="clsInputStyle" >and |
|
" value="weak" size="10" class="clsInputStyle" > weak |
" value="or" class="clsInputStyle" >or |
|
|
" size="10" class="clsInputStyle" > |
" checked value="and" class="clsInputStyle" >and |
|
" value="weak" size="10" class="clsInputStyle" > weak |
" value="or" class="clsInputStyle" >or |
|
|
" size="10" class="clsInputStyle" > |
" checked value="and" class="clsInputStyle" >and |
|
" value="weak" size="10" class="clsInputStyle" > weak |
" value="or" class="clsInputStyle" >or |
|
|
|
|
|
|
|
|
|
<% } %>
">
|
" ><%= currentRow_bal_record.get("trans_year") %> |
<%= currentRow_bal_record.get("period") %> |
<%= currentRow_bal_record.get("account") %> |
<%= currentRow_bal_record.get("beginning") %> |
<%= currentRow_bal_record.get("debits") %> |
<%= currentRow_bal_record.get("credits") %> |
<%= currentRow_bal_record.get("net_change") %> |
<%= currentRow_bal_record.get("adj") %> |
<%= currentRow_bal_record.get("ending") %> |
<%= currentRow_bal_record.get("modified") %> |
" >![]() |
|
|
