[opencms-dev] DB connect to unknown source (Sybase) - deploy on WebLogic

[Hung Nguyen]

Hi all,
We are geting a strange behavior of OpenCMS v8.0.4 deployed on WebLogic.
We are migrate OpenCMS to another App and DB server. The app is copied from
old running server to the new app server, and the DB is migrate from Oracle
on SPARC to Oracle on Intel x86. When we test with some user browsing
website, it work normally. But when we publish the website for public
access, WebLogic rapidly has stuck threads and failed with errors like
this:

GET /opencms/opencms/en/news/index.html HTTP/1.1
Accept: image/gif, image/jpeg, image/pjpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, appli
cation/x-ms-application, application/x-ms-xbap,
application/vnd.ms-xpsdocument, application/xaml+xml, */*
Referer: http://local.web.incom.com/opencms/opencms/index.html
Accept-Language: en-us
User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0;
.NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C;
.NET4.0E)
Accept-Encoding: gzip, deflate
Cookie: XXXX
Client_IP: 10.135.136.130
ECID-Context: XXXXXXXXX
Connection: Keep-Alive
X-WebLogic-KeepAliveSecs: 30
X-WebLogic-Request-ClusterInfo: true
x-weblogic-cluster-hash: XXXXXXXXXXXXXX

]", which is more than the configured time (StuckThreadMaxTime) of "600"
seconds. Stack trace:
        java.lang.Class.forName0(Native Method)
        java.lang.Class.forName(Class.java:171)
        weblogic.jdbc.sybasebase.ddv.c(Unknown Source)
        weblogic.jdbc.sybasebase.BaseDriver.connect(Unknown Source)
        java.sql.DriverManager.getConnection(DriverManager.java:582)
        java.sql.DriverManager.getConnection(DriverManager.java:207)

org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:96)

org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:227)

org.opencms.db.generic.CmsVfsDriver.readPropertyObjects(CmsVfsDriver.java:1955)

org.opencms.db.CmsDriverManager.readPropertyObjects(CmsDriverManager.java:7134)

org.opencms.db.CmsSecurityManager.readPropertyObjects(CmsSecurityManager.java:4528)
        org.opencms.file.CmsObject.readPropertyObjects(CmsObject.java:2730)

org.opencms.file.collectors.CmsPriorityDateResourceComparator.init(CmsPriorityDateResourceComparator.java:185)

org.opencms.file.collectors.CmsPriorityDateResourceComparator.create(CmsPriorityDateResourceComparator.java:97)

org.opencms.file.collectors.CmsPriorityDateResourceComparator.compare(CmsPriorityDateResourceComparator.java:120)

org.opencms.file.collectors.CmsPriorityDateResourceComparator.compare(CmsPriorityDateResourceComparator.java:50)
        java.util.Arrays.mergeSort(Arrays.java:1270)
        java.util.Arrays.mergeSort(Arrays.java:1281)
        java.util.Arrays.mergeSort(Arrays.java:1282)
        java.util.Arrays.mergeSort(Arrays.java:1281)
        java.util.Arrays.mergeSort(Arrays.java:1281)
        java.util.Arrays.mergeSort(Arrays.java:1282)
        java.util.Arrays.mergeSort(Arrays.java:1282)
        java.util.Arrays.mergeSort(Arrays.java:1282)
        java.util.Arrays.mergeSort(Arrays.java:1282)
        java.util.Arrays.mergeSort(Arrays.java:1282)
        java.util.Arrays.mergeSort(Arrays.java:1282)
        java.util.Arrays.sort(Arrays.java:1210)
        java.util.Collections.sort(Collections.java:157)

org.opencms.file.collectors.CmsPriorityResourceCollector.allInFolderPriorityDate(CmsPriorityResourceCollector.java:216)

org.opencms.file.collectors.CmsPriorityResourceCollector.getResults(CmsPriorityResourceCollector.java:171)

org.opencms.jsp.CmsJspTagContentLoad.init(CmsJspTagContentLoad.java:515)

org.opencms.jsp.CmsJspTagContentLoad.doStartTag(CmsJspTagContentLoad.java:228)

jsp_servlet._web_45_inf._jsp._online._system._modules._com_46_vietinbank_46_cardtemplate._pages.__listpaging._jspService(__listpaging.java:372)
        weblogic.servlet.jsp.JspBase.service(JspBase.java:34)

weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)

weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)

weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)

org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:188)

org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:163)
        org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:617)

org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:417)

org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:167)
        org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:902)
        org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:522)

org.opencms.loader.A_CmsXmlDocumentLoader.load(A_CmsXmlDocumentLoader.java:224)

org.opencms.loader.CmsXmlContentLoader.load(CmsXmlContentLoader.java:44)

org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1062)
        org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1598)
        org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)

weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3729)

weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
        weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
        weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

We do not have config to connect to any Sybase DB in opencms.properties.
So, please advice if there is somewhere maybe used to config DB connection
in OpenCMS, or why OpenCMS asked WebLogic to load Sybase DB driver.

Thank you very much!

Best Regards,
Hung
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20150123/6e9a09a1/attachment.htm>