Example usage for java.sql PreparedStatement getConnection

List of usage examples for java.sql PreparedStatement getConnection

  1. HOME
  2. Java
  3. java
  4. java.sql.*
  5. PreparedStatement
  6. getConnection

Introduction

In this page you can find the example usage for java.sql PreparedStatement getConnection.

Prototype

Connection getConnection() throws SQLException;

Source Link

Document

Retrieves the Connection object that produced this Statement object.

Usage

From source file:org.springframework.jdbc.support.lob.TemporaryLobCreator.java

@Override
public void setClobAsString(PreparedStatement ps, int paramIndex, @Nullable String content)
        throws SQLException {

    if (content != null) {
        Clob clob = ps.getConnection().createClob();
        clob.setString(1, content);/*from   w  w  w . j a v  a 2  s.co m*/
        this.temporaryClobs.add(clob);
        ps.setClob(paramIndex, clob);
    } else {
        ps.setClob(paramIndex, (Clob) null);
    }

    if (logger.isDebugEnabled()) {
        logger.debug(content != null ? "Copied string into temporary CLOB with length " + content.length()
                : "Set CLOB to null");
    }
}

From source file:org.springframework.jdbc.support.lob.TemporaryLobCreator.java

@Override
public void setClobAsAsciiStream(PreparedStatement ps, int paramIndex, @Nullable InputStream asciiStream,
        int contentLength) throws SQLException {

    if (asciiStream != null) {
        Clob clob = ps.getConnection().createClob();
        try {//  w  ww .j a  v  a 2  s .  com
            FileCopyUtils.copy(asciiStream, clob.setAsciiStream(1));
        } catch (IOException ex) {
            throw new DataAccessResourceFailureException("Could not copy into LOB stream", ex);
        }
        this.temporaryClobs.add(clob);
        ps.setClob(paramIndex, clob);
    } else {
        ps.setClob(paramIndex, (Clob) null);
    }

    if (logger.isDebugEnabled()) {
        logger.debug(
                asciiStream != null ? "Copied ASCII stream into temporary CLOB with length " + contentLength
                        : "Set CLOB to null");
    }
}

From source file:org.springframework.jdbc.support.lob.TemporaryLobCreator.java

@Override
public void setClobAsCharacterStream(PreparedStatement ps, int paramIndex, @Nullable Reader characterStream,
        int contentLength) throws SQLException {

    if (characterStream != null) {
        Clob clob = ps.getConnection().createClob();
        try {/*www. jav a2 s  .c  o  m*/
            FileCopyUtils.copy(characterStream, clob.setCharacterStream(1));
        } catch (IOException ex) {
            throw new DataAccessResourceFailureException("Could not copy into LOB stream", ex);
        }
        this.temporaryClobs.add(clob);
        ps.setClob(paramIndex, clob);
    } else {
        ps.setClob(paramIndex, (Clob) null);
    }

    if (logger.isDebugEnabled()) {
        logger.debug(characterStream != null
                ? "Copied character stream into temporary CLOB with length " + contentLength
                : "Set CLOB to null");
    }
}