[Tyrex-users] Error - Tyrex & Mysql.. Please help

[Chen H. B. <hau...@dh...>]

Hi, I am chen

I am using tyrex for trasaction of Mysql database (4.0).=20

I have follow Tomcat 4.1x documentation to configure the setup, but I =
faced some problem.
The error message from Tomcat as below:


Starting Tyrex  Version 1.0
Intalio Inc. (C) 1999-2001. All rights reserved.

TyrexResourceFactory:  Cannot create Tyrex Resource, Exception
java.lang.NullPointerException
        at =
org.apache.naming.factory.TyrexResourceFactory.getObjectInstance(Tyre
xResourceFactory.java:140)
        at =
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceF
actory.java:186)


Server.xml
          <Environment name=3D"tyrexDomainConfig" =
type=3D"java.lang.String" value=3D"domain.xml"/>
          <Environment name=3D"tyrexDomainName" =
type=3D"java.lang.String" value=3D"myDomain"/>

          <Resource name=3D"my-datasource" auth=3D"Container" =
type=3D"tyrex.resource.Resource"/>
          <ResourceParams name=3D"my-datasource">
            =
<parameter><name>name</name><value>myDataSource</value></parameter>
          </ResourceParams>

domain.xml

<domain>
  <name>myDomain</name>
  <maximum>50</maximum>
  <timeout>120</timeout>
  <resources>
    <dataSource>
      <name>myDatasource</name>
      =
<jar>C:/jakarta-tomcat-4.1.18-1/common/lib/mm.mysql-2.0.14-bin.jar</jar>
      <class>org.gjt.mm.mysql.jdbc2.optional.MysqlXaDataSource</class>
      <config>
        <user>root</user>
        <password></password>
        <serverName>dhl-pc5</serverName>
        <port>3306</port>
        <database>innodbtest</database>
      </config>
      <limits>
        <maximum>50</maximum>
        <minimum>5</minimum>
        <initial>5</initial>
        <maxRetain>300</maxRetain>
        <timeout>20</timeout>
      </limits>
    </dataSource>
  </resources>
</domain>


2nd Question:

I have compare Tyrex and Tomcat documentation as below:
The configuration for domain.xml in

Tyrex:

      <config>
        <!-- Configuration for SybXADataSource -->
        <user>arkin</user>
        <password>secret</password>
        <serverName>tyrex.exolab.org</serverName>
        <postNumber>4100</portNumber>
      </config>

Tomcat :=20

      <config>
        <user>david</user>
        <password>secret</password>
        <serverName>localhost</serverName>
        <port>3306</port>
        <database>daviddb</database>
      </config>

In Tomcat additional tag <database>daviddb</database> found, but the =
server to exception. The error message
as=20
"org.apache.jasper.JasperException: Exception creating Tyrex Resource: =
Could not create TransactionDomain: unable to find FieldDescriptor for =
'database' in ClassDescriptor of mysqlXaDataSource"

should I i use <database> tag?

or wrong version of jars?

Please help.. : ).


regards,
hauboon