I dont see that very often having a load balancer for the database.
I think the best way when you have multiple database instances is to use the built-in clustering features.
From your application server this is transparent, everything will happen as if there is only one database instance.
SCJP 5 , SCWCD 5, SCEA 5
subject: Mark Cade's deployment diagram - load balancer for clustered databases?