Hi,
I have not been able to get dbforms and mysql to work together stably. I have a web app that is currently using IBM's cloudscape database. I built a mysql database that is a mirror of the cloudscape database. I then ran devgui against the mysql database to generate the dbformsConfig.xml settings.
I am using Tomcat 4.12 because I want to use its database poolmanager. I placed a copy of my web app into the webapps directory and I managed to connect my web app to the mysql database via Tomcat and a jndi. On the surface it looks like dbforms is working ok. I have a page that shows a list of items. If you select an item you go to another page that shows you a picture of that item with some data for that item along with the usual first, prev, next and last buttons. I can use those buttons to go through the list. But periodically, and I can't find a reason for this, I get the following exception thrown to the screen when I am navigating through the list item by item:
422352 [Ajp13Processor[8235][12]] DEBUG org.dbforms.util.DbConnection -
returning a connection:DbConnection =
name=jdbc:mysql://database.kbinternet.com/crlca,jndi=false,conClass=org.gjt
.mm.mysql.Driver,username=fred
java.sql.SQLException: Communication failure during handshake. Is there a
server running on database.kgbinternet.com:3306?
at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.Driver.connect(Unknown Source)
or
java.lang.IllegalArgumentException: Troubles in your DbForms config xml file: DbConnection not properly included - check manual!
at org.dbforms.taglib.DbFormTag.setPageContext(DbFormTag.java:427)
at org.apache.jsp.nonMemberTrade jsp. jspService(nonMemberTrade jsp.java:166)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
After these error I check that I can still connect to the database via the command line and it is still there. I can also call jsp pages that use struts to access the database and they work.
I tried to connect dbforms directly to the database skipping tomcat's poolmanager and jndi connection and I still got the above errors. The version of Mysql is 3.23.
I don't see how I can navigate through the list by selecting the 'next' button five times and then all of a sudden dbforms crashes.
Any help, suggestions is appreciated.
Alex
------------------------------------------------------------
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Ce courriel est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser imm�diatement, par retour de courriel ou par un autre moyen.
============================================================
