JNDI oracle

2011-05-29 11:01:31 258 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Kettle工具通过JNDI连接Oracle集群我们在用Kettle ETL工具的时候，可能会遇到数据库为Oracle集群的模式，或者有时候目标库为oracle，在持续的循环调度中，经常发现oracle的数据库连接中断的情况，此时，在Kettle中有一个JNDI的连接方式能很好的解决此模式的连接。阅读详情

我就是想测试下jndi 遇到问题
jsp文件



<%@ page contentType="text/html;charset=gb2312"%>   

<%@ page import="java.sql.*"%> 

<html>   

	<body>   

		<%

		/*

		Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();   

		String url="jdbc:oracle:thin:@localhost:1521:orcl"; 

		String user="scott"; 

		String password="tiger"; 

		Connection conn= DriverManager.getConnection(url,user,password);   

		*/

		String JNDI_STR = "java:comp/env/FirstJNDI";

		Context ctx= new InitialContext();

		DataSource ds = (Datasource) ctx.lookup(JNDI_STR);

		connection conn = ds.getConnection();

		Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   

		String sql="select * from emp";   

		ResultSet rs=stmt.executeQuery(sql);   

		while(rs.next()) {%>   

		<%=rs.getString(1)%>   

		<%=rs.getString(2)%>   

		<%out.print("<br>");%>

		<%}%>   

		<%out.print("数据库操作成功，恭喜你");%>   

		<%rs.close();   

		stmt.close();   

		conn.close();   

		%>   

	</body>   

</html>

server.xml中增加



<Context path="/TestJNDI" docBase="Tomcat 5.5\webapps\TestJNDI" debug="5" reloadable="true" crossContext="true" workDir="">

	<Resource name="FirstJNDI" auth="Container"

		type ="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username = "scott" password="tiger"

		dirverClassName ="oracle.jdbc.OracleDriver"

		url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL"/>

</Context>

但是启动Tomcat 时报错



2011-5-29 22:49:08 org.apache.catalina.core.AprLifecycleListener init

信息: Loaded APR based Apache Tomcat Native library 1.1.20.

2011-5-29 22:49:08 org.apache.catalina.core.AprLifecycleListener init

信息: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], ra

ndom [true].

2011-5-29 22:49:08 org.apache.coyote.http11.Http11AprProtocol init

信息: Initializing Coyote HTTP/1.1 on http-8081

2011-5-29 22:49:08 org.apache.coyote.ajp.AjpAprProtocol init

信息: Initializing Coyote AJP/1.3 on ajp-8009

2011-5-29 22:49:08 org.apache.catalina.startup.Catalina load

信息: Initialization processed in 922 ms

2011-5-29 22:49:08 org.apache.catalina.core.StandardService start

信息: Starting service Catalina

2011-5-29 22:49:08 org.apache.catalina.core.StandardEngine start

信息: Starting Servlet Engine: Apache Tomcat/5.5.33

2011-5-29 22:49:08 org.apache.catalina.core.StandardHost start

信息: XML validation disabled

2011-5-29 22:49:08 org.apache.catalina.core.StandardContext resourcesStart

严重: Error starting static Resources

java.lang.IllegalArgumentException: Document base C:\Program Files\Apache Softwa

re Foundation\Tomcat 5.5\webapps\Tomcat 5.5\webapps\TestJNDI does not exist or i

s not a readable directory

        at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.

java:141)

        at org.apache.catalina.core.StandardContext.resourcesStart(StandardConte

xt.java:3895)

        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4

064)

        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)



        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)

        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)



        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443

)

        at org.apache.catalina.core.StandardService.start(StandardService.java:4

48)

        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700

)

        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)

        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)

2011-5-29 22:49:08 org.apache.catalina.core.StandardContext start

严重: Error in resourceStart()

2011-5-29 22:49:09 org.apache.catalina.core.StandardContext start

严重: Error getConfigured

2011-5-29 22:49:09 org.apache.catalina.core.StandardContext start

严重: Context [/TestJNDI] startup failed due to previous errors

2011-5-29 22:49:09 org.apache.catalina.core.StandardContext stop

信息: Container org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/

TestJNDI] has not been started

2011-5-29 22:49:10 org.apache.coyote.http11.Http11AprProtocol start

信息: Starting Coyote HTTP/1.1 on http-8081

2011-5-29 22:49:10 org.apache.coyote.ajp.AjpAprProtocol start

信息: Starting Coyote AJP/1.3 on ajp-8009

2011-5-29 22:49:10 org.apache.catalina.storeconfig.StoreLoader load

信息: Find registry server-registry.xml at classpath resource

2011-5-29 22:49:10 org.apache.catalina.startup.Catalina start

信息: Server startup in 1422 ms