Reports.Java 2017.1.11 + MongoDB

[s.wieczorek]

Hi,
Is there a possibility of connecting java reports to MongoDB?

[Vadim]

Hello.
No, you can use only next types:

[s.wieczorek]

Thank you. In that case i'm trying to use third party JDBC to MongoDB connection solution (http://www.unityjdbc.com).
JDBC Driver class name: mongodb.jdbc.MongoDriver
URL format: jdbc:mongo://<serverName>/<databaseName>
I'm getting the following error(tried with "jdbc:mongo://localhost:27010/EPBP" and "mongo://localhost:27010/EPBP") :

In connection options '{jdbc:mongo://localhost:27010/EPBP=}' not found 'driver name' com.stimulsoft.report.dictionary.adapters.StiAbstractAdapter.validation(StiAbstractAdapter.java:136) com.stimulsoft.report.dictionary.adapters.StiJdbcAdapter.getJdbcParameters(StiJdbcAdapter.java:23) com.stimulsoft.webdesigner.helper.StiDictionaryHelper.testConnection(StiDictionaryHelper.java:2724) com.stimulsoft.webdesigner.StiWebDesignerCommands.commandResult(StiWebDesignerCommands.java:642) com.stimulsoft.webdesigner.StiWebDesignerActions.processRequestResult(StiWebDesignerActions.java:154) com.stimulsoft.webdesigner.StiWebDesignerActions.designerEventResult(StiWebDesignerActions.java:93) com.stimulsoft.webdesigner.servlet.StiWebDesignerActionServlet.processing(StiWebDesignerActionServlet.java:65) com.stimulsoft.webdesigner.servlet.StiWebDesignerActionServlet.doPost(StiWebDesignerActionServlet.java:46) javax.servlet.http.HttpServlet.service(HttpServlet.java:648) javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

[s.wieczorek]

I think i've found a solution myself. The entry for a jdbc datasource (from within a designer) has to be provided with a following way:

jdbc.username=;jdbc.password=;jdbc.url=jdbc:mongodb://localhost:27010/EPBP;jdbc.driverclassname=mongodb.jdbc.MongoDriver


Lookin at you demo from https://designer.stimulsoft.com it has a possibility to connect to MongoDB. Can you tell me what implementation is it under(.net?)?

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

[s.wieczorek]

Please take a look at my attachment. On https://designer.stimulsoft.com you have a possibility to add a MongoDB datasource. I'm asking what exactly product do i need to have to have this connection. I guess it is not Reports.Java nor Reports.JS. What is it?

[Alex K.]

Hello,

It is HTML5 designer from Web APS.NET product.

Thank you.

[s.wieczorek]

Thank you. How can i connect to my local mongo server from this demo site? I've tried to put url mongodb://localhost:27010/EPBP but got nothing shown. Also example does not fill in (after clicking on 'field configuration description' button).

Also when i try to test the connection i've got an error popped up (please see an attachment). Note that i work on linux machine

[Alex K.]

Hello,

Please clarify which product and which designer are you use?

Thank you.

[s.wieczorek]

My project is written in Java but is based on microservice architecture (so i can use other technologies). I need to connect to MongoDB somehow. But stimulsoft java designer doesn't have a possibility to connect to it. That's why i am trying Report.JS (with OData - few drawbacks already - no complex types) and also trying demo.stimulsoft.com which based on ASP.NET (according to your post). But when tried to connect to my local DB from it i had the following 'dll' error (see my previous post).