Thanks Richard, I am going through the Tomcat 6 documentation to work it out right now! Regards Chris
On 23/07/2008, Richard Yee <[EMAIL PROTECTED]> wrote: > Chris, > I would suggest using Tomcat connection pooling. I think that there is > documentation on the Tomcat site for setting it up. Doing so will give you > much better performance. You would access the connection pool via a JNDI > datasource in iBATIS. With the configuration that you have, it will take > about a second each time you access the database just to establish the > connection. > > -Richard > > > Chris Marshall wrote: > > This is not really an iBatis query, but I have little experience with > > deploying applications via Tomcat, and would like to find a url which > > will help. I have checked the JPetStore application and googled dozens > > of sites without success: > > The application works well in GWT hosted and browser mode, and the GWT > > client works fine via Tomcat. The problem is I don't know how to > > deploy the server side java code with iBatis and MySql and cannot find > > a suitable knowledge base: > > > > The Tomcat WEB-INF has web.xml and SqlMapConfig.xml files: > > > > apache-tomcat-6.0.10/webapps/myapp/WEB-INF/web.xml > > > apache-tomcat-6.0.10/webapps/myapp/WEB-INF/SqlMapConfig.xml > > > > where web.xml is: > > > > <?xml version="1.0" encoding="UTF-8"?> > > <web-app> > > <display-name>MyApp Web</display-name> > > <description>MyApp Web Application</description> > > <servlet> > > <servlet-name>MyAppService</servlet-name> > > > <servlet-class>net.cbtltd.server.MyAppServer</servlet-class> > > </servlet> > > > > <servlet-mapping> > > <servlet-name>MyAppService</servlet-name> > > <url-pattern>/MyAppService</url-pattern> > > </servlet-mapping> > > > > <description>MyApp</description> > > > > <resource-ref> > > <res-ref-name>jdbc/MyAppDb</res-ref-name> > > <res-type>javax.sql.DataSource</res-type> > > <res-auth>Container</res-auth> > > </resource-ref> > > > > </web-app> > > > > and SQLMapConfig.xml is: > > > > <?xml version="1.0" encoding="UTF-8" ?> > > <!DOCTYPE sqlMapConfig > > PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" > > "http://ibatis.apache.org/dtd/sql-map-config-2.dtd";> > > <sqlMapConfig> > > <settings useStatementNamespaces="true" /> > > <transactionManager type="JDBC" commitRequired="true"> > > <dataSource type="JNDI"> > > <property name="JDBC.Driver" > value="com.mysql.jdbc.Driver"/> > > <property name="JDBC.ConnectionURL" > > value="jdbc:mysql://localhost:3306/MyAppDb"/> > > <property name="JDBC.Username" value=""/> > > <property name="JDBC.Password" value=""/> > > </dataSource> > > </transactionManager> > > <!-- List the SQL Map XML files. --> > > <sqlMap resource="xml/account_SqlMap.xml"/> > > ................. > > </sqlMapConfig> > > > > The MyAppServer.jar is in the WEB-INF/lib subdirectory, and the > > SqlMap.xml files are in the WEB-INF/xml subdirectory (not in a jar) > > > > I am using the most recent versions of GWT, iBatis and MySql on > > Windows2000 Professional. > > > > Hope someone can point me in the right direction! > > > > Thanks, Chris Marshall > > > > > > > >
