Examples of javax.sql.rowset.serial.SerialClob

javax.sql.rowset.serial.SerialClob
A serialized mapping in the Java programming language of an SQL CLOB value.
The SerialClob class provides a constructor for creating an instance from a Clob object. Note that the Clob object should have brought the SQL CLOB value's data over to the client before a SerialClob object is constructed from it. The data of an SQL CLOB value can be materialized on the client as a stream of Unicode characters.
SerialClob methods make it possible to get a substring from a SerialClob object or to locate the start of a pattern of characters.
Thread safety

A SerialClob is not safe for use by multiple concurrent threads. If a SerialClob is to be used by more than one thread then access to the SerialClob should be controlled by appropriate synchronization. @author Jonathan Bruce

    @Test
    public void test_insert_complex() throws Exception {
        db3.prepare("INSERT INTO TESTTYPES(c13) VALUES(?)").setBytes(1, "hello".getBytes()).commit();                    // byte arrays
        db3.prepare("INSERT INTO TESTTYPES(c14) VALUES(?)").setObject(1, UUID.randomUUID()).commit();                    // java object seralized
        db3.prepare("INSERT INTO TESTTYPES(c18) VALUES(?)").setBlob(1, new SerialBlob("hello".getBytes())).commit();     // blob
        db3.prepare("INSERT INTO TESTTYPES(c19) VALUES(?)").setClob(1, new SerialClob("hello".toCharArray())).commit();  // clob
        db3.prepare("INSERT INTO TESTTYPES(column21) VALUES(?)").setObjects(1, new Object[]{1, "h", 'R'}).commit();           // array
        System.out.println(db3.prepare("SELECT * FROM TESTTYPES").query());
    }

View Full Code Here

                      }
                    }
                    
                    break;
                case 13:
                    entity.dangerousSetNoCheckButFast(curField, new SerialClob(rs.getClob(ind)));
                    break;
                case 14:
                case 15:
                    entity.dangerousSetNoCheckButFast(curField, rs.getObject(ind));
                    break;

View Full Code Here

            throw new SQLException();
        }
        if (params == null) {
            throw new SQLException();
        }
        params.put(Integer.valueOf(parameterIndex - 1), new SerialClob(x));
    }

View Full Code Here

            if (type.equals(Blob.class) && !(value instanceof SerialBlob)) {
                return new SerialBlob((Blob) value);
            }


            if (type.equals(Clob.class) && !(value instanceof SerialClob)) {
                return new SerialClob((Clob) value);
            }


            if (type.equals(Ref.class) && !(value instanceof SerialRef)) {
                return new SerialRef((Ref) value);
            }

View Full Code Here

            throw new SQLException();
        }
        if (params == null) {
            throw new SQLException();
        }
        params.put(Integer.valueOf(parameterIndex - 1), new SerialClob(x));
    }

View Full Code Here

            if (type.equals(Blob.class) && !(value instanceof SerialBlob)) {
                return new SerialBlob((Blob) value);
            }


            if (type.equals(Clob.class) && !(value instanceof SerialClob)) {
                return new SerialClob((Clob) value);
            }


            if (type.equals(Ref.class) && !(value instanceof SerialRef)) {
                return new SerialRef((Ref) value);
            }

View Full Code Here

            throw new SQLException();
        }
        if (params == null) {
            throw new SQLException();
        }
        params.put(Integer.valueOf(parameterIndex - 1), new SerialClob(x));
    }

View Full Code Here

                if (obj instanceof Array) {
                    obj = new SerialArray((Array) obj);
                } else if (obj instanceof Blob) {
                    obj = new SerialBlob((Blob) obj);
                } else if (obj instanceof Clob) {
                    obj = new SerialClob((Clob) obj);
                } else if (obj instanceof Ref) {
                    obj = new SerialRef((Ref) obj);
                } else if (obj instanceof URL) {
                    obj = new SerialDatalink((URL) obj);
                }

View Full Code Here

            if (type.equals(Blob.class) && !(value instanceof SerialBlob)) {
                return new SerialBlob((Blob) value);
            }


            if (type.equals(Clob.class) && !(value instanceof SerialClob)) {
                return new SerialClob((Clob) value);
            }


            if (type.equals(Ref.class) && !(value instanceof SerialRef)) {
                return new SerialRef((Ref) value);
            }

View Full Code Here

            throw new SQLException();
        }
        if (params == null) {
            throw new SQLException();
        }
        params.put(Integer.valueOf(parameterIndex - 1), new SerialClob(x));
    }

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of javax.sql.rowset.serial.SerialClob

com.google.enterprise.connector.db.diffing.LobDocumentBuilderTest

com.mycila.testing.plugin.db.SqlResultsTest

com.sun.rowset.internal.CachedRowSetWriter

net.sf.hajdbc.sql.serial.SerialClobFactory

net.sf.hajdbc.sql.serial.SerialNClobFactory

net.sf.soapjdbc.SoapJdbcResultSet

org.apache.harmony.sql.internal.rowset.CachedRowSetImpl

org.apache.harmony.sql.internal.rowset.CachedRowSetReader

org.apache.harmony.sql.tests.javax.sql.rowset.serial.SerialArrayTest$SQLArray

org.apache.harmony.sql.tests.javax.sql.rowset.serial.SerialClobTest

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.

Examples of javax.sql.rowset.serial.SerialClob

Thread safety

Related Classes of javax.sql.rowset.serial.SerialClob