我在TOMCAT下配的数据源,可以发给你参考参考!
server.xml:
<Server port="8012" shutdown="SHUTDOWN" debug="0"> <Service name="investoday3.0">
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="11" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="8440"
acceptCount="10" debug="0" connectionTimeout="60000"/>
<!-- Define an SSL HTTP/1.1 Connector on port 8443 -->
<!--
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="8443" minProcessors="5" maxProcessors="75" enableLookups="true"
acceptCount="10" debug="0" scheme="https" secure="true">
<Factory className="org.apache.catalina.net.SSLServerSocketFactory"
clientAuth="false" protocol="TLS"
keystoreFile="D:\tomcat-4.0.4\conf\server_keystore"
keystorePass="investstore"
/>
</Connector>
-->
<Connector className="org.apache.ajp.tomcat4.Ajp13Connector"
port="8091" minProcessors="5" maxProcessors="75"
acceptCount="10" debug="0"/>
<Engine name="MAN" defaultHost="localhost" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="start." suffix=".log" timestamp="true"/>
<Realm className="org.apache.catalina.realm.MemoryRealm" />
<Host name="localhost" debug="0" appBase="E:\INVESTODAY1\src" unpackWARs="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="access." suffix=".log" pattern="common"/>
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="run." suffix=".log" timestamp="true"/>
<Context path="" docBase="/" debug="0" reloadable="true" crossContext="true">
<Environment name="maxExemptions" type="java.lang.Integer" value="15"/>
<Parameter name="context.param.name" value="context.param.value" override="false"/>
<Resource name="jdbc_td01_manager" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_td01_manager">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#DB</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_10_web</value></parameter>
</ResourceParams>
<Resource name="jdbc_db30_bond" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_db30_bond">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#DB</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_10_web</value></parameter>
</ResourceParams>
<Resource name="jdbc_pd_10_web" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_pd_10_web">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#db</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_10_web</value></parameter>
</ResourceParams>
<Resource name="jdbc_pd_11_web" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_pd_11_web">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#db</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_11_web</value></parameter>
</ResourceParams>
</Context>
</Host>
</Engine>
</Service>
</Server>
server.xml:
<Server port="8012" shutdown="SHUTDOWN" debug="0"> <Service name="investoday3.0">
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="11" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="8440"
acceptCount="10" debug="0" connectionTimeout="60000"/>
<!-- Define an SSL HTTP/1.1 Connector on port 8443 -->
<!--
<Connector className="org.apache.catalina.connector.http.HttpConnector"
port="8443" minProcessors="5" maxProcessors="75" enableLookups="true"
acceptCount="10" debug="0" scheme="https" secure="true">
<Factory className="org.apache.catalina.net.SSLServerSocketFactory"
clientAuth="false" protocol="TLS"
keystoreFile="D:\tomcat-4.0.4\conf\server_keystore"
keystorePass="investstore"
/>
</Connector>
-->
<Connector className="org.apache.ajp.tomcat4.Ajp13Connector"
port="8091" minProcessors="5" maxProcessors="75"
acceptCount="10" debug="0"/>
<Engine name="MAN" defaultHost="localhost" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="start." suffix=".log" timestamp="true"/>
<Realm className="org.apache.catalina.realm.MemoryRealm" />
<Host name="localhost" debug="0" appBase="E:\INVESTODAY1\src" unpackWARs="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="access." suffix=".log" pattern="common"/>
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="run." suffix=".log" timestamp="true"/>
<Context path="" docBase="/" debug="0" reloadable="true" crossContext="true">
<Environment name="maxExemptions" type="java.lang.Integer" value="15"/>
<Parameter name="context.param.name" value="context.param.value" override="false"/>
<Resource name="jdbc_td01_manager" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_td01_manager">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#DB</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_10_web</value></parameter>
</ResourceParams>
<Resource name="jdbc_db30_bond" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_db30_bond">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#DB</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_10_web</value></parameter>
</ResourceParams>
<Resource name="jdbc_pd_10_web" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_pd_10_web">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#db</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_10_web</value></parameter>
</ResourceParams>
<Resource name="jdbc_pd_11_web" auth="SERVLET" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc_pd_11_web">
<parameter><name>user</name><value>sa</value></parameter>
<parameter><name>password</name><value>sa#db</value></parameter>
<parameter><name>driverClassName</name><value>com.newatlanta.jturbo.driver.Driver</value></parameter>
<parameter><name>driverName</name><value>jdbc:JTurbo://192.168.0.128/pd_11_web</value></parameter>
</ResourceParams>
</Context>
</Host>
</Engine>
</Service>
</Server>
解决方案 »
- java 正则表达式 matcher.find()与group(i)
- 关于Class<? super T>
- Java中如何把非系统时间HH:mm或yyyy-MM-dd HH:mm插入到SQL中
- 如何设置画笔的宽度?想画一条宽一点的线段怎么实现
- 对C和C++都没有基础,能不能直接学JAVA
- 各位老大,小弟问一下,在java中写的单机版程序如何像金山词霸一样,每一个系统,同时只能有一个程序在跑??
- 为什么我在处理多线程的问题时程序要导入java.lang.thread的包??
- 求一段关于打印的代码,任何形式的都可以!
- JAVA可以开发Sniffer程序吗?
- java 多线程问题
- 如何加上动态按钮的响应事件?
- 如何调用draw()?
有哪些步骤要做
控制面板--》管理工具——》数据源中也要更改一些属性
请问怎么改
我是用sql server的
数据源建立。
建立连接:
Connection conn;
Statement stmt;
ResultSet res;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
conn = DriverManager.getConnection("jdbc:odbc:renshi","test","test");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE , ResultSet.CONCUR_READ_ONLY);
res = stmt.executeQuery("select * from table");