Solved

Getting one browser error while connecting to oracle database


Badge +1

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)
 

icon

Best answer by Cansu 7 March 2023, 10:59

View original

3 replies

Userlevel 6
Badge +7

Hi @maneelloyds welcome to the community!

May I ask if you can share your JDBC Connection String (with the sensitive parts masked), as the error message you have received seems to suggest the format of the supplied connection string contains some error. Thank you 🙋‍♀️

Badge +1

Hi @Cansu 

The jdbc connection string is fine and the same format works in a different environment

 

jdbc:oracle:thin:@//abcd.com:1521/xyz.com

the above is the format

 

Userlevel 6
Badge +7

Thank you for getting back to me @maneelloyds! Could you please raise a ticket for our support team? You can reach out to Ataccama Support via this link. 

Please don’t hesitate to let me know if I can help you with anything else.

Reply