Package railo.runtime.db

Examples of railo.runtime.db.SQLImpl.addItems()


    public void log(int level, String application, String message) {
      DatasourceConnection dc=null;
      try {
      dc = pool.getDatasourceConnection(ThreadLocalPageContext.get(),datasource, username, password);
      SQLImpl sql = new SQLImpl(INSERT);
      sql.addItems(new SQLItemImpl(application,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(message,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(new DateTimeImpl(),CFTypes.DATE));
      new QueryImpl(ThreadLocalPageContext.get(),dc,sql,-1,-1,-1,"query");
    }
      catch (PageException e) {
View Full Code Here


      DatasourceConnection dc=null;
      try {
      dc = pool.getDatasourceConnection(ThreadLocalPageContext.get(),datasource, username, password);
      SQLImpl sql = new SQLImpl(INSERT);
      sql.addItems(new SQLItemImpl(application,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(message,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(new DateTimeImpl(),CFTypes.DATE));
      new QueryImpl(ThreadLocalPageContext.get(),dc,sql,-1,-1,-1,"query");
    }
      catch (PageException e) {
      console.log(level, application, message);
View Full Code Here

      try {
      dc = pool.getDatasourceConnection(ThreadLocalPageContext.get(),datasource, username, password);
      SQLImpl sql = new SQLImpl(INSERT);
      sql.addItems(new SQLItemImpl(application,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(message,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(new DateTimeImpl(),CFTypes.DATE));
      new QueryImpl(ThreadLocalPageContext.get(),dc,sql,-1,-1,-1,"query");
    }
      catch (PageException e) {
      console.log(level, application, message);
    }
View Full Code Here

      ProcParamBean param;
      int index=1;
        while(it.hasNext()) {
          param= it.next();
          param.setIndex(index);
          _sql.addItems(new SQLItemImpl(param.getValue()));
          if(param.getDirection()!=ProcParamBean.DIRECTION_OUT) {
            SQLCaster.setValue(pageContext.getTimeZone(),callStat, index, param);
          }
          if(param.getDirection()!=ProcParamBean.DIRECTION_IN) {
            registerOutParameter(callStat,param);
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. 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.