Ask for help on how to resolve the adapter

[erdengk]

I encountered this problem when I tried to add the mentioned adapter.330

I tried to use stacktrace or Google to solve this problem, but I tried for about 2 days and still couldn't solve it, so I asked for help.

Can you help me solve this problem? Thanks a lot.

@nilshansen94 @vogti

This is stacktrace and screenshot:

10:11:57.316 ERROR [qtp770985864-116]: Caught exception while executing a query from the console
 org.polypheny.db.webui.Crud$QueryExecutionException: The adapter does not specify a mode which is necessary.
	at org.polypheny.db.webui.Crud.executeSqlUpdate(Crud.java:3900) ~[webui-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.webui.Crud.executeSqlUpdate(Crud.java:3878) ~[webui-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.webui.Crud.anySqlQuery(Crud.java:847) ~[webui-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.webui.crud.LanguageCrud.anyQuery(LanguageCrud.java:104) ~[webui-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.webui.WebSocket.onMessage(WebSocket.java:108) ~[webui-1.0-SNAPSHOT.jar:?]
	at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) [javalin-4.1.1.jar:4.1.1]
	at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) [javalin-4.1.1.jar:4.1.1]
	at io.javalin.websocket.WsConnection.tryBeforeAndEndpointHandlers(WsConnection.kt:71) [javalin-4.1.1.jar:4.1.1]
	at io.javalin.websocket.WsConnection.onMessage(WsConnection.kt:38) [javalin-4.1.1.jar:4.1.1]
	at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source) ~[?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_302]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_302]
	at org.eclipse.jetty.websocket.common.events.annotated.CallableMethod.call(CallableMethod.java:70) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.events.annotated.OptionalSessionCallableMethod.call(OptionalSessionCallableMethod.java:68) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextMessage(JettyAnnotatedEventDriver.java:301) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.message.SimpleTextMessage.messageComplete(SimpleTextMessage.java:69) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.appendMessage(AbstractEventDriver.java:67) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextFrame(JettyAnnotatedEventDriver.java:287) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:152) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:148) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:111) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:169) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:90) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:459) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:440) [websocket-common-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [jetty-io-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-io-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) [jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) [jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) [jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) [jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) [jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) [jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) [jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_302]
Caused by: java.lang.RuntimeException: The adapter does not specify a mode which is necessary.
	at org.polypheny.db.adapter.AdapterManager.addAdapter(AdapterManager.java:201) ~[core-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.ddl.DdlManagerImpl.addAdapter(DdlManagerImpl.java:215) ~[classes/:?]
	at org.polypheny.db.sql.sql.ddl.SqlAlterAdaptersAdd.execute(SqlAlterAdaptersAdd.java:93) ~[sql-language-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.processing.Processor.getResult(Processor.java:75) ~[core-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.processing.Processor.prepareDdl(Processor.java:59) ~[core-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.webui.Crud.processQuery(Crud.java:3857) ~[webui-1.0-SNAPSHOT.jar:?]
	at org.polypheny.db.webui.Crud.executeSqlUpdate(Crud.java:3886) ~[webui-1.0-SNAPSHOT.jar:?]
	... 39 more
Caused by: java.lang.RuntimeException: The adapter does not specify a mode which is necessary.

[vogti]

Hi @erdengk
As stated in the error message, you need to specify a deployment mode. The correct query would be:
ALTER ADAPTERS ADD "test" USING 'org.polypheny.db.adapter.file.FileStore' WITH '{"mode":"embedded"}'

Our documentation on the website is not yet covering this part. However, I recommend simply deploying the adapter using the Polypheny-UI.

The idea of the SQL commands is to allow scripting the deployment of adapters. There is also a trick to easily get the required query: Simply click on the </> in the success message, and you find the query in your clipboard.

[erdengk]

Thank you for your guidance. I will continue to try to solve this problem.