Tomcat conf\Catalina\localhost\目录下:新建应用名.xml文件
内容:
<?xml version='1.0' encoding='utf-8'?>
<Context docBase="D:\aaa\WebRoot" path="/aaa">
<!-- dbPool begin -->
<Resource name="jdbc/ora" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ora">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>aaa</value>
</parameter>
<parameter>
<name>password</name>
<value>aaa</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@127.0.0.1:1521:aaa</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>30</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
</ResourceParams>
<!-- dbPool end -->
</Context>在ibatis中的sql-map-config.xml文件中
<transactionManager type="JDBC">
<dataSource type="JNDI">
<property name="DataSource" value="java:comp/env/jdbc/ora" />
</dataSource>
</transactionManager>就ok了
内容:
<?xml version='1.0' encoding='utf-8'?>
<Context docBase="D:\aaa\WebRoot" path="/aaa">
<!-- dbPool begin -->
<Resource name="jdbc/ora" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ora">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>aaa</value>
</parameter>
<parameter>
<name>password</name>
<value>aaa</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@127.0.0.1:1521:aaa</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>30</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
</ResourceParams>
<!-- dbPool end -->
</Context>在ibatis中的sql-map-config.xml文件中
<transactionManager type="JDBC">
<dataSource type="JNDI">
<property name="DataSource" value="java:comp/env/jdbc/ora" />
</dataSource>
</transactionManager>就ok了
解决方案 »
- spring中ApplicationContext.xml文件能不能改为其他文件名?
- javamail在发送时候的信息能不能记录下来?
- 自己生成的Jar包怎么双击没反应?
- 关于session的问题
- 求:weblogic10
- FLEX,有人研究吗?
- 要用bean:write标签输出一个非bean的类的方法能行吗
- 请教CITRIX是什么开发工具,AIX5.2是什么操作系统???
- TOMCAT5.5+J2SE5环境下不能运行JSP,急!!!
- 看看吧,100分!!如何将Image保存为XML的SVG图形格式?????
- 想找人合作翻译《Lucene In Action》这本书!
- ibatis+TOMCAT如何使用JNDI??
ibatis有一个daoconfig.java文件要如何写
如果jdbc可以调用这个JNDI吗?
问是的jdbc如何调用,
用这个类行吗??Context ctx = new InitialContext();
再给一段代码100分都给您,谢谢了
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<properties resource="com/sclh/config/db.properties" />
<settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32"
maxSessions="10" maxTransactions="5" useStatementNamespaces="false" />
<transactionManager type="JDBC">
<!--
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver" />
<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@192.168.0.250:1521:orcl" />
<property name="JDBC.Username" value="QBXX_NEW" />
<property name="JDBC.Password" value="QBXX" />
<property name="Driver.SetBigStringTryClob" value="true" />
<property name="Pool.MaximumActiveConnections" value="10" />
<property name="Pool.MaximumIdleConnections" value="5" />
<property name="Pool.MaximumCheckoutTime" value="120000" />
<property name="Pool.TimeToWait" value="500" />
<property name="Pool.PingQuery" value="select 1 from TEST" />
<property name="Pool.PingEnabled" value="false" />
<property name="Pool.PingConnectionsOlderThan" value="1" />
<property name="Pool.PingConnectionsNotUsedFor" value="1" />
</dataSource>
-->
<dataSource type="JNDI">
<property name="DataSource" value="${ajjbxxDataSource}" />
</dataSource>
</transactionManager>
<sqlMap resource="com/sclh/servicebase/ajjbxx/sqlMap/ajjbxx_SqlMap.xml" />
</sqlMapConfig>
<name>url</name>
<value>jdbc:oracle:thin:@127.0.0.1:1521:aaa</value>
</parameter>
这个搞成sqlserver的连接方式就行了!
不会这都不知道吧?