Anyone successfully implement a custom bean data source in advanced report center?
I was planning to implement a bean to query the LSCS production runtime database using the OOTB restful API... marshaling the xml into java beans and using this as a data source in report center to run custom reports against our production livesite content.
I did try simply creating a bean data source in the repository, and added my bean class and and a "service" class that returns a collection of said beans...dropping those on the classpath of adv report center...
But the connection test fails...
Log files reveal the following:
14:36:51,952 DEBUG DefaultListableBeanFactory,http-0.0.0.0-8080-3:338 - No bean named 'lscs.teamsite.reporting.TestFactory' found in org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [propertyConfigurer,contextApplicationContextProvider,sessionFactory,hibernateCompositeDeleteListener,hibernateCompositeInterceptor,hibernateCompositeSaveOrUpdateListener,metadataRepositoryDeleteListener,userAuthorityDeleteListener,transactionManager,objectFactory,mappingResourceFactory,persistentMappings,hibernateRepositoryService,addRepositoryListener,validatorMappings,baseResourceValidator,reportUnitValidator,defaultResourceValidator,folderValidator,servletContextInformation,hibernateRepoServiceTransactionInterceptor,internalRepositoryService,unsecureRepositoryService,repositoryService,beanForInterfaceFactory,dataSourceServiceFactories,dataSourceObjectPoolFactory,dbcpJdbcDataSourceFactory,jdbcDataSourceServiceFactory,jndiJdbcDataSourceServiceFactory,beanDataSourceServiceFactory,customDataSourceServiceFactory,hibernateRepositoryCacheBean,hibernateRepositoryCacheTransactionInterceptor,hibernateRepositoryCacheReattemptInterceptor,hibernateRepositoryCache,engineService,profileAttributeServiceTarget,profileAttributeService,userAuthorityServiceTarget,userAuthorityServiceTransactionInterceptor,userAuthorityService,internalUserAuthorityService,tenantServiceTarget,tenantServiceTransactionInterceptor,hibernateTenantService,tenantService,objectPermissionServiceTarget,cacheManager,aclCache,objectPermissionServiceTransactionInterceptor,objectPermissionService,objectPermissionServiceInternal,objectPermissionsRepositoryListener,com.jaspersoft.jasperserver.api.metadata.common.service.ResourceEventListenerProcessor,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater,objectPermissionsUserAuthorityDeleteListener,messageSource,messagesCalendarFormatProvider,engineCacheDeleteListener,com.jaspersoft.jasperserver.api.metadata.common.service.ResourceEventListenerProcessor#1,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#1,securityContextProviderTarget,securityContextProvider,hyperlinkDateParameterFormatter,encodingProvider,characterEncodingFilter,jasperPrintAccessor,baseReportExecutionHyperlinkProducer,reportExecutionHyperlinkProducer,localPageHyperlinkProducerFactory,localAnchorHyperlinkProducerFactory,viewReportHyperlinkProducerFactory,swfReportExecutionHyperlinkProducer,swfReportHyperlinkProducerFactory,collatorFactory,configurationBean,fileVirtualizerFactory,jpivot-resources,addHibernateConfig,mapClientClass,mapRepoClass,addMessageCatalog,mapDataSources,xlsExportParameters,csvExportParameters,pdfExportParameters,formatPatternsMap,localePdfFontMap,userTimeZonesList,roleManagerService,standardUserPersistenceHandler,dataSetCache,easyXMLizedRepository,adhocEasyXMLizer,adhocUnifiedStateTemplate,tableIEngine,crosstabIEngine,chartIEngine,dashboardIEngine,baseDataStrategy,classicDataStrategy,commonDomainDataStrategy,domainDataStrategy,sqlQueryDataStrategy,adhocEngineService,adhocHelper,com.jaspersoft.commons.datarator.jr.QEFactorySupport,setCustomAdhocProps,setDebugPath,formulaFactory,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#2,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#3,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#4,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#5,customAuthFilter,customUserDetailsFilter,dataSource,deployStatisticsDataSource,licContr,licHandlerMapping,licParamResolver,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#6,JILicenseFilter,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#7,licenseBean,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#8,hibernateLoggingService,loggingService,logPurgerJob,logPurgerTrigger,heartbeatBean,heartbeatJob,heartbeatTrigger,maintenanceScheduler,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#1,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#2,heartbeatProContributor,i18nMondrianAspect,hibernateRepositoryServiceProxy,mtTenantService,multiTenancyRepositoryService,repositoryPathTransformer,pathTransformer,tenantUriPathTransformer,userMultiTenancyContextProvider,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#3,hibernateRepositoryServiceProxyForAclUpdate,multiTenancyRepositoryServiceForAclUpdate,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#4,objectPermissionServiceMTInterceptor,objectPathTransformer,resourceLookupTransformer,genericResourceTransformer,fileResourceTransformer,semanticLayerDataSourceTransformer,folderTransformer,resourceReferenceTransformer,internalURITransformer,objectPermissionTransformer,reportOptionsLookupTransformer,reportJobTransformer,reportSummaryJobTransformer,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#9,mtRepositorySecurityChecker,com.jaspersoft.jasperserver.api.common.util.spring.BeanDefinitionOverrider,mtRepositoryCache,internalEngineService,internalCacheableCompiledReports,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#5,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#6,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#7,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#8,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#9,threadMultiTenancyContextProvider,multiTenancyContextProviderChain,threadContextRepositoryPathTransformer,threadContextObjectPathTransformer,threadContextPathTransformer,threadContextRepositoryServiceTarget,threadContextRepositoryService,threadContextRepositoryCache,threadContextReportCompiler,multiTenancyRepositoryContextManager,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#10,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#11,mtJobPersistenceService,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#12,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#13,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyMapAppender,multiTenancyConfiguration,mtDaoAuthenticationProvider,com.jaspersoft.jasperserver.api.common.util.spring.BeanReferenceOverrider,mtAuthenticationProcessingFilter,com.jaspersoft.jasperserver.api.common.util.spring.BeanReferenceOverrider#1,multiTenancyServiceTransactionInterceptor,multiTenancyFacade,multiTenancyService,tenantAction,mtHibernateRepositoryService,mtUnsecureRepositoryService,replaceForMTAuthentication,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#10,internalMultiTenancyFacade,internalMultiTenancyService,mtPortletAuthenticationProcessingFilter,replaceForMTPortletAuthenticationProcessingFilter,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#11,mtBasicProcessingFilter,replaceForMTBasicFilter,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#12,mtPasswordExpirationProcessingFilter,replaceForMTPasswordExpirationProcessingFilter,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#13,mtUserPreferencesFilter,replaceForMTUserPreferencesFilter,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#14,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#15,multiTenancyUserPersistenceHandler,com.jaspersoft.jasperserver.api.common.util.spring.BeanReferenceOverrider#2,tenantDefaultUsers,mtReportExecutionHyperlinkProducer,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyMapAppender#1,mtSwfReportExecutionHyperlinkProducer,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyMapAppender#2,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#14,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#15,mtUserAuthorityServiceTarget,userAuthoritySecurity,userAuthorityAccessDecisionManager,baseTenantObjectVoter,roleAccessVoter,roleWriteVoter,userAccessVoter,userWriteVoter,tenantSecurityProvider,multiTenancyAfterInvocationManager,multiTenancyAfterInvocationProvider,mtAcegiSecurityContextProvider,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#16,mtLoginAsUserDetailsService,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#16,multiTenancyreportJobAclDao,com.jaspersoft.jasperserver.api.common.util.spring.BeanReferenceOverrider#3,tenantEffectiveAclsResolver,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#17,olapConnectionService,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyListAppender,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyMapAppender#3,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyMapAppender#4,xmlaUpdateListener,jpivotRepositoryFilter,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#17,proReportSchedulerServiceImpl,proReportSchedulerService,proReportJobBeanTraslator,com.jaspersoft.jasperserver.api.common.util.spring.BeanReferenceOverrider#4,profilingSessionFactory,profilingRecorder,profilingAspect,reportOptionsFacade,reportOptionsServiceTxInterceptor,reportOptionsService,reportOptionsInternalFacade,reportOptionsUnsecureFacade,reportOptionsInternalService,reportOptionsUnsecureService,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyListAppender#1,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyListAppender#2,reportOptionsJobsPersistenceHibernateService,reportOptionsJobSecurity,reportOptionsJobsPersistenceService,reportOptionsSchedulingFacade,reportOptionsSchedulingService,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#18,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyMapAppender#5,schedulingReportOptionsDeleteListener,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyOverrider#19,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#18,proReportJobValidator,reportOptionsRepositoryListener,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#19,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#20,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#21,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#22,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#23,reportJobsPersistenceHibernateService,reportJobsPersistenceTransactionInterceptor,reportJobsPersistenceService,reportSchedulerMailSender,quartzScheduler,schedulerReportExecutionHyperlinkProducer,reportQuartzScheduler,reportScheduler,defaultReportJobValidator,reportSchedulingFacade,reportSchedulingServiceTransactionInterceptor,reportSchedulingService,schedulingReportDeleteListener,schedulingReportDeleteListenerRegisterer,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#24,quartzSchedulerControl,reportJobAclDao,reportJobAclProvider,reportJobUpdateVoter,reportJobDeletionVoter,reportJobLoadVoter,reportJobAccessDecisionManager,reportJobAclManager,reportJobAfterList,reportJobAfterInvocationManager,reportJobSecurity,reportJobAclCache,reportJobAclEntryCache,jobXlsExportParameters,jobCsvExportParameters,jobPdfExportParameters,jobExportParametersMap,contentResourceURIResolver,defaultWebDeploymentInformation,hibernateReportJobsUserDeleteListener,filterChainProxy,insertFilter,authenticationManager,daoAuthenticationProvider,passwordEncoder,anonymousProcessingFilter,anonymousAuthenticationProvider,JIAuthenticationSynchronizer,loggerListener,userLocalesList,userPreferencesFilter,basicProcessingFilter,portletAuthenticationProcessingFilter,passwordExpirationProcessingFilter,basicAuthExceptionTranslationFilter,basicProcessingFilterEntryPoint,authenticationProcessingFilter,requestParameterAuthenticationFilter,authenticationProcessingFilterEntryPoint,httpSessionContextIntegrationFilter,exceptionTranslationFilter,httpRequestAccessDecisionManager,requestMethodsFilter,roleVoter,filterInvocationInterceptor,setRolesForURL,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#25,switchUserProcessingFilter,SimpleAclEntry.ADMINISTRATION,SimpleAclEntry.READ_WRITE,SimpleAclEntry.READ,SimpleAclEntry.DELETE,aclUserAdminVoter,aclUserReadVoter,aclUserUpdateVoter,aclUserDeleteVoter,aclAccessDecisionManager,aclManager,hibernateRepoServiceSecurity,repositoryServiceMethodSecurity,afterInvocationManager,afterInvocationManagerForUpdate,afterAclCollectionRead,afterAclRead,afterAclCollectionUpdate,customEditorConfigurer,flowAclManager,flowVoter,flowAccessDecisionManager,flowExecuterSecurity,checkAclUpdateInterceptor,securityCheckerForAclUpdate,internalRepositoryServiceSecurityChecker,repositoryServiceSecurityChecker,aclUpdateMethodSecurityInterceptor,repositoryServiceForAclUpdate,aclUserMoveVoter,aclUserCopyVoter,aclUserMultiCopyVoter,com.jaspersoft.jasperserver.api.common.util.spring.BeanPropertyTextAppender,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#26,org.springframework.beans.factory.config.CustomEditorConfigurer,semanticLayerFactory,groovyRunner,schemaTemplate,jdbcTableTemplate,sqlGeneratorFactory,defaultSQLGenerator,oracleSQLGenerator,postgreSQLGenerator,db2SQLGenerator,sqlserverGenerator,jdbcQueryTemplate,jrQueryTemplate,memoryDataSetTemplate,nullDataSetTemplate,joinedDataSetRefTemplate,dataSetRefTemplate,dataSetExpressionEvaluator,expressionEvaluator,objectTypeMapper,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#27,jdbcDataSetFactory,hibernateDataSetFactory,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#28,semanticLayerDataSourceServiceFactory,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#29,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#30,com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater#31,metaDataFactoryFactory,jdbcMetaConfiguration,jdbcMetaDataFactory,jndiJdbcMetaDataFactory,domainMetaDataFactory,domainXMLValidator,domainValidator,domainServicesService,dataSourceTreeDataProvider,slConfig,managementServiceConfiguration,resourceHandlerRegistry,addWSResourceHandler,reportSchedulerServiceAccessor,reportSchedulerServiceImpl,webServiceExceptionAdvice,reportSchedulerService,reportJobBeanTraslator,wsMessageCodesResolver]; root of BeanFactory hierarchy
Docs don't reveal much about how to do this... have consulted JasperServer docs, but still trying to figure this out....
I think my "service" bean possibly needs to be configured in the report center config files and/or implement some kind of Jasper interface, or extend Jasper class....
