Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Java Developer Tool APIs
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 22, 2012 3:34 PM by
Difference between vendor connection and datasource connection
Feb 22, 2012 11:10 AM
Can any one explain me the difference between vendor connection and datasource connection? interms of performance.?
My codce for vendor connectionis below.
Connection connection = null;
Connection vendorConn = null;
Context ctx = new InitialContext();
DataSource dataSource = ((DataSource) ctx.lookup(PropertyFactory.getEnvProperty(DATASOURCE)));
connection = dataSource.getConnection();
WLConnection a = (WLConnection) connection;
vendorConn = a.getVendorConnection();
i was closing only vendor connection and not the datasource connection. now i have removed vendor connection. I need difference between the both interms of performance?
This content has been marked as final.
Show 1 reply
Re: Difference between vendor connection and datasource connection
Feb 22, 2012 3:34 PM
in response to
The difference is that you must close the java.sql.Connection and not use the VndorConnection at all, it is none of your business. Imaginary performance differences notwithstanding.