1 Reply Latest reply on Jul 5, 2002 10:16 AM by dsnyckers

    JAWS example with MS SQLServer

    dsnyckers

      Hi,

      I'm trying to get the jaws example working with a MS SQLServer but can't manage to get it working.
      I changed the following things :
      In the jaws.xml I replaced the original datasource and typemapping name with MSSQLDS
      Next I downloaded the mssql-service.xml file and copied it to my deploy dir under jboss\server\default\deploy
      After compiling the jaws example and copying the class.jar also to the above deploy dir, I keep getting the following error :

      11:18:35,261 INFO [EjbModule] Deploying ClassBean
      11:18:35,601 INFO [EjbModule] Remove JSR-77 EJB Module: jboss.management.single
      :J2EEApplication= ,J2EEServer=Single,j2eeType=EJBModule,name=class.jar
      11:18:35,642 ERROR [EjbModule] Initialization failed
      org.jboss.deployment.DeploymentException: Error in jaws.xml : type-mapping MSSQL
      DS not found
      at org.jboss.ejb.plugins.jaws.metadata.JawsApplicationMetaData.importXml
      (JawsApplicationMetaData.java:197)
      at org.jboss.ejb.plugins.jaws.metadata.JawsXmlFileLoader.load(JawsXmlFil
      eLoader.java:81)
      at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommandFactory.(JDBCCommand
      Factory.java:144)
      ...

      Does anybody have a clue what I doing wrong??

      Thanks in advance,
      Dave

        • 1. Re: JAWS example with MS SQLServer
          dsnyckers

          Nevermind

          I figured it all out. :)
          I was using the wrong type-mapping name in the first place.

          After that I also had to install the MS SQLServer driver from Microsoft and copied the 3 driver jar files to my deploy dir (jboss/server/default/lib).

          I also adapted the mssql-service.xml to use the correct login/password to connect to the sql server.

          And then it all worked just fine!