CODEWITHSUNDEEP
javaoracle-databasejdbcclobapache-commons-dbcp
javagirl
javagirl

Reputation: 1675

saving InputStream as clob in oracle using jdbc

I have a csv file uploaded by user, which I need to store as a Clob, in oracle table.

Therefore I have this code:

 MultipartHttpServletRequest mr = (MultipartHttpServletRequest) ctx.getRequest();
    final MultipartFile f = mr.getFile("datafile");
    final InputStream is = f.getInputStream();
     ...
   jdbc.getJdbcOperations().execute(sql, new PreparedStatementCallback<Integer>() {
     public Integer doInPreparedStatement(final PreparedStatement psInsert) throws SQLException,
                            DataAccessException {
     ...
    psInsert.setCharacterStream(1, new InputStreamReader(is));
    psInsert.executeUpdate();
   }
});

Also, I've tried using methods setClob and setAsciiStream of PreparedStatement, as well as I've tried this approach (setting the size of the file), but result is the same -

java.lang.AbstractMethodError
    org.apache.commons.dbcp.DelegatingPreparedStatement.setAsciiStream(DelegatingPreparedStatement.java:338)
    org.apache.commons.dbcp.DelegatingPreparedStatement.setAsciiStream(DelegatingPreparedStatement.java:338)
    org.apache.commons.dbcp.DelegatingPreparedStatement.setAsciiStream(DelegatingPreparedStatement.java:338)

The underlying InputStream is ByteArrayInputStream (if that could make any difference)

PS: The table really has CLOB field:

P_FILE CLOB NOT NULL,

UPD: I haven't actually tried the Oracle implemented methods. It works, the only problem is the oracle driver implements not all of the methods comparing to those which are in the PreparedStatement interface. The class to look at the possible available methods is OraclePreparedStatement ...

Upvotes: 0

Views: 4639

Answers (2)

Jeff Miller
Jeff Miller

Reputation: 1434

Sormula makes it easy to read/write any type by using a TypeTranslator. See org.sormula.examples.blob package in the project. The code would be similar for CLOB.

public class WidgetTanslator1 implements TypeTranslator<Widget>
{
    public void write(PreparedStatement preparedStatement, int parameterIndex, Widget parameter) throws Exception
    {
        // convert from domain object to bytes
        ByteArrayOutputStream bos = new ByteArrayOutputStream(1000);
        try (ObjectOutputStream oos = new ObjectOutputStream(bos))
        {
            oos.writeObject(parameter);

            // convert bytes to jdbc blob
            preparedStatement.setBlob(parameterIndex, new SerialBlob(bos.toByteArray()));
        }
    }


    public Widget read(ResultSet resultSet, int parameterIndex) throws Exception
    {
        // convert from jdbc blob to bytes to domain object
        Blob blob = resultSet.getBlob(parameterIndex);
        try (ObjectInputStream ois = new ObjectInputStream(new ByteArrayInputStream(blob.getBytes(1, (int)blob.length()))))
        {
            return (Widget)ois.readObject();
        }
    }
}

Annotate CLOB field like this:

@ImplicitType(translator=WidgetTanslator1.class)
Widget widget;

Upvotes: 0

GriffeyDog
GriffeyDog

Reputation: 8376

From the AbstractMethodError javadoc:

Thrown when an application tries to call an abstract method. Normally, this error is caught by the compiler; this error can only occur at run time if the definition of some class has incompatibly changed since the currently executing method was last compiled.

Check to make sure all of your classes are current. I would do a clean and rebuild of your entire project. Also, make sure your compile-time and runtime classpaths are equivalent (as far as library versions, etc.)

Upvotes: 1

Related Questions