websphere JVM trace.log jndi datasource

最新推荐文章于 2025-10-31 16:34:24 发布

最新推荐文章于 2025-10-31 16:34:24 发布 · 209 阅读

文章标签：

#JVM #Websphere #Oracle #JDBC #SQL Server

综合编程专栏收录该内容

9 篇文章

订阅专栏

引用 websphere datasource 
<resource-ref>
	<description>Datasource</description>
	<res-ref-name>jdbc/oracle</res-ref-name>
	<res-type>javax.sql.DataSource</res-type>
	<res-auth>Container</res-auth>
</resource-ref>

   Properties properties = new Properties();
			properties.put(Context.INITIAL_CONTEXT_FACTORY, "com.ibm.websphere.naming.WsnInitialContextFactory");
			properties.put(Context.PROVIDER_URL, "iiop://localhost:2809");
			Context ctx = new InitialContext(properties);
			DataSource ds = (DataSource) ctx.lookup("jdbc/Oracle");
			
			Connection conn = ds.getConnection();
			out.println(conn + "<br>");
			
			conn.setAutoCommit(false);
			String query = "select sysdate from dual";
			ResultSet rs = null;
			PreparedStatement ps = conn.prepareStatement(query);
			rs = ps.executeQuery();
			while(rs.next()){
				out.println((java.util.Date)rs.getDate(1) + "<br>" );
			}
			conn.commit();
			rs.close();
			ps.close();
			conn.close();

JVM ：应用服务器 -->server-->服务基础架构-->进程定义-->JVM 256 512