1 Reply Latest reply on Jul 29, 2002 9:55 PM by Mike Brown

    JBoss.NET and MS .NET interop

    Rocky Burt Newbie

      bruce, thanks a lot. i am lazy so just downloaded your build with tomcat and it works.

      the HelloEJB app came up.

      however, it seems that there is some differences in setting up MySQL database
      between your build (jboss-3.1.0alpha_tomcat-4.0.4.zip) and the one i was using before (jboss-3.0.1RC1_tomcat-4.0.4.zip)

      whatever i had set up before with MySQL (which worked fine) no longer works. i am wondering if there is an additional step that is needed
      for your build to set up MySQL as a datasource (java:/DefaultDS).

      thanks,

      --john

      i only changed the mysql-service.xml file, dropped it in deploy,

      and changed the java:/DefaultDS reference from Hypersonic SQL to MySqlDS in
      MySqlDS.

      now i am getting this strange exception in servlets:
      javax.ejb.EJBException: ejbFindInRange: Table not found: SAVINGSACCOUNT in statement [select id from savingsaccount where balance between 0.00 and 990000.00]

      these are the only changes i have made to make MySQL work before:

      [conf]# diff standardjaws.xml ../../default/conf
      17c17
      < <type-mapping>MySqlDS</type-mapping>
      ---
      > <type-mapping>Hypersonic SQL</type-mapping>
      [conf]# diff standardjbosscmp-jdbc.xml ../../default/conf
      16c16
      < <datasource-mapping>MySqlDS</datasource-mapping>
      ---
      > <datasource-mapping>Hypersonic SQL</datasource-mapping>


      [jboss]# diff -w ./docs/examples/jca/mysql-service.xml ./server/all/deploy/mysql-service.xml
      50c50
      < <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://dell:3306/jbossdb</config-property>
      ---
      > <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://testserver3306/test</config-property>
      53,54c53,54
      < <config-property name="UserName" type="java.lang.String"></config-property>
      < <config-property name="Password" type="java.lang.String"></config-property>
      ---
      > <config-property name="UserName" type="java.lang.String">testuser</config-property>> <config-property name="Password" type="java.lang.String">testpassword</config-property>

        • 1. Re: JBoss.NET and MS .NET interop
          Mike Brown Newbie

          I only have MS.NET talking to JBoss3.0.0 via a stand-alone AXIS-server (beta3). From my very limited experiences so far, this seems to work the best.

          Yes, this is not optimal and this does require more steps and code, but since both AXIS and JBoss.NET are still betas (and good developers never release with betas (wink, wink)), it's a good way to play and understand until gold.

          As for working with complexTypes, I've had good success. Working with example5 from AXIS-beta3's samples helped a lot.

          Best of Luck,
          Mike