OHDSI Home | Forums | Wiki | Github

Atlas & source table

Developers
#1

Hi,

I have a question when installing atlas as below:

how to fill in “source” and “source daemon” table since such information are required for initialization.

Thanks.
Min

#2

Hi Min - sorry about the lack of documentation on this particular topic. Hopefully this provides what you need. Please let me know if you run into any other issues or have additional questions not addressed by this new FAQ.

#3

Frank,

Thanks very much for your responding, I filled the source table following
the instructions you provided, however, I got another error is like below,
could you please give some hint on it? thanks a lot!

ERROR qtp1996397594-18 org.springframework.boot.context.web.ErrorPageFilter

    • Forwarding to error page from request [/IMEDSCN/vocabulary/info] due
      to exception [org.springframework.jdbc.CannotGetJdbcConnectionException:
      Could not get JDBC Connection; nested exception is java.sql.SQLException:
      No suitable driver found for jdbc:oracle:thin:IMEDSCN/imedscn@localhost
      :1521:cdb1]
      javax.servlet.ServletException:
      org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
      JDBC Connection; nested exception is java.sql.SQLException: No suitable
      driver found for jdbc:oracle:thin:IMEDSCN/imedscn@localhost:1521:cdb1
      at
      org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:397)
      at
      org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:381)
      at
      org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:344)
      at
      org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:221)
      at
      org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
      at
      org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
      at
      org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
      at
      org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at
      org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
      at
      org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:98)
      at
      org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at
      org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
      at
      org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
      at
      org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at
      org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
      at
      org.springframework.boot.context.web.ErrorPageFilter.doFilter(ErrorPageFilter.java:108)
      at
      org.springframework.boot.context.web.ErrorPageFilter.access$000(ErrorPageFilter.java:59)
      at
      org.springframework.boot.context.web.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:88)
      at
      org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at
      org.springframework.boot.context.web.ErrorPageFilter.doFilter(ErrorPageFilter.java:101)
      at
      org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
      at
      org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
      at
      org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
      at
      org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
      at
      org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
      at
      org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
      at
      org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
      at
      org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
      at
      org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
      at
      org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
      at
      org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
      at
      org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
      at org.eclipse.jetty.server.Server.handle(Server.java:497)
      at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
      at
      org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
      at
      org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
      at
      org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
      at
      org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
      at java.lang.Thread.run(Thread.java:745)
#4

So this looks like the driver you are using is unavailable. Specifically the oracle:thin driver. There are several drivers that are embedded with the WebAPI however oracle:thin is not one of them. The currently supported drivers are as follows:

supportedDrivers = new String[]{“org.postgresql.Driver”, “com.microsoft.sqlserver.jdbc.SQLServerDriver”, “oracle.jdbc.driver.OracleDriver”, “com.amazon.redshift.jdbc41.Driver”};

as shown in DataAccessConfig.java

Could you use the oracle.jdbc.driver.OracleDriver ?

#5

I will try it, thanks very much for your reply.

#6

very good!

#7

Old links above. This one may be more useful and up-to-date.

t