Package nexj.core.persistence.sql

Examples of nexj.core.persistence.sql.SQLAdapter

420
421
422
423
424
425
426
427
428
429
430
431
      String sFile = getRequiredProperty("sql.file")
         .replace("${cmd}", m_sCommand)
         .replace("${ds}", database.getName());
      String sOwner = getProperty("meta.owner");
      SQLAdapter adapter = (SQLAdapter)database.getComponent().getInstance(null);
      SQLSchemaManager manager = adapter.createSchemaManager(database);

      if (sOwner != null) // some SchemaManagers (e.g. DB2) will have a different default for null
      {
         manager.setOwner((sOwner.equals(".")) ? "" : sOwner);
      }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
153
154
  
            m_connection = DriverManager.getConnection(sURL, connectionProperties);
         }
         else
         {
            SQLAdapter adapter = (SQLAdapter)getDatabase().getComponent().getInstance(null);
           
            m_connection = adapter.getConnectionFactory().getConnection(adapter);
         }
      }

      return m_connection;
   }
View Full Code Here
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
                     {
                        continue;
                     }

                     RelationalDatabase ds = (RelationalDatabase)fragment.getDataSource();
                     SQLAdapter adapter = (SQLAdapter)ds.getComponent().getInstance(null);
                     String sDataSourceClass = ds.getDriver();

                     ref.addProperty(new J2EEProperty("name", ds.getName()));
                     ref.addProperty(new J2EEProperty("dataSource", sDataSourceClass));
                     ref.addProperty(new J2EEProperty("initialSQL", adapter.getInitialSQL()));
                     ref.addProperty(new J2EEProperty("password", fragment.getPassword()));
                     ref.addProperty(new J2EEProperty("properties",
                           PropertyUtil.toString(fragment.getPropertyHolder().getProperties())));
                     ref.addProperty(new J2EEProperty("statementCacheSize", fragment.getStatementCacheSize()));
                     ref.addProperty(new J2EEProperty("testSQL", adapter.getTestSQL()));
                     ref.addProperty(new J2EEProperty("user", fragment.getUser()));
                     ref.addProperty(new J2EEProperty("isolationLevel",
                                                      Connection.TRANSACTION_READ_COMMITTED));
                  }
View Full Code Here
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
                  {
                     cf = new Component(source.getName() + ".ConnectionFactory" + fragment.getSuffix(),
                        loader.getHelper().getClassObject(SysUtil.PACKAGE + ".core.persistence.sql.SQLRAConnectionFactory"),
                        Component.SINGLETON);

                     SQLAdapter adapterInstance = (SQLAdapter)component.getInstance(null);

                     cf.addPrimitivePropertyInitializer("fragment", fragment);
                     cf.addPrimitivePropertyInitializer("initialSQL", adapterInstance.getInitialSQL());
                     cf.addPrimitivePropertyInitializer("testSQL", adapterInstance.getTestSQL());
                  }

                  cf.setMetadata(loader.getMetadata());
                  fragment.setConnectionFactory(cf);
                  loader.addSingletonFixup(cf);
View Full Code Here
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
   public void deleteData(DataSource dataSource) throws Exception
   {
      if (dataSource instanceof RelationalDatabase)
      {
         RelationalDatabase database = (RelationalDatabase)dataSource;
         SQLAdapter adapter = (SQLAdapter)database.getComponent().getInstance(m_context);
         SQLSchemaManager manager = adapter.createSchemaManager(database);
         RelationalSchema schema = (RelationalSchema)database.getSchema();
         String sOrigFragment = m_context.getFragmentName();
         Connection connection = null;

         try
         {
            for (Iterator itr = dataSource.getFragmentIterator(); itr.hasNext();) // each fragment
            {
               m_context.setFragmentName(((Named)itr.next()).getName()); // connection for fragment

               try
               {
                  if (s_logger.isDebugEnabled())
                  {
                     s_logger.debug("Deleting data in data source \"" + dataSource.getName() + '"');
                  }

                  connection = adapter.getConnectionFactory().getConnection(adapter);
                  manager.setSQLAppender(new SQLSchemaManager.SQLConnectionAppender(connection, true));
                  manager.truncateSchema(schema);

                  if (s_logger.isDebugEnabled())
                  {
                     s_logger.debug("Deletion completed");
                  }
               }
               finally
               {
                  adapter.close(connection);
               }
            }
         }
         finally
         {
View Full Code Here
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
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
   public void dropSchema(DataSource dataSource) throws Exception
   {
      if (dataSource instanceof RelationalDatabase)
      {
         RelationalDatabase database = (RelationalDatabase)dataSource;
         SQLAdapter adapter = (SQLAdapter)database.getComponent().getInstance(m_context);
         SQLSchemaManager manager = adapter.createSchemaManager(database);
         RelationalSchema schema = (RelationalSchema)database.getSchema();
         String sOrigFragment = m_context.getFragmentName();
         Connection connection = null;

         try
         {
            for (Iterator itr = dataSource.getFragmentIterator(); itr.hasNext();) // each fragment
            {
               m_context.setFragmentName(((Named)itr.next()).getName()); // connection for fragment

               try
               {
                  connection = adapter.getConnectionFactory().getConnection(adapter);
                  manager.setSQLAppender(
                     new SQLSchemaManager.SQLConnectionAppender(connection, true));

                  if (s_logger.isDebugEnabled())
                  {
                     s_logger.debug(
                        "Dropping the schema of data source \"" + dataSource.getName() + '"');
                  }

                  manager.dropSchema(schema);

                  if (s_logger.isDebugEnabled())
                  {
                     s_logger.debug("Schema dropped");
                  }
               }
               finally
               {
                  adapter.close(connection);
               }
            }
         }
         finally
         {
View Full Code Here
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
   public void createSchema(DataSource dataSource) throws Exception
   {
      if (dataSource instanceof RelationalDatabase)
      {
         RelationalDatabase database = (RelationalDatabase)dataSource;
         SQLAdapter adapter = (SQLAdapter)database.getComponent().getInstance(m_context);
         SQLSchemaManager manager = adapter.createSchemaManager(database);
         RelationalSchema schema = (RelationalSchema)database.getSchema();
         String sOrigFragment = m_context.getFragmentName();
         Connection connection = null;

         try
         {
            for (Iterator itr = dataSource.getFragmentIterator(); itr.hasNext();) // each fragment
            {
               m_context.setFragmentName(((Named)itr.next()).getName()); // connection for fragment

               try
               {
                  connection = adapter.getConnectionFactory().getConnection(adapter);
                  manager.setSQLAppender(
                     new SQLSchemaManager.SQLConnectionAppender(connection, false));

                  if (s_logger.isDebugEnabled())
                  {
View Full Code Here
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
            continue; // skip DataSources without any Metaclasses mapped to them
         }

         importDataSourceSet.add(ds);

         SQLAdapter adapter = (SQLAdapter)ds.getComponent().getInstance(m_context);

         adapterList.add(adapter); //reference locally so not GCed
         adapter.setConnectionFactory(outCF); // override adapter's SQLConnectionFactory
      }

      importData(in, importDataSourceSet, true); // assume no data in DB
   }
View Full Code Here
589
590
591
592
593
594
595
596
597
598
599
600
601
      String sInitSQL = null;
      String sTestSQL;

      if (jdbcConnInfo == null)
      {
         SQLAdapter adapter = getAdapter(db);
         sInitSQL = adapter.getInitialSQL();
         sTestSQL = adapter.getTestSQL();
      }
      else
      {
         sTestSQL = jdbcConnInfo.getTestSQL();
      }
View Full Code Here
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
    * @param db The database.
    * @return The SQL adapter.
    */
   protected SQLAdapter getAdapter(RelationalDatabase db)
   {
      SQLAdapter adapter = (SQLAdapter)m_adapterMap.get(db);

      if (adapter == null)
      {
         adapter = (SQLAdapter)db.getComponent().getInstance(null);
         m_adapterMap.put(db, adapter);
View Full Code Here
TOP

Related Classes of nexj.core.persistence.sql.SQLAdapter

  • nexj.core.admin.etl.DataLoader
  • nexj.core.admin.platform.jboss.JBossInstaller
  • nexj.core.meta.Attribute
  • nexj.core.meta.Component
  • nexj.core.meta.Metaclass
  • nexj.core.meta.Metadata
  • nexj.core.meta.persistence.AttributeMapping
  • nexj.core.meta.persistence.Key
  • nexj.core.meta.persistence.PersistenceMapping
  • nexj.core.meta.persistence.sql.Column
    • 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.