File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes saving clob data through hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "saving clob data through hibernate" Watch "saving clob data through hibernate" New topic
Author

saving clob data through hibernate

deepak adlakha
Ranch Hand

Joined: Jul 27, 2001
Posts: 325

I have strange problem. I have one table with two columns as clob and inserting the data through hibernate. Records gets entered in the table through unit test. but in IDE, at the end of my test i get this error. Can anyone tell me why this is coming ? error says lack of priveileges...do i need to provide any special priveligies for this table ???



aused by: java.sql.BatchUpdateException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 49 more



Sample code is as follows :-

try
{
getHibernateTemplate().save(employeeService);
getHibernateTemplate().flush();
getHibernateTemplate().refresh(employeeService,
LockMode.UPGRADE);

// Set the request template
Clob requestClob = employeeService.getRequestTemplate();
Writer requestDataWriter = requestClob.setCharacterStream(1);

requestDataWriter.write(requestTemplate);
requestDataWriter.close();

// Set the response template
Clob responseClob = employeeService.getResponseTemplate();
Writer responseDataWriter = responseClob.setCharacterStream(1);

responseDataWriter.write(requestTemplate);
responseDataWriter.close();

..............
.................... two more objects save through hibernate


return employeeService;
}
catch (Throwable t)
{
return null;
}

}
deepak adlakha
Ranch Hand

Joined: Jul 27, 2001
Posts: 325
This is resolved. I firgured it out...one of the other table, i have to provide access. So this issues is resolved and closed.

Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: saving clob data through hibernate
 
Similar Threads
Support localization in CLOB filed in DB through java
clob.setCharacterStream(1); Unsupported feature
Support localization in CLOB file in DB through Java
Hibernate not updating a null column
Use two connections individually for a clob selection and updating statment.