Denis S. Kuchugurov [http://community.jboss.org/people/guruk] created the discussion "Re: JBPM5 - How can I change the database?" To view the discussion, visit: http://community.jboss.org/message/626041#626041 -------------------------------------------------------------- Gents, I am joining Priscila Britto in his request. have the same question, but for SQL Server. I have seen potentially relative info in http://community.jboss.org/docs/DOC-17071 http://community.jboss.org/wiki/JBPM5DatabaseTesting but couldn't manage maven modification to get desired result (having properly configured datasource). As this seem to be a very popular question, I wonder if there is no info about the topic, can anyone point out the link to the subj? Thanks, Denis -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/626041#626041] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Mauricio Salatino [http://community.jboss.org/people/salaboy21] created the discussion "Re: JBPM5 - How can I change the database?" To view the discussion, visit: http://community.jboss.org/message/626574#626574 -------------------------------------------------------------- Hi there, jBPM5 is using JPA and Hibernate for persistence. You should take a look at hibernate docs about how to set up each database. Are you having troubles with some database in particular? You should take a look at the persistence.xml file where the persistence unit is being defined, there you can change the database configuration to any supported databases in hibernate. Cheers -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/626574#626574] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Brian Lavender [http://community.jboss.org/people/brieweb] created the discussion "Re: JBPM5 - How can I change the database?" To view the discussion, visit: http://community.jboss.org/message/626965#626965 -------------------------------------------------------------- Try modifying the persistence.xml file which is stored in the db folder and add modify the properties so that it matches the Oracle database. <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>     <property name="hibernate.connection.password">mypassword</property>     <property name="hibernate.connection.url">jdbc:Oracle:thin:@192.168.1.1:1521/mydb</property>     <property name="hibernate.connection.username">my_user</property>     <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property> Then, you will need to drop the Oracle +ojdbc6.jar+ jdbc driver into the db/driver folder. I believe that will do it. brian -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/626965#626965] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Mauricio Salatino [http://community.jboss.org/people/salaboy21] created the discussion "Re: JBPM5 - How can I change the database?" To view the discussion, visit: http://community.jboss.org/message/627179#627179 -------------------------------------------------------------- Ok, looks that you are missing jbpm-human-task module and jbpm-bam module. I notice that you are mixing in the same Persistence Unit the Human Tasks Tables and also the Drools & jBPM5 tables. We usually keep them separately so we can access to the human task information without affecting the jBPM5 runtime tables, but it's up to you to have all the tables in the same database. Cheers -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/627179#627179] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Ryan Peterson [http://community.jboss.org/people/rrpeterson] created the discussion "Re: JBPM5 - How can I change the database?" To view the discussion, visit: http://community.jboss.org/message/627252#627252 -------------------------------------------------------------- I seem to have things working properly with mysql, I'll see if I can help (Running JBPM 5.1): my Maven dependencies (this took a long time to find the correct versions that would work together, I borrowed heavily from some of the example projects): |     | <dependency> | |         | <groupId>javax.servlet.jsp</groupId> | |         | <artifactId>jsp-api</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.springframework.security</groupId> | |         | <artifactId>spring-security-core</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.jbpm</groupId> | |         | <artifactId>jbpm-flow</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.jbpm</groupId> | |         | <artifactId>jbpm-bpmn2</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.jbpm</groupId> | |         | <artifactId>jbpm-flow-builder</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.jbpm</groupId> | |         | <artifactId>jbpm-persistence-jpa</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>com.google.code.gson</groupId> | |         | <artifactId>gson</artifactId> | |     | </dependency> | |     | <!-- Generic JPA Persistence --> | |     | <dependency> | |         | <groupId>javax.persistence</groupId> | |         | <artifactId>persistence-api</artifactId> | |     | </dependency> | |     | <!-- Transaction Management --> | |     | <dependency> | |         | <groupId>javax.transaction</groupId> | |         | <artifactId>jta</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.codehaus.btm</groupId> | |         | <artifactId>btm</artifactId> | |     | </dependency> | |     | <!-- Persistence Provider: Hibernate --> | |     | <dependency> | |         | <groupId>org.hibernate</groupId> | |         | <artifactId>hibernate-entitymanager</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.hibernate</groupId> | |         | <artifactId>hibernate-annotations</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.hibernate</groupId> | |         | <artifactId>hibernate-commons-annotations</artifactId> | |     | </dependency> | |     | <dependency> | |         | <groupId>org.hibernate</groupId> | |         | <artifactId>hibernate-core</artifactId> | |     | </dependency> | |     | <!-- Data Base: H2--> | |     | <dependency> | |         | <groupId>com.h2database</groupId> | |         | <artifactId>h2</artifactId> | |     | </dependency> | |     | <!-- Logging --> | |     | <dependency> | |         | <groupId>org.slf4j</groupId> | |         | <artifactId>slf4j-api</artifactId> | |     | </dependency> | |     | <!-- reporting --> | |     | <dependency> | |         | <groupId>org.jbpm</groupId> | |         | <artifactId>jbpm-bam</artifactId> | |     | </dependency> | My persistence.xml:   <persistence-unit name="org.jbpm.persistence.jpa">     <provider>org.hibernate.ejb.HibernatePersistence</provider>     <jta-data-source>jdbc/processInstanceDS</jta-data-source>     <class>org.drools.persistence.info.SessionInfo</class>     <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>     <class>org.jbpm.persistence.processinstance.ProcessInstanceEventInfo</class>     <class>org.drools.persistence.info.WorkItemInfo</class>     <class>org.jbpm.process.audit.ProcessInstanceLog</class>     <class>org.jbpm.process.audit.NodeInstanceLog</class>     <class>org.jbpm.process.audit.VariableInstanceLog</class>     <properties>       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>       <property name="hibernate.max_fetch_depth" value="3"/>       <property name="hibernate.hbm2ddl.auto" value="update"/>       <property name="hibernate.show_sql" value="true"/>       <property name="hibernate.transaction.manager_lookup_class"                 value="org.hibernate.transaction.BTMTransactionManagerLookup"/>     </properties>   </persistence-unit> My unit test DB setup: | | @BeforeTest | | | public void setup() { | |     | // setup a JNDI Datasource using Bitronix PoolingDataSource | |     | ds = new PoolingDataSource(); | |     | ds.setUniqueName( "jdbc/processInstanceDS" ); | |     | ds.setClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"); | |     | ds.setMinPoolSize(0); | |     | ds.setMaxPoolSize(3); | |     | ds.setAllowLocalTransactions(true); | |     | ds.getDriverProperties().put("user", "userName"); | |     | ds.getDriverProperties().put( "password", "userPassword" ); | |     | ds.getDriverProperties().put( "URL", "jdbc:mysql://localhost:3306/jbpm" ); | | //    | ds.getDriverProperties().put( "URL", "jdbc:h2:mem:mydb" );  // in-memory DB | |     | ds.init(); | | | } | -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/627252#627252] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]