giovanni.chiozza_1

Sorry but to query MongoDb from Ireport is not possible using SQL. The only way is to use MongoDbQuery within Ireport with its specific sintax. If it would be a sql DB the issue was not existing. Attached the json of that collection . If you are able to use SQL please let me no how. Thanks

Hello , I'm trying to understand how use MongoDb Query but syntax and concepts are not clear to me (I'm functional not developer). In this easy query I'm trying to show fields and also nested value into array fields . In this case containers.trackables.code { 'collectionName' : 'TrackDocument' , findFields : { 'docDate':1, 'docNumber':1, 'docStatus':1 , 'containers.trackables.code' : 1}, } I would like to see only the code and not all the mess of things into the container colum. How can achieve that ? For istance in first row I got two value 45500027 and 45500999 that would be the detail rows . I hope someone can help me because I'm very stuck.... Thanks

It seems strange because I'm using the identical string of connection that I use successfully with IReport 5.6 and there it works nicely. Please have a look to the attached image.

Hello, I'm trying to make connection to MongoDb from JasperStudio without success. The same identical connection used into IReport works nice. I'm really confused because I don't know what I would change. This is the error log but not being a programmers i don't understand almost nothing. The URI, User, Password are obviously correct. net.sf.jasperreports.engine.JRException: Error creating MongoDBConnection; Caused by: Cannot test MongoDB connection; Caused by: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='t4h', source='T4H-sample', password=<hidden>, mechanismProperties={}} at com.jaspersoft.mongodb.connection.MongoDbConnection.<init>(MongoDbConnection.java:86) at com.jaspersoft.mongodb.adapter.MongoDbDataAdapterService.createConnection(MongoDbDataAdapterService.java:70) at com.jaspersoft.mongodb.adapter.MongoDbDataAdapterService.test(MongoDbDataAdapterService.java:91) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:153) at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:50) at java.base/java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Cannot test MongoDB connection; Caused by: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='t4h', source='T4H-sample', password=<hidden>, mechanismProperties={}} at com.jaspersoft.mongodb.connection.MongoDbConnection.test(MongoDbConnection.java:192) at com.jaspersoft.mongodb.connection.MongoDbConnection.<init>(MongoDbConnection.java:82) ... 5 more Caused by: com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='t4h', source='T4H-sample', password=<hidden>, mechanismProperties={}} at com.mongodb.internal.connection.SaslAuthenticator.wrapException(SaslAuthenticator.java:173) at com.mongodb.internal.connection.SaslAuthenticator.access$300(SaslAuthenticator.java:40) at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:70) at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:47) at com.mongodb.internal.connection.SaslAuthenticator.doAsSubject(SaslAuthenticator.java:179) at com.mongodb.internal.connection.SaslAuthenticator.authenticate(SaslAuthenticator.java:47) at com.mongodb.internal.connection.InternalStreamConnectionInitializer.authenticateAll(InternalStreamConnectionInitializer.java:152) at com.mongodb.internal.connection.InternalStreamConnectionInitializer.initialize(InternalStreamConnectionInitializer.java:63) at com.mongodb.internal.connection.InternalStreamConnection.open(InternalStreamConnection.java:127) at com.mongodb.internal.connection.UsageTrackingInternalConnection.open(UsageTrackingInternalConnection.java:50) at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.open(DefaultConnectionPool.java:390) at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:106) at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:92) at com.mongodb.internal.connection.DefaultServer.getConnection(DefaultServer.java:85) at com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource.getConnection(ClusterBinding.java:115) at com.mongodb.client.internal.ClientSessionBinding$SessionBindingConnectionSource.getConnection(ClientSessionBinding.java:111) at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:212) at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:206) at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:116) at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:109) at com.mongodb.operation.CommandReadOperation.execute(CommandReadOperation.java:56) at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:179) at com.mongodb.client.internal.MongoDatabaseImpl.executeCommand(MongoDatabaseImpl.java:184) at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:153) at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:148) at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:138) at com.jaspersoft.mongodb.connection.MongoDbConnection.test(MongoDbConnection.java:187) ... 6 more Caused by: com.mongodb.MongoCommandException: Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server 10.18.192.88:27021. The full response is {"operationTime": {"$timestamp": {"t": 1686039755, "i": 1}}, "ok": 0.0, "errmsg": "Authentication failed.", "code": 18, "codeName": "AuthenticationFailed", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1686039755, "i": 1}}, "signature": {"hash": {"$binary": "AAAAAAAAAAAAAAAAAAAAAAAAAAA=", "$type": "00"}, "keyId": {"$numberLong": "0"}}}} at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:179) at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:299) at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255) at com.mongodb.internal.connection.CommandHelper.sendAndReceive(CommandHelper.java:83) at com.mongodb.internal.connection.CommandHelper.executeCommand(CommandHelper.java:33) at com.mongodb.internal.connection.SaslAuthenticator.sendSaslStart(SaslAuthenticator.java:130) at com.mongodb.internal.connection.SaslAuthenticator.access$100(SaslAuthenticator.java:40) at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:54) ... 30 more

Thanks so much !! I'll try asap

Hello, I'm trying to convert a MongoDb date (int 64) into a readable date . As you can see below I'm trying to use filter expression mini script but I'm not a programmer and probably I'm wronging something. Is there someone who can help me on this matter ? Thanks As sample I took creationDate field but there are many with same issue.

Hello, I'm trying to connect to a MongoDB to Jassper Report (6.20.0). This is what I wrote into URI : mongodb://cluster0.y09dxf4.mongodb.net:27017/sample_analytics The environment is that one of MongoDb samples on web This is the error details : net.sf.jasperreports.engine.JRException: Error creating MongoDBConnection; Caused by: Cannot test MongoDB connection; Caused by: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=cluster0.y09dxf4.mongodb.net:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketException: cluster0.y09dxf4.mongodb.net}, caused by {java.net.UnknownHostException: cluster0.y09dxf4.mongodb.net}}] at com.jaspersoft.mongodb.connection.MongoDbConnection.<init>(MongoDbConnection.java:86) at com.jaspersoft.mongodb.adapter.MongoDbDataAdapterService.createConnection(MongoDbDataAdapterService.java:70) at com.jaspersoft.mongodb.adapter.MongoDbDataAdapterService.test(MongoDbDataAdapterService.java:91) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:154) at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51) at java.base/java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Cannot test MongoDB connection; Caused by: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=cluster0.y09dxf4.mongodb.net:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketException: cluster0.y09dxf4.mongodb.net}, caused by {java.net.UnknownHostException: cluster0.y09dxf4.mongodb.net}}] at com.jaspersoft.mongodb.connection.MongoDbConnection.test(MongoDbConnection.java:192) at com.jaspersoft.mongodb.connection.MongoDbConnection.<init>(MongoDbConnection.java:82) ... 5 more Caused by: com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=cluster0.y09dxf4.mongodb.net:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketException: cluster0.y09dxf4.mongodb.net}, caused by {java.net.UnknownHostException: cluster0.y09dxf4.mongodb.net}}] at com.mongodb.internal.connection.BaseCluster.getDescription(BaseCluster.java:182) at com.mongodb.internal.connection.SingleServerCluster.getDescription(SingleServerCluster.java:41) at com.mongodb.client.internal.MongoClientDelegate.getConnectedClusterDescription(MongoClientDelegate.java:136) at com.mongodb.client.internal.MongoClientDelegate.createClientSession(MongoClientDelegate.java:94) at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.getClientSession(MongoClientDelegate.java:249) at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:172) at com.mongodb.client.internal.MongoDatabaseImpl.executeCommand(MongoDatabaseImpl.java:184) at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:153) at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:148) at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:138) at com.jaspersoft.mongodb.connection.MongoDbConnection.test(MongoDbConnection.java:187) ... 6 more

Hi all, I've connected Postgres DB and test was fine. The db is located on Docker. When I try to use Query designer I got the issue that I can't see any table and so to make queries I need to know all tables name... What have I to do in order to see the schema of Db and tables ? Thanks Gio

Thanks, but ... obvioustly ... it was a setting already I did but without success. I don't know why but icons remain always so small. JasperSoft studio has also the same kind of issue ?? I hope not.... otherwise really ugly

Hello to all, I did buy a new Asus notebook and it has a new generation screen resolution (max to 3840x2160). I tried to use IReport 5.6.0 but all icons , also choosing a lower resolution setting, remain almost not readable ... really really small . Also texts and menus have problems . I'm wondering what can I do in order to be able to use Ireport as on older PC . Thanks Giovanni

Hello , did you fix it ? I got same issue and here no answers.... ;-((