Package oracle.sql

Examples of oracle.sql.CLOB

177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
                            int bufSize = 1024;

                            index++;

                            if (type.equals("ascii")) {
                                CLOB ascii = set.getCLOB(index);

                                if (attr instanceof File) {
                                    File asciiFile = (File) attr;
                                    stream = new BufferedInputStream(new FileInputStream(asciiFile));
                                } else {
                                    String asciiText = (String) attr;
                                    stream = new BufferedInputStream(new ByteArrayInputStream(asciiText.getBytes()));
                                }

                                output = new BufferedOutputStream(ascii.getAsciiOutputStream());
                                bufSize = ascii.getBufferSize();
                            } else {
                                BLOB binary = set.getBLOB(index);
                                File binaryFile = (File) attr;
                                stream = new BufferedInputStream(new FileInputStream(binaryFile));
                                length = (int) binaryFile.length();
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
                            int bufSize = 1024;

                            index++;

                            if (type.equals("ascii")) {
                                CLOB ascii = set.getCLOB(index);

                                if (attr instanceof File) {
                                    File asciiFile = (File) attr;
                                    stream = new BufferedInputStream(new FileInputStream(asciiFile));
                                } else {
                                    String asciiText = (String) attr;
                                    stream = new BufferedInputStream(new ByteArrayInputStream(asciiText.getBytes()));
                                }

                                output = new BufferedOutputStream(ascii.getAsciiOutputStream());
                                bufSize = ascii.getBufferSize();
                            } else {
                                BLOB binary = set.getBLOB(index);
                                File binaryFile = (File) attr;
                                stream = new BufferedInputStream(new FileInputStream(binaryFile));
                                length = (int) binaryFile.length();
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
                            int bufSize = 1024;

                            index++;

                            if (type.equals("ascii")) {
                                CLOB ascii = set.getCLOB(index);

                                if (attr instanceof File) {
                                    File asciiFile = (File) attr;
                                    stream = new BufferedInputStream(new FileInputStream(asciiFile));
                                } else {
                                    String asciiText = (String) attr;
                                    stream = new BufferedInputStream(new ByteArrayInputStream(asciiText.getBytes()));
                                }

                                output = new BufferedOutputStream(ascii.getAsciiOutputStream());
                                bufSize = ascii.getBufferSize();
                            } else {
                                BLOB binary = set.getBLOB(index);
                                File binaryFile = (File) attr;
                                stream = new BufferedInputStream(new FileInputStream(binaryFile));
                                length = (int) binaryFile.length();
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
                            int bufSize = 1024;

                            index++;

                            if (type.equals("ascii")) {
                                CLOB ascii = set.getCLOB(index);

                                if (attr instanceof File) {
                                    File asciiFile = (File) attr;
                                    stream = new BufferedInputStream(new FileInputStream(asciiFile));
                                } else {
                                    String asciiText = (String) attr;
                                    stream = new BufferedInputStream(new ByteArrayInputStream(asciiText.getBytes()));
                                }

                                output = new BufferedOutputStream(ascii.getAsciiOutputStream());
                                bufSize = ascii.getBufferSize();
                            } else {
                                BLOB binary = set.getBLOB(index);
                                File binaryFile = (File) attr;
                                stream = new BufferedInputStream(new FileInputStream(binaryFile));
                                length = (int) binaryFile.length();
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
            int type = types[i];
            if(isNull(obj)) {
                pstmt.setNull(i + mediateLoc, types[i]);
            } else if(isClobType(type)) {
                String str = (String)obj;
                CLOB clob = CLOB.createTemporary(conn, true, CLOB.DURATION_CALL);
                pstmt.setClob(i + mediateLoc, clob);
                Writer writer = clob.getCharacterOutputStream();
                writer.write(str);
                writer.flush();
                writer.close();
            } else if(isBlobType(type)) {
                InputStream is = (InputStream)obj;
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
    private void writeLobType(Connection conn, OracleCallableStatement ostmt, Object[] params, int[] types) throws IOException, SQLException {

        for ( int i = 0; i < params.length; i++ ) {
            if (! isClobType(types[i])) continue ;
            CLOB clob = ostmt.getCLOB( i + 2 );
            Writer writer = ( ( CLOB )clob ).getCharacterOutputStream();
            writer.write( ( ( String )params[i]).toCharArray() );
            writer.flush();
            writer.close();
        }
View Full Code Here
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
            ps.setBlob(index, bl);
          }
          else
          { 
            CLOB cl = CLOB.createTemporary(conn, true, CLOB.DURATION_CALL);
            cl.putString(1,value);
            ps.setClob(index, cl);
          }
        }
        else if(value.indexOf("date:") > -1)
        {
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
43
        new OracleClobNormaliser().normalise("Any Old Object");
    }

    @Test
    public void shouldThrowCorrectExceptionIfClobIsLargerThanMaximum() throws SQLException {
        CLOB clob = mock(CLOB.class);
       
        when(clob.length()).thenReturn(10001l);
        expectedEx.expect(UnsupportedOperationException.class);
        expectedEx.expectMessage("Clobs larger than 10000 bytes are not supported by DBFIT");
       
        new OracleClobNormaliser().normalise(clob);
    }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
        new OracleClobNormaliser().normalise(clob);
    }

    @Test
    public void shouldReturnContentsOfClobIFAllOkay() throws SQLException {
        CLOB clob = mock(CLOB.class);
       
        when(clob.length()).thenReturn(Long.valueOf("CLOB contents".length()));
        when(clob.getChars(eq(1l), eq(10000), any(char[].class))).thenReturn("CLOB contents".length());

        // can't do this as we don't fill up the passed buffer
        //assertEquals("CLOB contents", new OracleClobNormaliser().normalise(clob));
        new OracleClobNormaliser().normalise(clob);
    }
View Full Code Here
TOP

Related Classes of oracle.sql.CLOB

  • anvil.core.sql.oracle.OracleModule
  • com.bleujin.framework.db.procedure.Oracle8iUserProcedure
  • com.bleujin.framework.db.procedure.OracleQueryUtils
  • com.isfasiel.util.data.Data
  • dbfit.environment.OracleClobNormaliserTest
  • org.apache.cocoon.acting.OraAddAction
  • org.infoglue.cms.controllers.kernel.impl.simple.InstallationController
  • sos.connection.SOSOracleConnection
    • 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.