Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Difference between direct JDBC connection and connection from weblogic pool

 
mohan kumar r
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Is there any difference between database connection obtained using raw JDBC API ie without Weblogic Data Source and the Database Connection obtained from Weblogic Datasource.

During the execution of some bulk JOB, I found that transactions over direct connection is much faster than that of connection from datasource.

please enlighten me.

Thank you,
Regards,
Mohan
 
Jimmy Clark
Ranch Hand
Posts: 2187
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How much faster does the direct JDBC code execute?

Is the same driver being used?
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15632
46
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The connection you get from WebLogic is a kind of wrapper for the direct connection, which adds a few features - for example, connection pooling. Because WebLogic adds stuff to the direct connection, it might be a little bit slower.

It's also possible that your data source in WebLogic is poorly configured so that you get poor performance.

It might also be a bug in your code, or you're not allocating or using the database connections in an optimal way. We'd have to see your code if you'd want help with that.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic