Thanks Ashok !
I finally got things working using Tyrex and PostgreSQL. Just had to recompile JDBC
driver.
Here is my tyrex setup if it can help someone with Postgres :
<domain>
<name>mytyrex_domain</name>
<maximum>50</maximum>
<timeout>120</timeout>
<resources>
<dataSource>
<name>mtx_db_tx</name>
<jar>/usr/local/jakarta/tomcat/common/lib/postgresql.jar</jar>
<class>org.postgresql.PostgresqlDataSource</class>
<config>
<user>foo</user>
<password>bar</password>
<serverName>localhost</serverName>
<portNumber>5432</portNumber>
<databaseName>slide</databaseName>
</config>
<limits>
<maximum>50</maximum>
<minimum>5</minimum>
<initial>5</initial>
<maxRetain>300</maxRetain>
<timeout>10</timeout>
</limits>
</dataSource>
</resources>
</domain>
I will test your new database schema as soon I will have time.
Where can I find the last version ?
Cheers
Jp
Kumar, Ashok wrote:
>Hi All and Jacob
>
>This is in regard to the numerous discussions on J2EE with TC417. Now we have got
>the latest SLIDE 2 from cvs working with Tomcat 417 beta version. The DB Pool
>deployment which we have done, uses Tyrex 1.0 and not Commons-dbcp-pools. So the
>explanation given below is based on the Tyrex based approach.
>NOTE: I have the implementation based on the new J2EE database schema proposed by me
>to the list. But this should work also for the J2EE store based on the default schema
>also. Also Slide is deployed as a webapp under tomcat.
>
>Steps for Tyrex configuration
>-----------------------------
>Step1:
> Get the Tyrex1.0 version for http://tyrex.exolab.org/
>The following jars are needed in addition to Tyrex namely
>tyrex-1.0.jar
>ots-jts_1.0.jar
>jta_1.0.1.jar
>xerces-J_1.4.0.jar
>Castore .92 or above
>Log4j
>The above details are present in
>http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html
>for the tyrex based implementtion.
>
>Step2:
>The real database definition has now been moved out of the server.xml which was the
>case with the TC40 version and old tyrex. This entries are now in a seperate xml file
>and this has to be deployed in the web-inf/classes of the web app concerned. In our
>case it is the Slide web-inf
>
><domain>
><name>mytyrex_domain</name>
> <!-- Limit to 50 concurrent transactions -->
> <maximum>50</maximum>
> <!-- Default transaction timeout: 2 minutes -->
> <timeout>120</timeout>
> <resources>
> <!-- Specification for data source myDb -->
> <dataSource>
> <name>mtx_db_tx</name>
> <jar>http://localhost/path/JSQLConnect.jar</jar>
> <class>com.jnetdirect.jsql.JSQLXADataSource</class>
> <config>
> <!-- Configuration for XADataSource -->
> <user>myuser</user>
> <password>mypwd</password>
> <serverName>localhost</serverName>
> <portNumber>1433</portNumber>
> <database>my_database</database>
> <logfile>/test.log</logfile>
> </config>
> <limits>
> <!-- Start with 5 connections, never go below 5,
> and never go above 50 -->
> <maximum>50</maximum>
> <minimum>5</minimum>
> <initial>5</initial>
> <!-- Discard connections idle for 5 minutes -->
> <maxRetain>300</maxRetain>
> <!-- If maximum reached, block for 10 seconds -->
> <timeout>10</timeout>
> </limits>
> </dataSource>
> </resources>
></domain>
>
>Step3:
>
>The tag <jar> has to be a valid url which tyrex expects. But the DBjar file need not
>be present in that location.It can be at its usual place in tomcat common/lib.
>Somehow tyrex insists things this way. The JSQLCOnnect which we used was 2.27
>version. The older version has serious issues on XADatasource implementation. The 2
>tags( <name>) will be reffered to in the tomcat server.xml and also the name of the
>above xml
>
>Given below is the entry in the server.xml.
>
> <Context path="/slide" docBase="slide" debug="0" privileged="true">
> <Environment name="tyrexDomainConfig" type="java.lang.String"
>value="mytyrexconfig.xml"/>
> <Environment name="tyrexDomainName" type="java.lang.String"
>value="mytyrex_domain"/>
> <Resource name="jdbc/my_db" auth="Container"
>type="tyrex.resource.Resource"/>
> <ResourceParams name="jdbc/my_db">
> <parameter>
> <name>name</name>
> <value>mtx_db_tx</value>
> </parameter>
> </ResourceParams>
> </Context>
>The above entry is specfic to Slide.
>
>Changes required in web.xml of Slide for working with TC417.
>------------------------------------------------------------
>STEP4:
>
>The XML dTd definition has to be 2.3 based;
><?xml version="1.0" encoding="ISO-8859-1"?>
><!DOCTYPE web-app
> PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
> "http://java.sun.com/dtd/web-app_2_3.dtd";>
>
>Step5:
>There has been changes in the role based security configuration for TC417
>Normally Slide will have the roles user,root and guest mentioned under
>security-constraint in web.xml.
>Now for each of this roles we need the following entries also
> <security-role>
> <role-name>root</role-name>
> </security-role>
> <security-role>
> <role-name>guest</role-name>
> </security-role>
> <security-role>
> <role-name>user</role-name>
> </security-role>
>This above entries have to be in the web.xml after the login-config entries (due to
>dtd restrictions)
>
>With all this steps I have the Slide now working with TC417 + Tyrex.
>
>Jacob as U mentioned in one of the previous mails about some modifications, which U
>tried out to my new database schema proposal, if u can pass on the info I could also
>try them out. As U might have experienced , I prefer to stick to the new DB design as
>it is a nice performer.
>Hope this helps all.
>
>Ashok
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
