Select data from external database

1
Hello friends,   How can i use the DatabaseConnector module to select data from an external database. I'm using the execute query action but i got always this error. Can someone give me an example how to use execute query action and how exactely write the sql expression ?   Best, Omar.
asked
1 answers
0

This is what i get when trying to connect to my external database

 

An error has occurred while handling the request. [User 'MxAdmin' with session id '26f52ea0-6c01-4fd4-84c3-324dba5a08e8' and roles 'Administrator']

--------

com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "hikaricp.configurationFile" "read")
    at MyThirdModule.ACT_DataBaseConnection (JavaAction : 'Execute query')

Advanced stacktrace:
    at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:143)

Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "hikaricp.configurationFile" "read")
    at com.mendix.basis.component.InternalCore.execute(InternalCore.java:535)

Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "hikaricp.configurationFile" "read")
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:178)

Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "hikaricp.configurationFile" "read")
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37)

Caused by: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "hikaricp.configurationFile" "read")
    at java.security.AccessControlContext.checkPermission(AccessControlContext.java:472)
    at java.security.AccessController.checkPermission(AccessController.java:884)
    at java.lang.SecurityManager.checkPermission(SecurityManager.java:549)
    at java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1294)
    at java.lang.System.getProperty(System.java:717)
    at com.zaxxer.hikari.HikariConfig.<init>(HikariConfig.java:116)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:57)
    at databaseconnector.impl.JdbcConnectionManager.createHikariDataSource(JdbcConnectionManager.java:74)
    at databaseconnector.impl.JdbcConnectionManager.lambda$getConnection$0(JdbcConnectionManager.java:47)
    at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
    at databaseconnector.impl.JdbcConnectionManager.getConnection(JdbcConnectionManager.java:45)
    at databaseconnector.impl.JdbcConnector.executeQuery(JdbcConnector.java:80)
    at databaseconnector.impl.JdbcConnector.executeQuery(JdbcConnector.java:70)
    at databaseconnector.actions.ExecuteQuery.executeAction(ExecuteQuery.java:81)
    at databaseconnector.actions.ExecuteQuery.executeAction(ExecuteQuery.java:58)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)
    at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)
    at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)
    at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)
    at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:52)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:200)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)
    at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)
    at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)
    at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)
    at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:143)
    at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:307)
    at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)
    at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)
    at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)
    at com.mendix.basis.actionmanagement.IMonitoredAction$class.monitor(IMonitoredAction.scala:49)
    at com.mendix.webui.requesthandling.ClientRequestHandler$ClientMonitoredAction.monitor(ClientRequestHandler.scala:408)
    at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:293)
    at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:235)
    at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:202)
    at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:101)
    at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:93)
    at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40)
    at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:70)
    at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:67)
    at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)
    at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:73)
    at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:885)
    at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.handle(RuntimeHandler.java:41)
    at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    at org.eclipse.jetty.server.Server.handle(Server.java:368)
    at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
    at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)
    at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
    at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
    at java.lang.Thread.run(Thread.java:745)
 

answered