Package oracle.jdbc

Examples of oracle.jdbc.OracleConnection

1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
  private void deleteExistingAW(AWConnection awConnection, String user,
                                String awName)
  {
    try
    {
      OracleConnection conn = (OracleConnection)
                               awConnection.getSQLConnection();
      SPLExecutor splExec = new SPLExecutor(conn);
      splExec.initialize();

      try
View Full Code Here
17
18
19
20
21
22
23
24
25
  {
    ExpressDataProvider dp = (ExpressDataProvider) getExpressDataProvider();
       
    println("Getting the Current Connection\n");
   
    OracleConnection conn = dp.getConnection();
    println("The connection object is an instance of an "
             + conn.getClass().getName() + ".");
  }
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
    try
    {
      // Create a DriverManager.
      DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
      // Create a connection to the Oracle Database instance.
      OracleConnection o_connection =
      (OracleConnection)DriverManager.getConnection("jdbc:oracle:thin:@" +
         connection, user, password);

      // Get information from the olapsys.xml_load_log table.
      String result = null;
      String sqlText = "select distinct xml_loadid " +
                       "from olapsys.xml_load_log " +
                       "order by xml_loadid desc";
      Statement sqlStmt = o_connection.createStatement();
      ResultSet rs = sqlStmt.executeQuery(sqlText);
      if(rs.next())
      {
        // Get the first value.
        int loadid = rs.getInt(1);
View Full Code Here
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
    try
    {
      // Create a DriverManager.
      DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
      // Create a connection to the Oracle Database instance.
      OracleConnection o_connection =
      (OracleConnection)DriverManager.getConnection("jdbc:oracle:thin:@" +
         connection, user, password);

      // Get information from the olapsys.xml_load_log table.
      String result = null;
      String sqlText = "select distinct xml_loadid " +
                       "from olapsys.xml_load_log " +
                       "order by xml_loadid desc";
      Statement sqlStmt = o_connection.createStatement();
      ResultSet rs = sqlStmt.executeQuery(sqlText);
      if(rs.next())
      {
        // Get the first value.
        int loadid = rs.getInt(1);
View Full Code Here
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
  private void deleteExistingAW(AWConnection awConnection, String user,
                                String awName)
  {
    try
    {
      OracleConnection conn = (OracleConnection)
                               awConnection.getSQLConnection();
      SPLExecutor splExec = new SPLExecutor(conn);
      splExec.initialize();

      try
View Full Code Here
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
     * INTERNAL:
     * Clears both implicit and explicit caches of OracleConnection
     */
    public void clearOracleConnectionCache(Connection conn) {
        if(conn instanceof OracleConnection){
            OracleConnection oracleConnection = (OracleConnection)conn;
            try {
                if(oracleConnection.getImplicitCachingEnabled()) {
                    oracleConnection.purgeImplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
            try {
                if(oracleConnection.getExplicitCachingEnabled()) {
                    oracleConnection.purgeExplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
        }
View Full Code Here
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
     * INTERNAL:
     * Clears both implicit and explicit caches of OracleConnection
     */
    public void clearOracleConnectionCache(Connection conn) {
        if(conn instanceof OracleConnection){
            OracleConnection oracleConnection = (OracleConnection)conn;
            try {
                if(oracleConnection.getImplicitCachingEnabled()) {
                    oracleConnection.purgeImplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
            try {
                if(oracleConnection.getExplicitCachingEnabled()) {
                    oracleConnection.purgeExplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
        }
View Full Code Here
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
     * INTERNAL:
     * Clears both implicit and explicit caches of OracleConnection
     */
    public void clearOracleConnectionCache(Connection conn) {
        if(conn instanceof OracleConnection){
            OracleConnection oracleConnection = (OracleConnection)conn;
            try {
                if(oracleConnection.getImplicitCachingEnabled()) {
                    oracleConnection.purgeImplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
            try {
                if(oracleConnection.getExplicitCachingEnabled()) {
                    oracleConnection.purgeExplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
        }
View Full Code Here
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
     * INTERNAL:
     * Clears both implicit and explicit caches of OracleConnection
     */
    public void clearOracleConnectionCache(Connection conn) {
        if(conn instanceof OracleConnection){
            OracleConnection oracleConnection = (OracleConnection)conn;
            try {
                if(oracleConnection.getImplicitCachingEnabled()) {
                    oracleConnection.purgeImplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
            try {
                if(oracleConnection.getExplicitCachingEnabled()) {
                    oracleConnection.purgeExplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
        }
View Full Code Here
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
     * Clears both implicit and explicit caches of OracleConnection
     */
    @Override
    public void clearOracleConnectionCache(Connection conn) {
        if(conn instanceof OracleConnection){
            OracleConnection oracleConnection = (OracleConnection)conn;
            try {
                if(oracleConnection.getImplicitCachingEnabled()) {
                    oracleConnection.purgeImplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
            try {
                if(oracleConnection.getExplicitCachingEnabled()) {
                    oracleConnection.purgeExplicitCache();
                }
            } catch(SQLException ex) {
                // ignore
            }
        }
View Full Code Here
TOP

Related Classes of oracle.jdbc.OracleConnection

  • com.alibaba.druid.bvt.pool.TestOraclePrefetch
  • com.alibaba.druid.pool.TestOraclePreparedStatement
  • com.alibaba.druid.test.util.OracleUtilsTest
  • com.alibaba.druid.TestOraclePing
  • com.alibaba.druid.util.OracleUtils
  • com.narirelays.ems.olap.sample.BuildAWExample
  • com.narirelays.ems.olap.sample.chapter3.GettingExistingConnection
  • com.narirelays.ems.olap.test.BuildAWExample
  • com.narirelays.ems.olap.test.MaintainEMSExample
  • org.eclipse.persistence.platform.database.oracle.Oracle9Platform
    • 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.