Examples of OmniDTO

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

2928
2929
2930
2931
2932
2933
2934
2935
2936
2937
2938
2939
2940
2941
2942
2943
2944
2945
2946
2947
2948
2949
2950
            createSQL += " " + strBuffer.toString();
            log.debug("create sql = " + createSQL);
           
            inputs = addMoreProperties(inputs, null);

            OmniDTO returnTO =
                getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, createSQL);

            int count = returnTO.getUpdatedRowCount();

            if (count != 1) {
                log.error("Only one record should be created, but " + count +
                          " objects were created instead.");
            }

            //populate auto-generated primary keys
            if (autoPopulatePrimaryKey) {
                long gpk = returnTO.getGeneratedKey();
                if (gpk != -1) {
                    Map<String, Object> pkMap = getPrimaryKeyDataMap();
                    Iterator<String> it = pkMap.keySet().iterator();
                    if(it.hasNext()) { //only one column is allowed to be auto-generated primary key
                        setData((String)it.next(), Long.valueOf(gpk));
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

3124
3125
3126
3127
3128
3129
3130
3131
3132
3133
3134
3135
3136
3137
            log.debug("update sql = " + updateSQL);
           
            inputs = addMoreProperties(inputs, null);

            OmniDTO returnTO =
                getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, updateSQL);

            count = returnTO.getUpdatedRowCount();

            after_internal_update();
        }
        catch (Exception ex) {
            throw new BaseSQLException(ex);
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

51
52
53
54
55
56
57
58
59
60
61
    public OmniDTO execute(UserDatabaseConnection udc, Map<String, Object> inputs, Map<String, String> outputFilters)
    throws BaseSQLException {
      Connection connection = udc.getConnection();
      DBAdapter dba = DBAdapterFactory.getInstance().getAdapter(udc.getConnectionName());
     
        OmniDTO returnTO = new OmniDTO();
        CallableStatement cstmt = null;
       
        try {
            cstmt = connection.prepareCall(sp.getJavaAPIString());
           
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

95
96
97
98
99
100
101
102
103
104
105
106
107
       
        log.debug("insert sql = " + insertSQL);
        log.debug("insert inputs = " + inputs);
       
        inputs.put(DataProcessor.input_key_database_connection_name, connName);
        OmniDTO returnTO =
            SqlServiceConfig.getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, insertSQL.toString());
        int insertCount = returnTO.getUpdatedRowCount();
       
        RowData record = null;
        if (insertCount == 1) {
            record = new RowData(ri, null);
            record.setData(inputs);
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

123
124
125
126
127
128
129
130
131
132
133
       
        log.debug("updates sql = " + updateSQL);
        log.debug("updates inputs = " + inputs);
       
        inputs.put(DataProcessor.input_key_database_connection_name, connName);
        OmniDTO returnTO =
            SqlServiceConfig.getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, updateSQL.toString());
        int updateCount = returnTO.getUpdatedRowCount();
       
        return updateCount;
    }
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

143
144
145
146
147
148
149
150
151
152
153
       
        log.debug("delete sql = " + deleteSQL);
        log.debug("delete inputs = " + inputs);
       
        inputs.put(DataProcessor.input_key_database_connection_name, connName);
        OmniDTO returnTO =
            SqlServiceConfig.getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, deleteSQL.toString());
        int deleteCount = returnTO.getUpdatedRowCount();
       
        return deleteCount;
    }
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
     */
    public static TableData retrieveTableDataBySQL(String sql, Map<String, Object> inputs) {
        TableData td = null;
       
        try {
            OmniDTO returnTO =
                getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, sql);
           
            if ( returnTO != null ) {
                td = returnTO.getTableData(sql);
            }
        }
        catch (Exception ex) {
            throw new BaseSQLException(ex);
        }
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
     */
    public static TableData retrieveTableDataBySQLKey(String sqlKey, Map<String, Object> inputs) {
        TableData td = null;
       
        try {
            OmniDTO returnTO =
                getSqlService().execute(inputs, DataProcessorTypes.NAMED_SQL_STATEMENT_PROCESSOR, sqlKey);
           
            if ( returnTO != null ) {
                td = returnTO.getTableData(sqlKey);
            }
        }
        catch (Exception ex) {
            throw new BaseSQLException(ex);
        }
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

218
219
220
221
222
223
224
225
226
227
228
     */
    public static Object retrieveObjectBySQL(String sql, Map<String, Object> inputs) {
        Object returnObj = null;
       
        try {
            OmniDTO returnTO =
                getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, sql);
           
            returnObj = processResult(returnTO, sql);
        }
        catch (Exception ex) {
View Full Code Here

Examples of com.scooterframework.orm.sqldataexpress.object.OmniDTO

252
253
254
255
256
257
258
259
260
261
262
     */
    public static Object retrieveObjectBySQLKey(String sqlKey, Map<String, Object> inputs) {
        Object returnObj = null;
       
        try {
            OmniDTO returnTO =
                getSqlService().execute(inputs, DataProcessorTypes.NAMED_SQL_STATEMENT_PROCESSOR, sqlKey);
           
            returnObj = processResult(returnTO, sqlKey);
        }
        catch (Exception ex) {
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.