[
https://jira.jboss.org/jira/browse/JBPM-2410?page=com.atlassian.jira.plug...
]
Joram Barrez resolved JBPM-2410.
--------------------------------
Resolution: Done
Used Squirel v3.0.2 (
http://www.squirrelsql.org/), 'drop table' script
Specific drop statements / database:
* MySQL:
SET FOREIGN_KEY_CHECKS=0;
drop table a;
drop table b;
SET FOREIGN_KEY_CHECKS=1;
* Postgres:
DROP TABLE a CASCADE;
DROP TABLE b CASCADE;
* Oracle:
Connecting to the Oracle DB on the qa lab takes several minutes. It is easier to use the
SqlDeveloper tool from Oracle itself
(
http://www.oracle.com/technology/products/database/sql_developer/index.html):
DROP TABLE a CASCADE constraints;
DROP TABLE b CASCADE constraints;
If in the future this work is needed again, it may be better to create a script for it ...
so keep your unit tests clean ;-)
clean up obsolete qa dbs
------------------------
Key: JBPM-2410
URL:
https://jira.jboss.org/jira/browse/JBPM-2410
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Fix For: jBPM 4.1
delete all data in db users less then the one referenced in qa/jdbc
--
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