Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PGX3.2.0 -> cannot find loader exception

mohanr.kFeb 25 2019 — edited Aug 20 2020

I have PGX3.2.0 installed on  machine and the same machine (Windows) has cytoscape 3.7.1 installed. I see below exception when I run PGQL queries from cytoscape

INFO: Starting ProtocolHandler ["http-nio-7007"]

17:48:07,209 ERROR AbstractExceptionMapper - exception mapper caught exception w

ith code PGX-ERROR-217DLY663TADM

java.util.concurrent.ExecutionException: java.lang.UnsupportedOperationException

: cannot find loader; this distribution of PGX does not support reading from the

given data source; given config is {"max_num_connections":2,"format":"pg","load

ing":{"load_edge_label":true,"create_edge_id_mapping":true},"vertex_id_type":"lo

ng","db_engine":"RDBMS","username":"scott","error_handling":{},"name":"TEST_DA

TA","vertex_props":[{"type":"string","name":"uid"}],"edge_label":true,"password

":"*******","jdbc_url":"jdbc:oracle:thin:@localhost:1521/pgdb","edge_props":[{"ty

pe":"string","name":"label","default":" "},{"type":"double","name":"weight","def

ault":100.0}],"attributes":{}}

        at java.util.concurrent.CompletableFuture.reportGet(Unknown Source) ~[?:

1.8.0_201]

        at java.util.concurrent.CompletableFuture.get(Unknown Source) ~[?:1.8.0_

201]

        at oracle.pgx.api.PgxFuture.get(PgxFuture.java:99) ~[pgx-api-3.2.0.jar:3

.2.0]

        at oracle.pgx.rest.PgxFutureWrapper.getAsJson(PgxFutureWrapper.java:66)

~[classes/:?]

        at oracle.pgx.rest.EndpointUtils.checkHttpMethod(EndpointUtils.java:233)

~[classes/:?]

        at oracle.pgx.rest.endpoints.FutureResource.getFuture(FutureResource.jav

a:100) ~[classes/:?]

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0

_201]

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0

_201]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1

.8.0_201]

        at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_201]

        at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHa

ndlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:76) ~[j

ersey-server-2.26.jar:?]

        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethod

Dispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:148) ~[jersey-server-

2.26.jar:?]

        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethod

Dispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:191) ~[jersey-server

-2.26.jar:?]

        at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatch

erProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.ja

va:200) ~[jersey-server-2.26.jar:?]

        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethod

Dispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:103) ~[jersey-serv

er-2.26.jar:?]

        at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(Resour

ceMethodInvoker.java:493) ~[jersey-server-2.26.jar:?]

        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resourc

eMethodInvoker.java:415) ~[jersey-server-2.26.jar:?]

        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Resourc

eMethodInvoker.java:104) ~[jersey-server-2.26.jar:?]

        at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:27

7) [jersey-server-2.26.jar:?]

        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:272) [jersey-

common-2.26.jar:?]

        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:268) [jersey-

common-2.26.jar:?]

        at org.glassfish.jersey.internal.Errors.process(Errors.java:316) [jersey

-common-2.26.jar:?]

        at org.glassfish.jersey.internal.Errors.process(Errors.java:298) [jersey

-common-2.26.jar:?]

        at org.glassfish.jersey.internal.Errors.process(Errors.java:268) [jersey

-common-2.26.jar:?]

        at org.glassfish.jersey.process.internal.RequestScope.runInScope(Request

Scope.java:289) [jersey-common-2.26.jar:?]

        at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:

256) [jersey-server-2.26.jar:?]

        at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHand

ler.java:703) [jersey-server-2.26.jar:?]

        at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.ja

va:416) [jersey-container-servlet-core-2.26.jar:?]

        at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:3

70) [jersey-container-servlet-core-2.26.jar:?]

        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContaine

r.java:389) [jersey-container-servlet-core-2.26.jar:?]

        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContaine

r.java:342) [jersey-container-servlet-core-2.26.jar:?]

        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContaine

r.java:229) [jersey-container-servlet-core-2.26.jar:?]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:231) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter

.java:43) [classes/:?]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at oracle.pgx.rest.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter

.java:43) [classes/:?]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServlet

Filter.java:71) [log4j-web-2.11.0.jar:2.11.0]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:193) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:166) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:199) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:96) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica

torBase.java:494) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:139) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:92) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:87) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:343) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java

:412) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig

ht.java:66) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract

Protocol.java:754) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo

int.java:1385) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas

e.java:49) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:

1.8.0_201]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?

:1.8.0_201]

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh

read.java:61) [tomcat-embed-core-9.0.8.jar:9.0.8]

        at java.lang.Thread.run(Unknown Source) [?:1.8.0_201]

Caused by: java.lang.UnsupportedOperationException: cannot find loader; this dis

tribution of PGX does not support reading from the given data source; given conf

ig is {"max_num_connections":2,"format":"pg","loading":{"load_edge_label":true,"

create_edge_id_mapping":true},"vertex_id_type":"long","db_engine":"RDBMS","usern

ame":"infodba","error_handling":{},"name":"FORD_DATA","vertex_props":[{"type":"s

tring","name":"puid"}],"edge_label":true,"password":"*******","jdbc_url":"jdbc:o

racle:thin:@trv6s311:1521/pgdb","edge_props":[{"type":"string","name":"label","d

efault":" "},{"type":"double","name":"weight","default":100.0}],"attributes":{}}

        at oracle.pgx.loaders.api.GraphIo.findFacade(GraphIo.java:95) ~[pgx-load

er_api-3.2.0.jar:3.2.0]

        at oracle.pgx.engine.persistence.PersistenceManager.getLoader(Persistenc

eManager.java:111) ~[pgx-engine-3.2.0.jar:3.2.0]

        at oracle.pgx.engine.persistence.PersistenceManager.readGraph(Persistenc

eManager.java:130) ~[pgx-engine-3.2.0.jar:3.2.0]

        at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersis

tenceImpl.java:481) ~[pgx-engine-3.2.0.jar:3.2.0]

        at oracle.pgx.engine.CoreGraphPersistenceImpl$8$1.doCall(CoreGraphPersis

tenceImpl.java:474) ~[pgx-engine-3.2.0.jar:3.2.0]

        at oracle.pgx.engine.exec.Task.call(Task.java:320) ~[pgx-engine-3.2.0.ja

r:3.2.0]

        at oracle.pgx.engine.exec.Task.run(Task.java:236) ~[pgx-engine-3.2.0.jar

:3.2.0]

        at java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(Unknown

Source) ~[?:1.8.0_201]

        at java.util.concurrent.ForkJoinTask.doExec(Unknown Source) ~[?:1.8.0_20

1]

        at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(Unknown Source) ~

[?:1.8.0_201]

        at java.util.concurrent.ForkJoinPool.runWorker(Unknown Source) ~[?:1.8.0

_201]

        at java.util.concurrent.ForkJoinWorkerThread.run(Unknown Source) ~[?:1.8

.0_201]

This post has been answered by unknown-3038109 on Feb 26 2019
Jump to Answer
Comments
Post Details
Added on Feb 25 2019
6 comments
794 views