Hi All,
We are getting the below error while adding an oracle database from add datasources in One web app. we give jdbc connection string, username and password(doesnt matter/validate if it is right password/username). Please check and let me know how can i troubleshoot/debug the issue. Some browser component is throwing the error.
jdbc - format - jdbc:oracle:thin:@<jdbcHost>:1521:<jdbcDatabaseName>
error when we try to connect the first time after a restart of one-tomcat service
java.lang.RuntimeException: java.lang.ExceptionInInitializerError
at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.retrieveConnectionWithTimeout(AbstractDatabaseDatasourceClient.java:119)
at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.handleRequest(AbstractDatabaseDatasourceClient.java:353)
at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.<init>(AbstractDatabaseDatasourceClient.java:92)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClient.<init>(OracleDatasourceClient.java:45)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClient$OracleDatasourceClientBuilder.build(OracleDatasourceClient.java:34)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClientFactory.createClient(OracleDatasourceClientFactory.java:58)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClientFactory.createClient(OracleDatasourceClientFactory.java:30)
at com.ataccama.one.browser.controllers.DatasourceConnectionTestController.testInstanceConnection(DatasourceConnectionTestController.java:89)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:849)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:760)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
error when we try to connect the second time after a restart of one-tomcat service
java.lang.RuntimeException: java.lang.NoClassDefFoundError: Could not initialize class oracle.net.nt.Clock
at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.retrieveConnectionWithTimeout(AbstractDatabaseDatasourceClient.java:119)
at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.handleRequest(AbstractDatabaseDatasourceClient.java:353)
at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.<init>(AbstractDatabaseDatasourceClient.java:92)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClient.<init>(OracleDatasourceClient.java:45)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClient$OracleDatasourceClientBuilder.build(OracleDatasourceClient.java:34)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClientFactory.createClient(OracleDatasourceClientFactory.java:58)
at com.ataccama.one.browser.database.oracle.OracleDatasourceClientFactory.createClient(OracleDatasourceClientFactory.java:30)
at com.ataccama.one.browser.controllers.DatasourceConnectionTestController.testInstanceConnection(DatasourceConnectionTestController.java:89)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:849)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:760)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
♀️