I am facing an issue while creating datasoure in openejb server. I need to
connect to external database (oracle 10g) through os authentication. From
command prompt I am able to connect to database without any problem. command
used like
sqlplus : connect /@testdb - connected ok.
For datasource creation, I dont want to provide user id, password for db
connection. is this possible in openejb?
I tried using a standalone java program by passing the url and user id,it is
connecting the database.
String url = "jdbc:oracle:thin:@localhost:1521:xe";
Properties props = new Properties();
props.put(OracleConnection.CONNECTION_PROPERTY_THIN_VSESSION_OSUSER,
"ASIAPACIFIC\\A162152");
props.put(OracleConnection.CONNECTION_PROPERTY_THIN_VSESSION_OSUSER,
"ASIAPACIFIC\\A162152");*/
Connection conn = DriverManager.getConnection(url, props);
Could any one please tell me how to create datasource in this scenario.
Thanks in advance.
--
View this message in context:
http://openejb.979440.n4.nabble.com/Datasource-configuration-for-OS-Authentication-using-Oracle-10g-tp3174875p3174875.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
