Toirtis
God of primitive fishes
As has been mentioned, hot glue is tank-safe, but even the high-temp stuff will not hold long (possibly less than a few hours) in your aquarium. Silicone or aquarium epoxy are what you want...a few extra dollars and a trip to buy it, but worth the lack of trouble in the end.