Using one database connection [on hold]

Which one is better: one database connection object vs multiple database connection object? What is the limitation?

If we use same object during the lifetime of the application, Do we encounter any problem?