aspose file tools*
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 Java 8 in Action this week in the Java 8 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: 13884
    
  10

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
Transaction difference
COnnection from DriverManager and DataSource
is a method in a class part of a transaction?
can anyone explain getServletContext method..
DataSource VS Connection