<data-sources>
<data-source>
<set-property value="oracle.jdbc.driver.OracleDriver" property="driverClass" />
<set-property value="jdbc:oracle:thin:@192.168.0.100:1521:QRRS" property="url" />
<!--
<set-property value="5" property="maxCount" />
<set-property value="1" property="minCount" />-->
<set-property value="scott" property="user" />
<set-property value="tiger" property="password" />
</data-source>
</data-sources>
<data-source>
<set-property value="oracle.jdbc.driver.OracleDriver" property="driverClass" />
<set-property value="jdbc:oracle:thin:@192.168.0.100:1521:QRRS" property="url" />
<!--
<set-property value="5" property="maxCount" />
<set-property value="1" property="minCount" />-->
<set-property value="scott" property="user" />
<set-property value="tiger" property="password" />
</data-source>
</data-sources>
解决方案 »
- 不明白为何要用基本只有getset的entity对象
- java中如何使用正则表达式校验这样的字符串。。。
- JAVA截取字符串并返回String类型方法是什么?
- J2EE5.0中有JSTL支持吗
- Hibernate 查询的问题
- MyEclipse连不上sql server 2005 (急)
- Servlet出错
- 调用HibernateTemplate.find()怎么总是报source not found错误啊.
- 为什么jcreatepro2.5不能编译servlet的程序(难道是不支持吗)
- 请教,tomcat 4 搭配soap 2 的安装问题
- 如何在win98下运行jboss3.2.5??100分送
- 请教beans的class文件到底存放在tomcat的什么位置
修改E:\tomcat4\conf\server.xml中的
<!-- Tomcat Root Context -->
下的东东
<Context path="" docBase="ROOT" debug="0">
<Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OracleDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:dxm</value>
</parameter>
<parameter>
<name>username</name>
<value>system</value>
</parameter>
<parameter>
<name>password</name>
<value>manager</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
要是5.0.19的话上面的码码拷到"</Engine>"前
第二步
添加
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
在E:\tomcat4\webapps\ROOT\WEB-INF\web.xml中。
第三步
jdbc加在common\lib下
第四步测试
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<html>
<head><title>Tomcat4.1.30数据池测试</title></head>
<body>
<% try{
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
file://获取连接池对象
Object obj = (Object) ctx.lookup("jdbc/OracleDB");
file://类型转换
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " select * from test_jndi ";
ResultSet rs = stmt.executeQuery(strSql);
if(rs.next())
{ out.println(rs.getString(1));
out.println("Tomcat4.1.30数据池测试成功!");
}
}catch(Exception ex)
{ ex.printStackTrace();
throw new SQLException(ex.toString());
}%>
</body>
</html>
把相应的东东改一下就可配成MSSQL的TOMCAT池子.
(全文完)
俺正在用的.....
具体该修改哪些xml文件呢?
提示这样错误,怎么办呢?
数据库用的是mysql,和用tomcat4.1.30
最后一行提示是什么意思呢?
<connection name="Default" resource="Oracle" connector="JDBC">
<set-property name="driver" value="oracle.jdbc.driver.OracleDriver" />
<set-property name="url" value="jdbc:oracle:thin:@172.28.121.4:1521:ssam" />
<set-property name="user" value="ssam" />
<set-property name="password" value="ssam" />
</connection> <!-- PostgreSQL -->
<connection name="_Default" resource="PostgreSQL" connector="JDBC">
<set-property name="driver" value="org.postgresql.Driver" />
<set-property name="url" value="jdbc:postgresql://localhost/oikawa" />
<set-property name="user" value="oikawa" />
<set-property name="password" value="" />
</connection>
<connection name="_Default" resource="Oracle" connector="DataSource">
<set-property name="InitialContextFactory" value="weblogic.jndi.WLInitialContextFactory" />
<set-property name="ProviderUrl" value="t3://localhost:7021" />
<set-property name="Namespace" value="/" />
<set-property name="DataSourceName" value="essam_eip_hanbai" />
</connection> </connections> <connectors>
<connector name="JDBC" type="com.nec.oscf.beam.db.DefaultJDBCConnector"/>
<connector name="DataSource" type="com.nec.oscf.beam.db.DefaultJNDIConnector"/>
</connectors>