The Micronaut framework includes several options for connection pooling since it launched and today there is a new option available for your microservice applications: Oracle Universal Connection Pool (UCP). In this post, I'd like to show you how to use this new feature in your application.
To get started, you must first include the dependency in your
If you're using Maven:
Next, you'll need to create a datasource in your
application.yaml file. All of the properties from
PoolDataSource are valid here and will be passed to the pool instance at runtime. For example:
You're now ready to add a service to query your datasource. If you're using Micronaut Data, you're all ready to go. Otherwise, you can create a service and inject the DataSource:
Add a method to get a connection from the pool, create and execute the query:
And a private helper to convert the ResultSet into a List of HashMap objects:
The only thing left to do is inject the UserService into our controller and add an endpoint to retrieve the users and return them:
In this post, we looked at how to utilize the new support for Oracle UCP in Micronaut. For further information, please check the docs or leave a question below!.
Photo by Humphrey Muleba on Unsplash
I've written many blog posts about connecting to an Autonomous DB instance in the past. Best practices evolve as tools, services, and frameworks become...
Email delivery is a critical function of most web applications in the world today. I've managed an email server in the past - and trust me - it's not fun...
In my last post, we looked at the technical aspects of my Brain to the Cloud project including much of the code that was used to collect and analyze the...