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.
Please Can u tell me where to change change Length to Len. I has to use it for MS-SQL
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.
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.