[jbpm-issues] [JBoss JIRA] Resolved: (JBPM-2381) SQLException while deploying process into ORACLE 9.0.5i database

SQLException while deploying process into ORACLE 9.0.5i database ---------------------------------------------------------------- Key: JBPM-2381 URL: https://jira.jboss.org/jira/browse/JBPM-2381 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Components: Runtime Engine Affects Versions: jBPM 4.0.CR1 Reporter: Ralf Edmund Stranzenbach Deploying a new process into the repository using the source-code below leads to an SQL-Exception: {code} RepositoryService service = getBean("repositoryService", RepositoryService.class); Deployment deployment = service.createDeployment(); deployment.addResourceFromClasspath("de/reswi/jbpm/Registration.jpdl.xml"); deployment.deploy(); {code} Detail Message: could not insert: [org.jbpm.pvm.internal.lob.Lob] SQL: insert into JBPM4_LOB (DBVERSION_, BLOB_VALUE_, BINARY_VALUE_, CLOB_VALUE_, TEXT_VALUE_, DBID_) values (?, ?, ?, ?, ?, ?) Cause: SQLException detailMessage: Vorgang nicht zulässig: streams type cannot be used in batching vendorCode: 17090 May be, it is not a good idea to directly INSERT large objects on Oracle 9.0.5? I've checked this using drivers ojdbc14.jar and ojdbc6.jar.