Connect Atoti with MongoDB

[kiimot]

Hi! We are trying to connect a MongoDB database with Atoti but it doesn't work

We have carried out tests based on MongoDB and from other environments if we can connect (MongoDBCompass, DBeaver, Python locally, Python in Jupyter Lab...). But from Atoti we can't. We are using version 6.0.3 of MongoDB.

The imported drivers have also been checked and are correct. We have obtained them from the following page: https://unityjdbc.com/mongojdbc/mongo_jdbc_free.php

A MongoDB database has been created on another machine but it replicates the same error.

And finally, it has also been tested to make connections with Oracle and MySQL that have been successful.

Steps to reproduce

Actual Result

This is the error:
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.qfs.content.service.IContentService]: Factory method 'contentService' threw exception; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

I attach logs in case they help.
server.log

Expected Result

With this code snippet, we hope to be able to connect to the MongoDB database and extract data to feed the Atoti cube.

Environment

• atoti: 0.7.2
• Python: 3.10.8
• Operating System: Windows 10 Enterprise x64

Logs (if relevant)

[tibdex]

The java.lang.NoClassDefFoundError: jdk/net/ExtendedSocketOptions is a clue that some classes you need may be missing in https://pypi.org/project/jdk4py which is what atoti uses to execute its underlying Java process. Can you try installing another JDK 17 on your machine, set the ATOTI_JAVA_HOME to its path, and restart your session?

[kiimot]

Hi! We have reviewed what you have told us.

We have everything configured correctly as you say:

https://pypi.org/project/jdk4py

JDK 17.0.5

Variables de entorno

We have done everything you have indicated, the same error continues to appear

[rcolle]

Hi,
Could you please execute the following code to make sure of what is actually picked up by atoti?

import os
import atoti

print(os.environ["ATOTI_JAVA_HOME"])
print(atoti._get_java_executable_path.get_java_executable_path())

If these show the expected values, can you please upload the latest server logs with the issue now that the relevant JDK has been set?
Thanks!

[kiimot]

Hi! Yes, the values are as expected.

I attach the logs with updated JDK, the same issue still appears: server.log

Thank you very much for your time!

[tibdex]

The custom JDK made the first error (java.lang.NoClassDefFoundError: jdk/net/ExtendedSocketOptions) disappear but the main one remains the same: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set.

I've added this issue to our backlog but I can't tell when we'll have time to work on it. In the meantime, can you try backing your user content storage with another DB?

[mfabiani-av]

Hi @tibdex ,

there was a misunderstanding here with the developers at NTT Data: for the user_content_storage, they are going to use an Oracle database so it should be ok.
The plan is to use MongoDB to load data into the datastores (i.e. "JDBC source" in Java) instead of CSV. So if anything, we should test if atoti_sql works with MongoDB drivers.