Package it.eng.spagobi.tools.datasource.metadata

Examples of it.eng.spagobi.tools.datasource.metadata.SbiDataSource

246
247
248
249
250
251
252
253
254
255
256
          aEngine.getId());
      SbiDomains hibDomainBiobjType = (SbiDomains) aSession.load(SbiDomains.class,
          aEngine.getBiobjTypeId());
      SbiDomains hibDomainEngineType = (SbiDomains) aSession.load(SbiDomains.class,
          aEngine.getEngineTypeId());
      SbiDataSource hibDataSource = null;
      if (aEngine.getDataSourceId() != null) {
        hibDataSource = (SbiDataSource) aSession.load(SbiDataSource.class, aEngine.getDataSourceId());
      }
      hibEngine.setName(aEngine.getName());
      hibEngine.setLabel(aEngine.getLabel());
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
      tx = aSession.beginTransaction();
      SbiDomains hibDomainBiobjType = (SbiDomains) aSession.load(SbiDomains.class,
          aEngine.getBiobjTypeId());
      SbiDomains hibDomainEngineType = (SbiDomains) aSession.load(SbiDomains.class,
          aEngine.getEngineTypeId());
      SbiDataSource hibDataSource = null;
      if (aEngine.getDataSourceId() != null) {
        hibDataSource = (SbiDataSource) aSession.load(SbiDataSource.class, aEngine.getDataSourceId());
      }
      SbiEngines hibEngine = new SbiEngines();
      hibEngine.setName(aEngine.getName());
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    Transaction tx = null;

    try {
      aSession = getSession();
      tx = aSession.beginTransaction();
      SbiDataSource hibDataSource = (SbiDataSource)aSession.load(SbiDataSource.class,  dsID);
      toReturn = toDataSource(hibDataSource);
      tx.commit();
     
    } catch (HibernateException he) {
      logger.error("Error while loading the data source with id " + dsID.toString(), he);     
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
      tmpSession = getSession();
      tx = tmpSession.beginTransaction();
      Criterion labelCriterrion = Expression.eq("label", label);
      Criteria criteria = tmpSession.createCriteria(SbiDataSource.class);
      criteria.add(labelCriterrion); 
      SbiDataSource hibDS = (SbiDataSource) criteria.uniqueResult();
      if (hibDS == null) return null;
      biDS = toDataSource(hibDS);       
     
      tx.commit();
    } catch (HibernateException he) {
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
        logger.error("The Domain with value_id= "+aDataSource.getDialectId()+" does not exist.");
        throw new EMFUserError(EMFErrorSeverity.ERROR, 1035);
      }

      //If DataSource Label has changed all LOVS with that DS need to be changed
      SbiDataSource hibDataSource = (SbiDataSource) aSession.load(SbiDataSource.class,
          new Integer(aDataSource.getDsId())); 
      if (aDataSource.getLabel() != null && hibDataSource.getLabel() != null){
      if (!aDataSource.getLabel().equals(hibDataSource.getLabel())){
        Query hibQuery = aSession.createQuery(" from SbiLov s where s.inputTypeCd = 'QUERY'");
       
        List hibList = hibQuery.list();
        if (!hibList.isEmpty()){
        Iterator it = hibList.iterator(); 
        while (it.hasNext()) {
          SbiLov lov = (SbiLov)it.next();
          String prov = lov.getLovProvider();
            SourceBean sb = SourceBean.fromXMLString(prov);
            SourceBean conn = (SourceBean)sb.getAttribute("CONNECTION");
            String conne = conn.getCharacters();
            if (conne.equals(hibDataSource.getLabel())){
              int cutStart = prov.indexOf("<CONNECTION>");
              cutStart = cutStart+12;
              int cutEnd = prov.indexOf("</CONNECTION>");
              String firstPart = prov.substring(0, cutStart);
              String secondPart = prov.substring(cutEnd, prov.length());
              prov = firstPart+aDataSource.getLabel()+secondPart;
              lov.setLovProvider(prov);
              aSession.update(lov);
            }
           
        }}
      }}
      hibDataSource.setLabel(aDataSource.getLabel());
      hibDataSource.setDialect(dialect);
      hibDataSource.setDialectDescr(dialect.getValueNm());
      hibDataSource.setDescr(aDataSource.getDescr());
      hibDataSource.setJndi(aDataSource.getJndi());
      hibDataSource.setUrl_connection(aDataSource.getUrlConnection());
      hibDataSource.setUser(aDataSource.getUser());
      hibDataSource.setPwd(aDataSource.getPwd());
      hibDataSource.setDriver(aDataSource.getDriver());
      hibDataSource.setMultiSchema(aDataSource.getMultiSchema());
      hibDataSource.setSchemaAttribute(aDataSource.getSchemaAttribute());
      updateSbiCommonInfo4Update(hibDataSource);
      tx.commit();
    } catch (HibernateException he) {
      logger.error("Error while modifing the data source with id " + ((aDataSource == null)?"":String.valueOf(aDataSource.getDsId())), he);
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
      if (dialect == null){
        logger.error("The Domain with value_id="+aDataSource.getDialectId()+" does not exist.");
        throw new EMFUserError(EMFErrorSeverity.ERROR, 1035);
      }
      SbiDataSource hibDataSource = new SbiDataSource();
      hibDataSource.setDialect(dialect);
      hibDataSource.setDialectDescr(dialect.getValueNm());
      hibDataSource.setLabel(aDataSource.getLabel());
      hibDataSource.setDescr(aDataSource.getDescr());
      hibDataSource.setJndi(aDataSource.getJndi());
      hibDataSource.setUrl_connection(aDataSource.getUrlConnection());
      hibDataSource.setUser(aDataSource.getUser());
      hibDataSource.setPwd(aDataSource.getPwd());
      hibDataSource.setDriver(aDataSource.getDriver());
      hibDataSource.setMultiSchema(aDataSource.getMultiSchema());
      hibDataSource.setSchemaAttribute(aDataSource.getSchemaAttribute());
      updateSbiCommonInfo4Insert(hibDataSource);
      aSession.save(hibDataSource);
      tx.commit();
    } catch (HibernateException he) {
      logger.error("Error while inserting the data source with id " + ((aDataSource == null)?"":String.valueOf(aDataSource.getDsId())), he);
View Full Code Here
348
349
350
351
352
353
354
355
356
357
358
    Session aSession = null;
    Transaction tx = null;
    try {
      aSession = getSession();
      tx = aSession.beginTransaction();
      SbiDataSource hibDataSource = (SbiDataSource) aSession.load(SbiDataSource.class,
          new Integer(aDataSource.getDsId()));

      aSession.delete(hibDataSource);
      tx.commit();
    } catch (HibernateException he) {
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
          hibDataSet=new SbiQueryDataSet();
          if(((QueryDataSetDetail)dataSetActiveDetail).getQuery()!=null){
            ((SbiQueryDataSet)hibDataSet).setQuery(((QueryDataSetDetail)dataSetActiveDetail).getQuery().toString());
          }
          if(((QueryDataSetDetail)dataSetActiveDetail).getDataSourceLabel()!=null){
            SbiDataSource hibDataSource = null;
            String dataSourceLabel = ((QueryDataSetDetail)dataSetActiveDetail).getDataSourceLabel();
            Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
            Criteria criteria = aSession.createCriteria(SbiDataSource.class);
            criteria.add(labelCriterrion); 
            hibDataSource = (SbiDataSource) criteria.uniqueResult();
            ((SbiQueryDataSet)hibDataSet).setDataSource(hibDataSource); 
          }       
        } 
       
        else if(dataSetActiveDetail instanceof QbeDataSetDetail){
          hibDataSet = new SbiQbeDataSet();
          SbiQbeDataSet hibQbeDataSet = (SbiQbeDataSet) hibDataSet;
          QbeDataSetDetail qbeDataSet = (QbeDataSetDetail) dataSetActiveDetail;
          hibQbeDataSet.setSqlQuery(qbeDataSet.getSqlQuery());
          hibQbeDataSet.setJsonQuery(qbeDataSet.getJsonQuery());
          hibQbeDataSet.setDatamarts(qbeDataSet.getDatamarts());
          String dataSourceLabel = qbeDataSet.getDataSourceLabel();
          Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
          Criteria criteria = aSession.createCriteria(SbiDataSource.class);
          criteria.add(labelCriterrion); 
          SbiDataSource hibDataSource = (SbiDataSource) criteria.uniqueResult();
          hibQbeDataSet.setDataSource(hibDataSource); 
        }

        else if(dataSetActiveDetail instanceof WSDataSetDetail){
          hibDataSet=new SbiWSDataSet();
View Full Code Here
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
          hibDataSet=new SbiQueryDataSet();
          if(((QueryDataSetDetail)dsActiveDetailToSet).getQuery()!=null){
            ((SbiQueryDataSet)hibDataSet).setQuery(((QueryDataSetDetail)dsActiveDetailToSet).getQuery().toString());
          }
          if(((QueryDataSetDetail)dsActiveDetailToSet).getDataSourceLabel()!=null){
            SbiDataSource hibDataSource = null;
            String dataSourceLabel = ((QueryDataSetDetail)dsActiveDetailToSet).getDataSourceLabel();
            Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
            Criteria criteria = aSession.createCriteria(SbiDataSource.class);
            criteria.add(labelCriterrion); 
            hibDataSource = (SbiDataSource) criteria.uniqueResult();
            ((SbiQueryDataSet)hibDataSet).setDataSource(hibDataSource); 
          }       
        }
       
        else if (dsActiveDetailToSet instanceof QbeDataSetDetail) {
          hibDataSet = new SbiQbeDataSet();
          SbiQbeDataSet hibQbeDataSet = (SbiQbeDataSet) hibDataSet;
          QbeDataSetDetail qbeDataSet = (QbeDataSetDetail) dsActiveDetailToSet;
          hibQbeDataSet.setSqlQuery(qbeDataSet.getSqlQuery());
          hibQbeDataSet.setJsonQuery(qbeDataSet.getJsonQuery());
          hibQbeDataSet.setDatamarts(qbeDataSet.getDatamarts());
          String dataSourceLabel = qbeDataSet.getDataSourceLabel();
          Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
          Criteria criteria = aSession.createCriteria(SbiDataSource.class);
          criteria.add(labelCriterrion); 
          SbiDataSource hibDataSource = (SbiDataSource) criteria.uniqueResult();
          hibQbeDataSet.setDataSource(hibDataSource); 
        }

        else if(dsActiveDetailToSet instanceof WSDataSetDetail){
          hibDataSet=new SbiWSDataSet();
View Full Code Here
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
    }

    if(hibDataSet instanceof SbiQueryDataSet){     
      dsActiveDetail=new QueryDataSetDetail();
      ((QueryDataSetDetail)dsActiveDetail).setQuery(((SbiQueryDataSet)hibDataSet).getQuery());
      SbiDataSource sbids=((SbiQueryDataSet)hibDataSet).getDataSource();
      if(sbids!=null){
        String dataSourceLabel = sbids.getLabel();
        ((QueryDataSetDetail)dsActiveDetail).setDataSourceLabel(dataSourceLabel);
      }
      dsActiveDetail.setDsType(JDBC_DS_TYPE);
      logger.debug("Jdbc dataset");
    }
   
    if(hibDataSet instanceof SbiQbeDataSet){     
      dsActiveDetail = new QbeDataSetDetail();
      QbeDataSetDetail aQbeDataSetDetail = (QbeDataSetDetail) dsActiveDetail;
      SbiQbeDataSet qbeHibDataSet = (SbiQbeDataSet) hibDataSet;
      aQbeDataSetDetail.setSqlQuery(qbeHibDataSet.getSqlQuery());
      aQbeDataSetDetail.setJsonQuery(qbeHibDataSet.getJsonQuery());
      aQbeDataSetDetail.setDatamarts(qbeHibDataSet.getDatamarts());
      SbiDataSource sbids = qbeHibDataSet.getDataSource();
      if (sbids!=null){
        aQbeDataSetDetail.setDataSourceLabel(sbids.getLabel());
      }
      dsActiveDetail.setDsType(QBE_DS_TYPE);
    }

    if(hibDataSet instanceof SbiWSDataSet){     
View Full Code Here
TOP

Related Classes of it.eng.spagobi.tools.datasource.metadata.SbiDataSource

  • it.eng.spagobi.analiticalmodel.document.dao.BIObjectDAOHibImpl
  • it.eng.spagobi.engines.config.dao.EngineDAOHibImpl
  • it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl
  • it.eng.spagobi.tools.datasource.dao.DataSourceDAOHibImpl
  • it.eng.spagobi.tools.importexport.ExporterMetadata
  • it.eng.spagobi.tools.importexport.ImporterMetadata
  • it.eng.spagobi.tools.importexport.ImportManager
  • it.eng.spagobi.tools.importexport.ImportUtilities
  • it.eng.spagobi.tools.importexport.services.ImportExportModule
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.