ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Marshall" <ch...@campsbayterrace.com>
Subject Re: Deploying gwt + iBatis + MySql via Tomcat
Date Wed, 23 Jul 2008 13:56:47 GMT
Thanks Richard,
I am going through the Tomcat 6 documentation to work it out right now!
Regards Chris

On 23/07/2008, Richard Yee <ryee@cruzio.com> 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
> >
> >
> >
>
>

Mime
View raw message