I assume you mean to say:

But I am able to connect to Derby DB outside of my perl script.

Then you have to debug what goes wrong. Maybe your encoding of SecurityMechanism is wrong. Maybe the hostname is wrong. Maybe the port number is wrong. Maybe the database driver is buggy. What does the documentation for the Derby DB DBD say on how to connect? What does it say about the error number you get? Have you contacted their technical support?