Jump to content
Changes to the Jaspersoft community edition download ×

Not able to get all fields using mongodb jdbc sql query in TIBCO 7.1


varun_5

Recommended Posts

Following is the quuery that I am running in the dataset query tab: 

SELECT * FROM "database"."table"  
WHERE "duration"=201680

 

Following is stack trace: 

 

net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query:

SELECT * FROM "database"."table"  
WHERE "duration"=201680


    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:528)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:297)
    at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:68)
    at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:70)
    at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:487)
    at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:49)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: java.sql.SQLSyntaxErrorException: [TibcoSoftware][MongoDB JDBC Driver][MongoDB]syntax error or access rule violation: column not found: DURATION
    at tibcosoftware.jdbc.mongodbbase.ddcl.b(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddcl.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddck.b(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddck.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbcloud.ddq.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbcloud.ddu.d(Unknown Source)
    at tibcosoftware.jdbc.mongodbcloud.ddu.g(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.dddc.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.dddt.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddez.b(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.dddt.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.ddt.a(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.BaseConnection.prepareStatement(Unknown Source)
    at tibcosoftware.jdbc.mongodbbase.BaseConnection.prepareStatement(Unknown Source)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:384)
    ... 6 more
Caused by: tibcosoftware.mongodbcloud.sql.ddai: syntax error or access rule violation: column not found: DURATION
    at tibcosoftware.mongodbcloud.sql.error.dda.a(Unknown Source)
    at tibcosoftware.mongodbcloud.sql.ddbm.a(Unknown Source)
    ... 16 more

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...