Hi PeterJ
Here is the sql statment passed in the parameter called sqlcommand
SELECT convert(varchar(12), pdl_site.last_updt_tmsp, 101) + " " +
convert(varchar(8), pdl_site.last_updt_tmsp, 108) + ":" + right("00" +
datename(ms,pdl_site.last_updt_tmsp), 3) last_updt_tmsp,
pdl_site.last_updt_usr, pdl_site.appl_version, pdl_site.default_archive_days,
pdl_site.default_fund_type, pdl_site.email_protocol, pdl_site.general_info,
pdl_site.license_key, pdl_site.id, pdl_site.password_expir_days,
pdl_site.reg_instr, pdl_site.smtp_account, pdl_site.smtp_host,
pdl_site.site_ip_addr, pdl_site.pd_version FROM pdl_site
this sql statment working for long time with the pervious sliverstream server
as is, now we are trying to migrate to JBOSS, it is no longer working.
You can see that, there are ":", "", "00" in the parameter names. The error
generated is the following:
Invalid column name ' '.
Invalid column name ':'.
Invalid column name '00'.
On the server console, the connection is open, data-source is fine, but the
above execute(sqlcommand) is returning false.
Best Regards
badam571
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4171891#4171891
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4171891
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
