Date of First Response: 2009-08-21 10:12:26 project_key: SOA There are two different (!) create_database.sql scripts: * server/*/deploy/jbossesb.sar/juddi-sql/mssql/create_database.sql * server/*/deploy/jbossesb.sar/lib/juddi-2.0rc5.aop.jar/juddi-sql/mssql/create_database.sql The script should be present only on the second location.
Link: Added: This issue related SOA-544
The files in the former location (.../jbossesb.sar/juddi-sql/mssql) will override the files from the latter location (.../sesb.sar/lib/juddi-2.0rc5.aop.jar|juddi-sql/mssql) and are now provided from ESB.
Fixed in revision 3644 (4.3 branch) of: build-tools/builers/eap/build.xml eap/resources/juddi-sql (deleted) Commit message: SOA-1454 Don't provide MSSQL jUDDI config files, as these are now provided by ESB.
Looking at 4.3 CP02 CR3 - the original problem is resolved - but, why is there a create_database.sql for only MS-SQL? It's not a regression - it's the same as 4.3 CP01: [ldimaggi@ldimaggi server]$ pwd /opt/local/43_CP02_CR3/jboss-soa-p.4.3.0/jboss-as/server [ldimaggi@ldimaggi server]$ tree ./all/deploy/jbossesb.sar/juddi-sql ./all/deploy/jbossesb.sar/juddi-sql |-- daffodildb | `-- import.sql |-- db2 | `-- import.sql |-- derby | `-- import.sql |-- firebird | `-- import.sql |-- hsqldb | `-- import.sql |-- informix | `-- import.sql |-- jdatastore | `-- import.sql |-- mssql | |-- create_database.sql | `-- import.sql |-- mysql | `-- import.sql |-- oracle | `-- import.sql |-- postgresql | `-- import.sql |-- sybase | `-- import.sql `-- totalxml `-- import.sql
Verified in CP02 CR3.