Experience the OTLBC Life...



2024-04-29 13:56:24 902 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(security,char),convert(status,char),convert(roles,char) from dform_module where name = 'home'

2024-04-29 13:56:24 903 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - id=141

2024-04-29 13:56:24 909 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2024-04-29 13:56:24 909 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2024-04-29 13:56:24 910 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2024-04-29 13:56:24 910 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2024-04-29 13:56:24 911 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2024-04-29 13:56:24 911 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2024-04-29 13:56:24 912 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2024-04-29 13:56:24 912 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2024-04-29 13:56:24 918 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(header,char),convert(header,char),convert(header,char) from dform_pagetemplate where recordid=44

2024-04-29 13:56:24 922 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(javascript,char),convert(css,char),convert(header,char) from dform_sitethemes where type='website'

2024-04-29 13:56:24 923 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2024-04-29 13:56:24 924 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2024-04-29 13:56:24 925 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2024-04-29 13:56:24 925 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2024-04-29 13:56:24 948 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select LeftColor from dform_otlbcheadcolor where recordid=1

2024-04-29 13:56:24 948 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select RightColor from dform_otlbcheadcolor where recordid=1

2024-04-29 13:56:24 969 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select m.title, case m.contenturl when '' then case when m.page='None' then '#' else concat('/otlbc/home/',m.Page) end else concat('/otlbc/home/',m.ContentURL,'.do?id=',substring_index(m.contentid,'<',1)) end,n.title, case n.contenturl when '' then concat('',n.title,'') else concat('',n.title,'') end,case when n.title is null then '' else '' end,case when n.title is null then '' else '' end,case when n.title is null then '' else '