This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Difference between direct JDBC connection and connection from weblogic pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Difference between direct JDBC connection and connection from weblogic pool" Watch "Difference between direct JDBC connection and connection from weblogic pool" New topic
Author

Difference between direct JDBC connection and connection from weblogic pool

mohan kumar r
Ranch Hand

Joined: Jan 19, 2006
Posts: 38
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


mohan
Jimmy Clark
Ranch Hand

Joined: Apr 16, 2008
Posts: 2187
How much faster does the direct JDBC code execute?

Is the same driver being used?
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14074
    
  16

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.


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Difference between direct JDBC connection and connection from weblogic pool
 
Similar Threads
DataSource VS Connection
Transaction difference
COnnection from DriverManager and DataSource
can anyone explain getServletContext method..
is a method in a class part of a transaction?