4 Replies Latest reply on Mar 28, 2005 6:54 AM by Emmanuel Lorge

    Nukes with MS-SQL

    Arindam Das Newbie

      Hi everyone,
      i am using nuke with jbos. And i am trying to connect to the SQL server.
      I hav build all the necessasry table.
      I am able to to login using the ADMIN and update his profile.

      But when i click the Manage html then it is showing the following exception, Please can some body tell me, How to solve.

      javax.ejb.FinderException: Find failed: java.sql.SQLException: [Microsoft][SQLSe
      rver 2000 Driver for JDBC][SQLServer]'LENGTH' is not a recognized function name.

      Thanks In advance

        • 1. Re: Nukes with MS-SQL
          Zbigniew Ogledzki Newbie

           


          javax.ejb.FinderException: Find failed: java.sql.SQLException: [Microsoft][SQLSe
          rver 2000 Driver for JDBC][SQLServer]'LENGTH' is not a recognized function name.


          Hi, I am not exactly sure, what your problem is, but maybe you didn't notice that mssql server has not function "length". I don't know also what for the function is used, but if it is used for determining the length of string you should change it to "len" for working in mssql.


          • 2. Re: Nukes with MS-SQL
            Arindam Das Newbie

            Please Can u tell me where to change change Length to Len. I has to use it for MS-SQL

            • 3. Re: Nukes with MS-SQL
              Zbigniew Ogledzki Newbie

              Sorry, but I don't know. I read only the error you have. :-(
              Normally this should be done in some desriptors. But I don't know nukes sources so good. I am not sure even if this is not enclosed in some source java code.
              I think you should grep in your sources to find it. Thats the way I would do it.
              Good luck
              --
              zgibek

              • 4. Re: Nukes with MS-SQL
                Emmanuel Lorge Newbie

                Hello,

                i think you have to change "LENGTH" by "LEN" in ejb files. (\org\jboss\nukes\core\ejb).
                The EJBs create sql requests using the descriptions you can find in "comments".
                i know that there is a sql request using "LENGTH" in FileEJB.java file but i don't know if it is the only file that contain it.

                Regards,

                Emmanuel Lorge