Package org.jboss.as.cmp.jdbc2

Examples of org.jboss.as.cmp.jdbc2.PkSqlCreateCommand

725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
            // this rsOffset is kind of a hack
            // but since tableIndex and rowIndex of a field are the same
            // this should work ok
            int rsOffset = 1;
            for (int i = 0; i < tableFields.length; ++i) {
                JDBCCMPFieldBridge2 field = tableFields[i];
                if (searchableOnly && !field.getJDBCType().isSearchable()) {
                    row.fields[field.getRowIndex()] = NOT_LOADED;
                    --rsOffset;
                    continue;
                }

                Object columnValue = field.loadArgumentResults(rs, field.getRowIndex() + rsOffset);
                row.fields[field.getRowIndex()] = columnValue;

                if (field.getVersionIndex() != -1) {
                    row.fields[field.getVersionIndex()] = columnValue;
                }
            }

            Object[] relations = (relationsTotal > 0 ? new Object[relationsTotal] : null);
View Full Code Here
757
758
759
760
761
762
763
764
765
766
767
768
        public Object loadPk(ResultSet rs) {
            Object pk = null;
            JDBCCMPFieldBridge2[] pkFields = (JDBCCMPFieldBridge2[]) entity.getPrimaryKeyFields();
            //int rsInd = 1;
            for (int i = 0; i < pkFields.length; ++i) {
                JDBCCMPFieldBridge2 field = pkFields[i];
                //Object columnValue = field.loadArgumentResults(rs, rsInd++);
                Object columnValue = field.loadArgumentResults(rs, field.getRowIndex() + 1);
                pk = field.setPrimaryKeyValue(pk, columnValue);
            }
            return pk;
        }
View Full Code Here
961
962
963
964
965
966
967
968
969
970
971
972
973
                            ps[c] = s;
                        }

                        int paramInd = 1;
                        for (int fInd = 0; fInd < pkFields.length; ++fInd) {
                            JDBCCMPFieldBridge2 pkField = pkFields[fInd];
                            Object fieldValue = row.fields[pkField.getRowIndex()];
                            paramInd = pkField.setArgumentParameters(s, paramInd, fieldValue);
                        }

                        final int affected = s.executeUpdate();
                        if (affected != 1) {
                            throw CmpMessages.MESSAGES.tooManyRowsAffected(affected);
View Full Code Here
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
                insertPs = con.prepareStatement(insertSql);

                paramInd = 1;
                JDBCCMPFieldBridge2[] tableFields = (JDBCCMPFieldBridge2[]) entity.getTableFields();
                for (int fInd = 0; fInd < tableFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = tableFields[fInd];
                    Object fieldValue = fields[field.getRowIndex()];
                    paramInd = field.setArgumentParameters(insertPs, paramInd, fieldValue);
                }

                insertPs.executeUpdate();

                flushStatus();
View Full Code Here
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
                JDBCUtil.safeClose(con);
            }
        }

        private Object loadField(int i) {
            JDBCCMPFieldBridge2 field = (JDBCCMPFieldBridge2) entity.getFields().get(i);

            StringBuffer query = new StringBuffer();
            query.append("select ")
                    .append(field.getColumnName())
                    .append(" from ")
                    .append(tableName)
                    .append(" where ");

            JDBCCMPFieldBridge2[] pkFields = (JDBCCMPFieldBridge2[]) entity.getPrimaryKeyFields();
            for (int pkI = 0; pkI < pkFields.length; ++pkI) {
                if (pkI > 0) {
                    query.append(" and ");
                }
                query.append(pkFields[pkI].getColumnName()).append("=?");
            }

            if (log.isDebugEnabled()) {
                log.debug("executing: " + query.toString());
            }

            Object value = null;
            Connection con = null;
            PreparedStatement ps = null;
            ResultSet rs = null;

            try {
                con = dataSource.getConnection();
                ps = con.prepareStatement(query.toString());

                for (int pkI = 0; pkI < pkFields.length; ++pkI) {
                    JDBCCMPFieldBridge2 pkField = pkFields[pkI];
                    Object fieldValue = fields[pkField.getRowIndex()];
                    pkField.setArgumentParameters(ps, pkI + 1, fieldValue);
                }

                rs = ps.executeQuery();

                if (!rs.next()) {
View Full Code Here
717
718
719
720
721
722
723
724
725
726
            created = row;
            row.state = CREATED;

            rowByPk.put(row.pk, row);

            JDBCCMPFieldBridge2 versionField = entity.getVersionField();
            if (versionField != null) {
                row.fields[versionField.getVersionIndex()] = row.fields[versionField.getRowIndex()];
            }
        }
View Full Code Here
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
            // this rsOffset is kind of a hack
            // but since tableIndex and rowIndex of a field are the same
            // this should work ok
            int rsOffset = 1;
            for (int i = 0; i < tableFields.length; ++i) {
                JDBCCMPFieldBridge2 field = tableFields[i];
                if (searchableOnly && !field.getJDBCType().isSearchable()) {
                    row.fields[field.getRowIndex()] = NOT_LOADED;
                    --rsOffset;
                    continue;
                }

                Object columnValue = field.loadArgumentResults(rs, field.getRowIndex() + rsOffset);
                row.fields[field.getRowIndex()] = columnValue;

                if (field.getVersionIndex() != -1) {
                    row.fields[field.getVersionIndex()] = columnValue;
                }
            }

            Object[] relations = (relationsTotal > 0 ? new Object[relationsTotal] : null);
View Full Code Here
773
774
775
776
777
778
779
780
781
782
783
784
        public Object loadPk(ResultSet rs) {
            Object pk = null;
            JDBCCMPFieldBridge2[] pkFields = (JDBCCMPFieldBridge2[]) entity.getPrimaryKeyFields();
            //int rsInd = 1;
            for (int i = 0; i < pkFields.length; ++i) {
                JDBCCMPFieldBridge2 field = pkFields[i];
                //Object columnValue = field.loadArgumentResults(rs, rsInd++);
                Object columnValue = field.loadArgumentResults(rs, field.getRowIndex() + 1);
                pk = field.setPrimaryKeyValue(pk, columnValue);
            }
            return pk;
        }
View Full Code Here
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
                            ps[c] = s;
                        }

                        int paramInd = 1;
                        for (int fInd = 0; fInd < pkFields.length; ++fInd) {
                            JDBCCMPFieldBridge2 pkField = pkFields[fInd];
                            Object fieldValue = row.fields[pkField.getRowIndex()];
                            paramInd = pkField.setArgumentParameters(s, paramInd, fieldValue);
                        }

                        final int affected = s.executeUpdate();
                        if (affected != 1) {
                            throw new EJBException("Affected " + affected + " rows while expected just one");
View Full Code Here
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
                insertPs = con.prepareStatement(insertSql);

                paramInd = 1;
                JDBCCMPFieldBridge2[] tableFields = (JDBCCMPFieldBridge2[]) entity.getTableFields();
                for (int fInd = 0; fInd < tableFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = tableFields[fInd];
                    Object fieldValue = fields[field.getRowIndex()];
                    paramInd = field.setArgumentParameters(insertPs, paramInd, fieldValue);
                }

                insertPs.executeUpdate();

                flushStatus();
View Full Code Here
TOP

Related Classes of org.jboss.as.cmp.jdbc2.PkSqlCreateCommand

  • org.jboss.as.cmp.bridge.EntityBridgeInvocationHandler
  • org.jboss.as.cmp.bridge.FieldBridge
  • org.jboss.as.cmp.CmpConfig
  • org.jboss.as.cmp.component.CmpEntityBeanComponent
  • org.jboss.as.cmp.ejbql.Catalog
  • org.jboss.as.cmp.jdbc.bridge.JDBCFieldBridge
  • org.jboss.as.cmp.jdbc.EJBQLToSQL92Compiler
  • org.jboss.as.cmp.jdbc.JDBCEntityPersistenceStore
  • org.jboss.as.cmp.jdbc.JDBCStartCommand
  • org.jboss.as.cmp.jdbc.JDBCStopCommand
    • 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.