Nukes with MS-SQL

[arin_12]

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

[zgibek]

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.

[arin_12]

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

[zgibek]

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

[manutrium]

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