The Mac App Store version comes with its own private copy of Java so installing any version of Java on your computer won't influence its behavior. From a search about JRELoadError, I suspect you actually try to launch the free version, rather the Mac App Store version.
I suggest you to throw away Sweet Home 3D application(s) found on your computer, then download again Mac App Store version.