Spring Framework version 5, released in Sept 2017, introduced Spring WebFlux. A fully reactive stack. In Dec 2019 Spring Data R2DBC was released, an incubator to integrate relational databases using a reactive driver. In this blog post I’ll show that at high concurrency, WebFlux and R2DBC perform better. They have […]
jdbc
Performance of relational database drivers. R2DBC vs JDBC
R2DBC provides non-blocking reactive APIs to relational database programmers in Java. It is an open specification, similar to JDBC. JDBC however uses a thread per connection while R2DBC can handle more connections using less threads (and thus potentially use less memory). This could also mean threads are available to do other […]
Calling an Oracle DB stored procedure from Spring Boot using Apache Camel
There are different ways to create data services. The choice for a specific technology to use, depends on several factors inside the organisation which wishes to realize these services. In this blog post I’ll provide a minimal example of how you can use Spring Boot with Apache Camel to call […]
A transparent Spring Boot REST service to expose Oracle Database logic
Sometimes you have an Oracle database which contains a lot of logic and you want to expose specific logic as REST services. There are a variety of ways to do this. The most obvious one to consider might be Oracle REST Data Services. ORDS is quite powerful and for example supports […]
Developing for and Deploying an ADF Web Application to the Oracle Public Cloud (DBaaS and JCS)
In several recent articles, I have discussed first steps with Oracle Public Cloud Services: First steps with Database (DBaaS) in the Oracle Public Cloud Opening ports for access to DBaaS instance from the public internet (and from on premises laptops!) Getting started with Java Cloud Service (JCS) on the Oracle […]
Create JDBC Data Source or JDBC URL database connection to an Oracle Pluggable Database
JDBC URLs used in JDBC database connections in IDEs like JDeveloper and in JDBC Data Source definitions in Java EE servers such as WebLogic Server will typically use the Oracle Database SID as the name of the database. As Tim Hall writes, the syntax for the JDBC URL is as […]
Donderdag 16 april/Thursday April 16th – Speedy Joe’s – Using asynchronous interaction in Java EE to turn the world’s slowest restaurant into a super performant place
De Java SIG (Special Interest Group) van AMIS organiseert op donderdag 16 april een bijeenkomst (publiek toegankelijk) over asynchrone interacties in Java EE (web) applicaties. Synchrone interacties in de echte wereld en in IT applicaties kunnen de boel behoorlijk ophouden. Synchroon betekent wachten – en resources vasthouden. Dat kan een […]
Notifying ADF applications of database changes – fast and lean using Database Query Result Change Notification – Part One
In two articles, I will demonstrate how we can ensure that changes in the database – new, changed or deleted data – can rapidly be reflected in ADF based user interfaces running in browsers. This story involves a two-step push-mechanism: push from database to middle tier and push from middle […]
WLST script to add DataSource and DBAdapter EIS Connection Factory
Creating a EIS ConnectionFactory in your Database Adapter can be done with the WebLogic Administration Console, but of course this is also “scriptable”. What I needed was a script that created a Data Source with EIS Connection factory bound to the specific datasource. First I created a properties file, let’s […]
WebLogic 12c: Use JPA in your Web Application
Where as in WebLogic 11g JPA was not support by default, in WebLogic 12c it is the default persistency provider.JPA 2.0 is part of JAVA EE 6. I was trying some new JAVA EE 6 features in WebLogic 12c, so here is a is a way to create a Web […]
Masterclass for Java Developers – Make that Database Work for You! 17th December 2010
Really getting the most out of your database. That would be nice, given wat databases can do (and what you may have paid for them). Few serious Java Applications are completely devoid of interaction of some kind with a database. However, most ORM and  Java Persistency frameworks do their utmost to […]
Oracle & JDBC – Passing a ‘table of custom object type’ to a stored procedure – implementing efficient single round trip data exchange (part two of an ADF application on a PL/SQL API)
One very efficient way of passing data from the Java application to the database is through the use of custom Oracle Types. Even when we want to send a heterogeneous data set, for example a data set with master and details records, custom type based objects can provide a powerful […]