I have two test webapps, both of which use jsp pages and dbforms-config.xml generated by devgui. Both web.xml files are identical, copied from one of the examples and duplicated in each webapp. Each webapp has its own MySQL database (the failing one is alpine, the good one is fin, both on localhost at port 3306), accurately represented in the respective dbforms-config.xml files. I have tested the login using MySQL, it works. The sample pages are the "list" variety, which just spew out a list of the data in the table.
I verified that all jars in WEB-INF/lib are identical. Same version of the tag library is in force as well.
Differences that should not make a difference:
1. The app that does not work is a temporary deployment to a build directory. It seems to be finding the jsp page and the dbforms-config.xml files OK
2. The application that does not work is querying a table with 1500 rows. If the data size were too big, I would expect an error to that effect.
3. The application that does not work lacks the "single" jsp page. However, this is in a href tag, which means that the page not found error should not be thrown until a link is clicked.
Thanks in advance, Bill
Type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: No DbConnection object configured with name 'null'
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.IllegalArgumentException: No DbConnection object configured with name 'null'
org.dbforms.config.DbFormsConfig.getConnection(DbFormsConfig.java:447)
org.dbforms.taglib.DbFormTag.doStartTag(DbFormTag.java:2099)
org.apache.jsp.eperson_005flist_jsp._jspService(eperson_005flist_jsp.java:117)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
jsp page causing the error:
<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>
<% int i=0; %>
<html xmlns:db="http://www.wap-force.com/dbforms";>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<db:base/>
<title>List --- file: eperson_list.jsp</title>
<link rel="stylesheet" href="dbforms.css">
</head>
<body class="clsPageBody">
<table class="clsMainMenuTable" cellpadding="1" cellspacing="0" width="100%" border="0" align="center">
<tr>
<td>
<table class="clsMainMenuTable" cellpadding="3" cellspacing="0" width="100%" border="0">
<tr class="clsMainMenuTableRow">
<td><span class="clsMainMenu">eperson</span></td><td align="right" class="clsMainMenu"><a href="eperson_list.jsp" class="clsMainMenu">[List]</a><a href="menu.jsp" class="clsMainMenu">[Menu]</a><a href="logout.jsp" class="clsMainMenu">[Log out]</a></td>
</tr>
</table>
</td>
</tr>
</table>
<db:dbform tableName="eperson" maxRows="*" followUp="/eperson_list.jsp" autoUpdate="false" multipart="false" >
<db:header>
<db:errors/> <table align="center" >
<tr class="clsHeaderDataTableRow">
<td class="clsHeaderDataTableCell"><db:message key="f_key"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="person_id"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="firstname"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="lastname"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="prefname"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="position1"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="position2"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="alpine_status"></db:message></td>
<td class="clsHeaderDataTableCell"><db:message key="email"></db:message></td>
</tr>
</db:header>
<db:body allowNew="false">
<tr class="<%= (i++%2==0) ? "clsOddDataTableRow" : "clsEvenDataTableRow" %>"><td><a href="<db:linkURL href="/eperson_single.jsp" tableName="eperson" position="<%= position_eperson %>"/>" ><%= currentRow_eperson.get("f_key") %></a> </td>
<td><%= currentRow_eperson.get("person_id") %> </td>
<td><%= currentRow_eperson.get("firstname") %> </td>
<td><%= currentRow_eperson.get("lastname") %> </td>
<td><%= currentRow_eperson.get("prefname") %> </td>
<td><%= currentRow_eperson.get("position1") %> </td>
<td><%= currentRow_eperson.get("position2") %> </td>
<td><%= currentRow_eperson.get("alpine_status") %> </td>
<td><%= currentRow_eperson.get("email") %> </td>
</tr>
</db:body>
<db:footer></table> <center>
<hr width="400">
<db:navNewButton caption="Insert new ..." followUp="/eperson_single.jsp" styleClass="clsButtonStyle"></db:navNewButton>
</center>
</db:footer>
</db:dbform>
</body>
</html>
------------------------------------------- dbforms-config.xml in webapp causing the error
<?xml version="1.0" encoding="ISO-8859-1" ?>
<dbforms-config>
<date-format>yyyy-MM-dd</date-format>
<table name="categories"
defaultVisibleFields="category" >
<field name="category" fieldType="varchar" size="30"
isKey="true"/>
<field name="created" fieldType="datetime" size="19"/>
<field name="created_by" fieldType="varchar" size="30"/>
<field name="modified" fieldType="timestamp" size="14"/>
<field name="modified_by" fieldType="varchar" size="30"/><!-- add "granted-privileges" element for security constraints -->
</table>
<table name="ecommon"
defaultVisibleFields="f_key" >
<field name="f_key" fieldType="int" size="11" isKey="true"/>
<field name="f_name" fieldType="varchar" size="100"/>
<field name="f_title" fieldType="varchar" size="50"/>
<field name="f_first" fieldType="varchar" size="100"/>
<field name="f_last" fieldType="varchar" size="50"/>
<field name="f_suffix" fieldType="varchar" size="50"/>
<field name="addr_id" fieldType="varchar" size="20"
defaultValue="Main"/>
<field name="addr1" fieldType="varchar" size="60"/>
<field name="addr2" fieldType="varchar" size="60"/>
<field name="addr3" fieldType="varchar" size="60"/>
<field name="addr4" fieldType="varchar" size="60"/>
<field name="addr5" fieldType="varchar" size="60"/>
<field name="city" fieldType="varchar" size="60"/>
<field name="state" fieldType="varchar" size="20"/>
<field name="postal_code" fieldType="varchar" size="20"/>
<field name="phone_id" fieldType="varchar" size="60"/>
<field name="area_code" fieldType="varchar" size="10"/>
<field name="telno" fieldType="varchar" size="20"/>
<field name="position1" fieldType="varchar" size="50"/>
<field name="position2" fieldType="varchar" size="50"/>
<field name="email" fieldType="varchar" size="200"/>
<field name="creation_date_text" fieldType="varchar" size="20"/>
<field name="creation_comment" fieldType="varchar" size="100"/>
<field name="last_update_date" fieldType="varchar" size="20"/>
<field name="last_update_user" fieldType="varchar" size="50"/>
<field name="date_modified" fieldType="timestamp" size="14"/><!-- add "granted-privileges" element for security constraints -->
</table>
<table name="eperson"
defaultVisibleFields="person_id" >
<field name="f_key" fieldType="int" size="11"/>
<field name="person_id" fieldType="int" size="11" isKey="true"/>
<field name="firstname" fieldType="varchar" size="100"/>
<field name="lastname" fieldType="varchar" size="100"/>
<field name="prefname" fieldType="varchar" size="50"/>
<field name="position1" fieldType="varchar" size="50"/>
<field name="position2" fieldType="varchar" size="50"/>
<field name="alpine_status" fieldType="varchar" size="50"/>
<field name="email" fieldType="varchar" size="200"/><!-- add "granted-privileges" element for security constraints -->
</table>
<table name="everything">
<field name="last_name" fieldType="varchar" size="50"/>
<field name="first_name" fieldType="varchar" size="250"/>
<field name="contact_tel" fieldType="varchar" size="50"/>
<field name="key" fieldType="int" size="11" autoInc="true"/>
<field name="email" fieldType="varchar" size="250"/>
<field name="addr1" fieldType="varchar" size="50"/>
<field name="addr2" fieldType="varchar" size="50"/>
<field name="city" fieldType="varchar" size="50"/>
<field name="state" fieldType="varchar" size="50"/>
<field name="zip" fieldType="varchar" size="50"/>
<field name="country" fieldType="varchar" size="50"/>
<field name="date_modified" fieldType="timestamp" size="14"/><!-- add "granted-privileges" element for security constraints -->
</table>
<table name="imp_ecommon"
defaultVisibleFields="f_key" >
<field name="f_key" fieldType="int" size="11" isKey="true"/>
<field name="f_name" fieldType="varchar" size="100"/>
<field name="f_title" fieldType="varchar" size="50"/>
<field name="f_first" fieldType="varchar" size="100"/>
<field name="f_last" fieldType="varchar" size="50"/>
<field name="f_suffix" fieldType="varchar" size="50"/>
<field name="addr_id" fieldType="varchar" size="20"
defaultValue="Main"/>
<field name="addr1" fieldType="varchar" size="60"/>
<field name="addr2" fieldType="varchar" size="60"/>
<field name="addr3" fieldType="varchar" size="60"/>
<field name="addr4" fieldType="varchar" size="60"/>
<field name="addr5" fieldType="varchar" size="60"/>
<field name="city" fieldType="varchar" size="60"/>
<field name="state" fieldType="varchar" size="20"/>
<field name="postal_code" fieldType="varchar" size="20"/>
<field name="phone_id" fieldType="varchar" size="60"/>
<field name="area_code" fieldType="varchar" size="10"/>
<field name="telno" fieldType="varchar" size="20"/>
<field name="position1" fieldType="varchar" size="50"/>
<field name="position2" fieldType="varchar" size="50"/>
<field name="email" fieldType="varchar" size="200"/>
<field name="creation_date_text" fieldType="varchar" size="20"/>
<field name="creation_comment" fieldType="varchar" size="100"/>
<field name="last_update_date" fieldType="varchar" size="20"/>
<field name="last_update_user" fieldType="varchar" size="50"/>
<field name="date_modified" fieldType="timestamp" size="14"/><!-- add "granted-privileges" element for security constraints -->
</table>
<table name="imp_eperson"
defaultVisibleFields="person_id" >
<field name="f_key" fieldType="int" size="11"/>
<field name="person_id" fieldType="int" size="11" isKey="true"/>
<field name="firstname" fieldType="varchar" size="100"/>
<field name="lastname" fieldType="varchar" size="100"/>
<field name="prefname" fieldType="varchar" size="50"/>
<field name="position1" fieldType="varchar" size="50"/>
<field name="position2" fieldType="varchar" size="50"/>
<field name="alpine_status" fieldType="varchar" size="50"/>
<field name="email" fieldType="varchar" size="200"/><!-- add "granted-privileges" element for security constraints -->
</table>
<table name="import_log"
defaultVisibleFields="date_modified" >
<field name="date_modified" fieldType="timestamp" size="14" isKey="true"/>
<field name="file_on_disk" fieldType="varchar" size="250"/>
<field name="modified_by" fieldType="varchar" size="30"/>
<field name="family_count" fieldType="int" size="11"/>
<field name="person_count" fieldType="int" size="11"/>
<!-- add "granted-privileges" element for security constraints -->
</table>
<table name="requests"
defaultVisibleFields="request_id" >
<field name="request_id" fieldType="int" size="11" isKey="true" autoInc="true"/>
<field name="requestor_id" fieldType="int" size="11"/>
<field name="recipient_id" fieldType="int" size="11"/>
<field name="sensitivity" fieldType="int" size="11"/>
<field name="gender_specific" fieldType="enum" size="2" defaultValue="N"/>
<field name="request_summary" fieldType="varchar" size="80"/>
<field name="request_detail" fieldType="text" size="65535"/>
<field name="alert_age" fieldType="int" size="11"/>
<field name="status" fieldType="enum" size="7" defaultValue="Active"/>
<field name="created" fieldType="datetime" size="19"/>
<field name="created_by" fieldType="varchar" size="30"/>
<field name="modified" fieldType="timestamp" size="14"/>
<field name="modified_by" fieldType="varchar" size="30"/>
<!-- 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/alpine"
isJndi = "false"
conClass = "com.mysql.jdbc.Driver"
username = "MyUser"
password = "MyPassword"
/>
</dbforms-config>
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
