What not to do - Case Sensitive Business Spaces

[james_richards]

I bet this about the most obvious thing ever but I went and did it. So, just offering a word to the wise that in my 8.4 installation I initially created the business space MyApp for an example. Eventually, this got corrupted due do a few years of doing massive changes (I think) without updating and publishing incrementally.

I thought this was a perfect opportunity to actually make the business space match the marketing brand name of the app that was let's say myapp. Everything looked great. I ran this for a few months after manually importing the data table by table into the new business space and I thought it was finally time to delete the initial MyApp business space. Then got the error "unable to drop table" and things are not going well lol.

Now I can't delete obsolete versions of myapp because they are "under" MyApp. I suspect I will have to create a new database during a user blackout and recreate my business spaces for all the apps and manually import all the tables (using MySQL and not Derby). I hope that is the case and that I don't have to create a new server and fresh install of AIM first!

Anywho, lesson learned. Passing it on.

[james_richards]

Actually its even worse. I now realize that the MyApp is the root business space and not "default" in the Tomcat folder. 4 years ago I thought I would only ever create one app I guess. Now do I create a new business space MyApp or hit full escape now? I guess this thread got started in the wrong spot now.

I don't think this is a "problem report" for the app but understand if this thread needs to be moved. Looking for advice on how not to compound this problem.

[customaware]

The practice I use these days is to only ever create the initial DefaultApplication in BASDB

ALL other Business Spaces are in their own DB.
Additionally, as I run Aware V6, V8.5, V8.8 and V9 on my laptop, I PostFix every Business Spaces with the Aware IM Version...

ie... Suppose my app is called MySuperApp

mySuperApp880PROD
mySuperApp880TEST
mySuperApp900PROD
mySuperApp900TEST

Except on a Production server, as there is only ever a single version of Aware and only this Business Space running...

mySuperAppPROD
mySuperAppTEST

I run both MS-SQL and MariaDB on my Laptop.
For what it is worth....

[PointsWell]

Have you changed versions of MySQL? Version 8 is case sensitive whereas prior version were not.

[customaware]

I never use MySQL

I only use MS-SQL or Maria DB as they support Sequences and MySQL does not