Connecting to local SQL
0
Hi I am trying to connect to a SQL database from Mendix application. I have created a new and empty database and providign configurations in the Project->setttings->configuration. On runnng locally, assuming it will happily create tables and everything, i get below error.Any help? An error occurred while initializing the Runtime -------- com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime at com.mendix.basis.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:509) Caused by: java.util.NoSuchElementException: Either.right.value on Left at scala.util.Either$RightProjection.get(Either.scala:453) at com.mendix.connectionbus.connections.jdbc.implementations.sqlserver.SqlServerDataStoreConfigurator.createDefaultDataSource(SqlServerDataStoreConfigurator.java:91) at com.mendix.connectionbus.connections.jdbc.implementations.sqlserver.SqlServerDataStoreConfigurator.createDataSource(SqlServerDataStoreConfigurator.java:116) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreConfigurator.initialize(JdbcDataStoreConfigurator.java:61) at com.mendix.connectionbus.connections.jdbc.ConnectionManager.<init>(ConnectionManager.java:29) at com.mendix.connectionbus.ConnectionBusImpl.initialize(ConnectionBusImpl.java:284) at com.mendix.basis.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:486) at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:315) at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:272) at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:50) at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:31) at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:122) 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.headerComplete(AbstractHttpConnection.java:942) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1004) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:647) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) 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:748)
asked
Shefali Bedi
4 answers
1
Normally, you just set the SQL database host name like this. If you have defined database instances, you may need to append that (like JUPITER\InstanceName)
answered
David Sanders
0
It looks like your database settings are incorrect. What did you specify?
answered
Andrej Koelewijn
0
Hi Andrej,
1. installed SQL server, created an empty database, 'defaulttest''
2. Created one user ''mendixuser'' in the new database in SQL.
3. Opened mendix modeler, in configuration mentioned below settings and ran locally.
answered
Shefali Bedi
0
The above is true. You don't need a "URL" just the machine name\Instancename as long as it is local or on the network.
answered
Greg Sprowles