[JBoss JIRA] Created: (JBPM-2381) SQLException while deploying process into ORACLE 9.0.5i database
by Ralf Edmund Stranzenbach (JIRA)
SQLException while deploying process into ORACLE 9.0.5i database
----------------------------------------------------------------
Key: JBPM-2381
URL: https://jira.jboss.org/jira/browse/JBPM-2381
Project: JBoss 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 1 month
[JBoss JIRA] Created: (JBPM-2477) Problems with indexes in jbpm.history.hbm.xml
by Michael Wohlfart (JIRA)
Problems with indexes in jbpm.history.hbm.xml
---------------------------------------------
Key: JBPM-2477
URL: https://jira.jboss.org/jira/browse/JBPM-2477
Project: jBPM
Issue Type: Feature Request
Security Level: Public (Everyone can see)
Affects Versions: jBPM 4.0
Environment: Ubuntu 9.04
Oracle JDBC Driver version - "11.1.0.6.0-Production+"
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Oracle Database 10g Express Edition Release 10.2.0.1.0
Reporter: Michael Wohlfart
problem with indexes already indexed when running jbpm.oracle.create.sql:
create.jbpm.schema:
[sql] Executing resource: C:\SEAM\jbpm-4.0\db\schema.scripts\jbpm.oracle.create.sql
[sql] Failed to execute: create index IDX_HDETAIL_HACTI on JBPM4_HIST_DETAIL (HACTI_)
[sql] java.sql.SQLException: ORA-01408: such column list already indexed
[sql] Failed to execute: create index IDX_HDETAIL_HPROCI on JBPM4_HIST_DETAIL (HPROCI_)
[sql] java.sql.SQLException: ORA-01408: such column list already indexed
[sql] Failed to execute: create index IDX_HDET_HVAR on JBPM4_HIST_DETAIL (HVAR_)
[sql] java.sql.SQLException: ORA-01408: such column list already indexed
[sql] Failed to execute: create index IDX_HDET_HTASK on JBPM4_HIST_DETAIL (HTASK_)
[sql] java.sql.SQLException: ORA-01408: such column list already indexed
[sql] 76 of 80 SQL statements executed successfully
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 1 month