Package com.esri.gpt.framework.sql

Examples of com.esri.gpt.framework.sql.ManagedConnection

169
170
171
172
173
174
175
176
177
178
179
180
    }
    sbSql.append(" ORDER BY ");
    sbSql.append(sOrderByColumn).append(" ").append(sOrderByDir);

    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();
   
    // prepare the statements
    int n = 0;
    st = con.prepareStatement(sbSql.toString());
    stCount = con.prepareStatement(sbCount.toString());
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
          .getParameter("geoportalPassword")));
      parameters.put("serviceUrl", chkStr(request.getParameter("serviceUrl")));
      parameters.put("context", context);


      ManagedConnection mc = returnConnection(context);
      Connection toConn = mc.getJdbcConnection();
      boolean autoCommit = toConn.getAutoCommit();
      toConn.setAutoCommit(false);
      fromConn = fromDbRef.openConnection();
      /*
       * IClobMutator toCM = mc.getClobMutator(); parameters.put("toCM", toCM);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
*/
public void ensureReferenceToRemoteUser(User user)
  throws IdentityException, SQLException {
 
  // establish the connection
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();
 
  // if the local id has not been set,
  //   query for an existing reference,
  //   if none was found
  //     insert a new reference
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
260
* @throws SQLException if a database exception occurs
*/
private String readValueByUserId(String field, int userId)
  throws SQLException {
  String sValue = "";
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();
  PreparedStatement st = null;
  try {   
    String sSql = "SELECT "+field+" FROM "+getUserTableName()+" WHERE USERID=?";
    logExpression(sSql);
    st = con.prepareStatement(sSql);
View Full Code Here
287
288
289
290
291
292
293
294
295
296
297
298
    throw new ImsServiceException("DeleteRecordsRequest: not authorized.");
  }

  PreparedStatement st = null;
  // establish the connection
  ManagedConnection mc = returnConnection();
  Connection con = mc.getJdbcConnection();

  DatabaseMetaData dmt = con.getMetaData();
  String database = dmt.getDatabaseProductName().toLowerCase();
 
  boolean autoCommit = con.getAutoCommit();
View Full Code Here
373
374
375
376
377
378
379
380
381
382
383
384
  PreparedStatement st = null;

  try {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    StringBuilder sbSql = new StringBuilder();
    sbSql.append("UPDATE ").append(getResourceTableName()).append(" ");
    sbSql.append(" SET OWNER=? ");
View Full Code Here
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
  try { 
    docUuid = Val.chkStr(docUuid);
    if (docUuid.length() > 0) {
      String sSql = "SELECT XML FROM "+getResourceDataTableName()+" WHERE DOCUUID=?";
      logExpression(sSql);
      ManagedConnection mc = returnConnection();
      Connection con = mc.getJdbcConnection();
      IClobMutator cm = mc.getClobMutator();
      st = con.prepareStatement(sSql);
      st.setString(1,docUuid);
      ResultSet rs = st.executeQuery();
      if (rs.next()) {
        return Val.chkStr(cm.get(rs,1));
View Full Code Here
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
  PreparedStatement st = null;

  try {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    StringBuilder sbSql = new StringBuilder();
    sbSql.append("UPDATE ").append(getResourceTableName()).append(" ");
    sbSql.append(" SET ACL=? ");
View Full Code Here
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
 
  PreparedStatement st = null;

  try {
    // establish the connection
    ManagedConnection mc = returnConnection();
    Connection con = mc.getJdbcConnection();

    StringBuilder sbSql = new StringBuilder();
    sbSql.append("UPDATE ").append(getResourceTableName()).append(" ");
    sbSql.append(" SET APPROVALSTATUS=? ");
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
  try {
   
    HrRecord hr = getRepository();

    // establish the connection
    ManagedConnection mc = returnConnection();
    con = mc.getJdbcConnection();
    autoCommit = con.getAutoCommit();
    con.setAutoCommit(false);

    String sql = "";
    boolean isUpdate = false;
View Full Code Here
TOP

Related Classes of com.esri.gpt.framework.sql.ManagedConnection

  • com.esri.gpt.catalog.arcgis.agportal.synchronizer.ReverseSynchronizer
  • com.esri.gpt.catalog.arcims.ImsMetadataAdminDao
  • com.esri.gpt.catalog.arcims.ImsMetadataProxyDao
  • com.esri.gpt.catalog.harvest.history.HeDeleteRequest
  • com.esri.gpt.catalog.harvest.history.HeSelectOneRequest
  • com.esri.gpt.catalog.harvest.history.HeSelectRequest
  • com.esri.gpt.catalog.harvest.history.HeTransformReportRequest
  • com.esri.gpt.catalog.harvest.history.HeUpdateReportRequest
  • com.esri.gpt.catalog.harvest.history.HeUpdateRequest
  • com.esri.gpt.catalog.harvest.jobs.HjCancelRequest
    • 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.