[JBoss jBPM] - Oracle Problem with Problem Deployment
by Anandnatraj
I am reposting my problem with jBPM since I could not resolve it.
I have created a process in Eclipse IDE through GPD. I have already created my tables in ORACLE in my own user schema(so I have complete access rights for all the DB objects in my schema)
Now I started the jBPM -JBOss server. It started up well against ORalce-ds.xml. Means, all the DB objects I have created are perfect.
Now I am trying to deploy my process and I am getting the following Exception. A help from jBPM developers could be very helpful. I am almost stuck here for my second day.
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.graph.def.ProcessDefinition]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2404)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186
)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:524)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:510)
at org.jbpm.db.GraphSession.saveProcessDefinition(GraphSession.java:31)
... 38 more
Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("JBPM_PROCESSDEFINITION"."ID_")
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1975)
To My knowledge it seems it is not able to create the primary keys through Native generator class. Where I need to go and debug this to rectify.
N.B. It is working fine with hsql db.
Please help.
Anandh
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967291#3967291
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3967291
19 years, 8 months
[Management, JMX/JBoss] - Embedding MySQL as an MBean with Connector/MXJ
by danliang
Hello,
This is perhaps more closely related to Connector/MXJ than jBoss, but I am hoping for someone here has experience with the two that can lend a hand...
Currently I am developing an application using Java JDK 1.4.2, mySQL 5.0.19, jBoss 4.0.2, Connector/J 5.0, and Connector/MXJ 5.0.
I am attempting to embedd mySQL by using MXJ act as an MBean that jBoss will control. I have the database to communicate with the application, but am interested in passing options to MySQL on startup. What I would like to is:
1.) Specify a datadir and basedir
I have added the attributes to my "mysqld-service.xml", but get an error stating that the specified directory is not equal to "C:\Documents and Settings\user\Temp\mysql-c.mxj\" How can I specify the directory for MXJ to setup the data dir in? This works with MXJ 1.1. NOTE - I have gotten this to work by changing the source so that the method 'ensureDir' in 'MysqldResource.java' to change the base and data dir if they are different then the expected. I have also changed the order of the calls to:
adjustParameterMap(mysqldArgs)
makeMysqld();
ensureEssentialFilesExist();
To the above order in the meth0d 'exec' in the 'MMysqldResource.java' so that the baseDir and dataDir are changed prior to creating the files.
So far, this seems to work as expected, but does anyone see if this will cause problems?
2.) call mySQLd with a defaults-file.
I have modified the source to allow me to pass in a defaults-file, but was wondering if this was left out intentially as it is not good practice to start the MySQL with a defaults file through MXJ.
3.) Connect to MySQL through named pipes as a datasource in jBoss.
For example in my 'mysql-ds.xml' in my jboss/deploy folder:
<connection-url>jdbc:mysql:mxj://localhost:3306/DB</connection-url>
connects via TCP/IP;
where:
<connection-url>jdbc:mysql:mxj://./DB</connection-url>
<connection-property name="socketFactory">com.mysql.jdbc.NamedPipeSocketFactory</connection-property>
would connect via named-pipe
This causes an error to occur when jBoss attempts to connect to mySQL.
Any insight on how to get named-pipe connections to work?
Thanks,
Dan
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967282#3967282
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3967282
19 years, 8 months