Package anvil.database

Examples of anvil.database.PooledConnection

286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
 
 
  public Tribe createTribe(String name) throws OperationFailedException {
    if (name == null) throw new OperationFailedException("Null tribe name!");
   
    PooledConnection connImpl = null;
    DirContext ctx = null;
 
    try {
      connImpl = _manager.acquire(_contextPool);
      ctx = (DirContext)connImpl.getConnection();
     
      Attributes at = new BasicAttributes();
      at.put(groupObjectClass);
     
      at.put("cn", name);
View Full Code Here
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
  {
    if (username == null) throw new OperationFailedException("Null username!");
    username = username.trim().toLowerCase();
    if (!checkEmail(username)) throw new OperationFailedException("Username isn't a valid email address!");
   
    PooledConnection connImpl = null;
    DirContext ctx = null;
 
    try {
      connImpl = _manager.acquire(_contextPool);
      ctx = (DirContext)connImpl.getConnection();
     
      Attributes at = new BasicAttributes();
      at.put("facsimileTelephoneNumber", password);
      at.put(objectClassAttr);
     
View Full Code Here
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
    return new Perl5Matcher().matches(email, EMAIL_PATTERN);
  }


  PermissionCollection loadPermissions(String dn) {
    PooledConnection connImpl = null;
    DirContext ctx = null;
 
    try {
      connImpl = getConnection();
      ctx = (DirContext)connImpl.getConnection();
      return loadPermissions(ctx, dn);
 
    } catch (Exception e) {
      _zone.log().error("LDAPRealm.loadPermissions(): "+e);
     
View Full Code Here
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
    return result;
  }
 
 
  PermissionCollection addPermission(Permission perm, String dn) throws OperationFailedException {
    PooledConnection connImpl = null;
    DirContext ctx = null;
 
    try {
      connImpl = getConnection();
      ctx = (DirContext)connImpl.getConnection();

      PermissionCollection storage = LDAPRealm.loadPermissions(ctx, dn);
      boolean found = false;
      for (Enumeration enu=storage.elements(); enu.hasMoreElements(); ) {
        if (perm.equals(enu.nextElement())) {
View Full Code Here
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
    }
  }


  PermissionCollection removePermission(Permission perm, String dn) throws OperationFailedException {
    PooledConnection connImpl = null;
    DirContext ctx = null;
 
    try {
      connImpl = getConnection();
      ctx = (DirContext)connImpl.getConnection();

      PermissionCollection storage = LDAPRealm.loadPermissions(ctx, dn);
      PermissionCollection altered = new Permissions();
     
      boolean found = false;
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
  }
 
 
  /*package*/ Object perform(Action action) throws OperationFailedException
  {
    PooledConnection impl = null;
    try {
      impl = _manager.acquire(_poolname);
    } catch (NoConnectionPoolException e) {
      String msg = "Couldn't acquire connection: " + e;
      _zone.log().error(e);
      throw new OperationFailedException(msg);
     
    } catch (CannotReturnPooledConnectionException e) {
      String msg = "Couldn't acquire connection: " + e;
      _zone.log().error(e);
      throw new OperationFailedException(msg);
    }
   
    Connection conn = (Connection)impl.getConnection();
   
    try {
      /* conn.setAutoCommit(false) */
      Object rv = action.perform(conn);
      /* conn.commit(); */
      return rv;
   
    } catch (SQLException e) {
      try {
        /* conn.rollback(); */
        conn.close();
      } catch (Throwable t) {
      }
      _zone.log().error("SQL operation failed", e);
      throw new OperationFailedException(e.toString());
     
    } catch (OperationFailedException e) {
      try {
        /* conn.rollback(); */
        conn.close();
      } catch (Throwable t) {
      }
      _zone.log().error("Operation failed", e);
      e.fillInStackTrace();
      throw e;
     
    } finally {
      impl.release();
    }
   
  }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
    if (i>0) {
      catalog = ckey.substring(i+1);
      ckey = ckey.substring(0, i);
    }
   
    PooledConnection connImpl = null;
    Connection conn = null;
   
    try {

      ConnectionManager manager = context.address().getZone().getManagerFor(ckey);
      connImpl = manager.acquire(ckey);
      conn = (Connection)connImpl.getConnection();
      if (catalog != null) {
        conn.setCatalog(catalog);
      }
      conn.setAutoCommit(autoCommit);
      conn.setReadOnly(readOnly);
      return connImpl;
     
    } catch (CannotReturnPooledConnectionException e) {
      throw context.AcquireError(e.getMessage());
    } catch (NoConnectionPoolException e) {
      throw context.AcquireError("No such pool: " + ckey);
    } catch (SQLException e) {
      if (conn != null) {
        try {
          conn.close();
        } catch (Exception e2) {
        }
      }
      connImpl.release();
      throw context.exception(e);
    }
  }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
  /// @throws AcquireError If connection could not be retrieved
  /// @throws SQLError If SQL error occured

  public static final Any query(Context context, String ckey, String query, Any[] parameters)
  {
    PooledConnection connImpl = acquireConnection(context, ckey, true, false);
    if (connImpl == null) {
      return Any.NULL;
    }
    Connection conn = (Connection)connImpl.getConnection();
    try {
      Statement stmt = conn.createStatement();
      stmt.setEscapeProcessing(false);
      String queryString;
      if (parameters.length == 0) {
        queryString = query;
      } else {
        queryString = SQLUtil.buildQueryString(query, parameters, 0);
      }
      Any returnValue;
      if (stmt.execute(queryString)) {
        returnValue = new AnyResultSet(stmt.getResultSet(), stmt);
      } else {
        returnValue = Any.create(stmt.getUpdateCount());
        stmt.close();
      }
      return returnValue;
    } catch (SQLException e) {
      try {
        conn.close();
      } catch (Exception e2) {
      }
      throw context.exception(e);
    } finally {
      connImpl.release();
    }
  }
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
  /// @throws AcquireError If connection could not be retrieved
  /// @throws SQLError If SQL error occured
  public static final Object[] p_acquire = { null, "key", "*autoCommit", Boolean.TRUE, "*readOnly", Boolean.FALSE };
  public static final Any acquire(Context context, String ckey, boolean autoCommit, boolean readOnly)
  {
    PooledConnection connImpl = acquireConnection(context, ckey, autoCommit, readOnly);
    if (connImpl == null) {
      return Any.NULL;
    } else {
      return new AnyConnection(connImpl);
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
    this.fullDN = realm.createGroupDN(name);
    this.isRoot = isRoot;
    log = realm.getLog();
   
    if (!isRoot) {
      PooledConnection connImpl = null;
      DirContext ctx = null;
      boolean tribeFound = false;
   
      try {
        connImpl = realm.getConnection();
        ctx = (DirContext)connImpl.getConnection();
   
        ctx.getAttributes(dn, new String[] { "cn" });
        tribeFound = true;
      } catch (NameNotFoundException nnfe) {
        //not found
View Full Code Here
TOP

Related Classes of anvil.database.PooledConnection

  • anvil.brain.Brain
  • anvil.core.naming.NamingModule
  • anvil.core.sql.SQLModule
  • anvil.core.system.AnyConfigurable
  • anvil.server.db.DBRealm
  • anvil.server.ldap.LDAPCitizen
  • anvil.server.ldap.LDAPRealm
  • anvil.server.ldap.LDAPTribe
    • 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.