I am deploying petstore1.4 on SunApplicationServer and default database derby. The asant and asant deploy is all complete. How ever I get the exception when populate the database. After some time of investing the sample folder and the build file, the problem may be this: - in the derby sql script folder, 3 databases have to be create separately: petstoredb, opcdb, supplierdb. However in the admin console, all the three connection pools just connect to derbyDB and in the build file just one script is executed ?
Can anyone encouter the same problem and please show me how to fix this and make it work ?