服务器认证失败(急)

xhsoft · 发表于 2010-3-3 14:30:41

Resource name="x3sys" url="jdbcracleci

orcl" username="x3sys" password="justep" driverClassName="oracle.jdbc.driver.OracleDriver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="300" maxWait="2000" validationQuery="SELECT 1 FROM DUAL"/>

注意最后的那个参数。
没有看到这几个参数？

shangxy · 发表于 2010-3-3 14:33:16

minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL"
每个连接池都加上这几个参数

xhsoft · 发表于 2010-3-3 14:37:12

起什么作用？

xhsoft · 发表于 2010-3-3 14:40:56

无法修改，用记事本打开，全部乱掉了

xhsoft · 发表于 2010-3-3 14:58:29

xhsoft · 发表于 2010-3-3 15:09:08

- <Context path="/x3" docBase="x3" debug="5" reloadable="true" crossContext="true">
  <Logger className="org.apache.catalina.logger.FileLogger" directory="logs" prefix="localhost_justep_log." suffix=".txt" timestamp="true" />
  <Resource name="X3Doc" url="jdbc:jtds:sqlserver://192.168.10:1433/x3system" username="sa" password="sa" driverClassName="net.sourceforge.jtds.jdbc.Driver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL" removeAbandoned="true" removeAbandonedTimeout="5" logAbandoned="true" />
  <Resource name="X3Sys" url="jdbc:jtds:sqlserver://192.168.0.10:1433/x3system" username="sa" password="sa" driverClassName="net.sourceforge.jtds.jdbc.Driver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL" removeAbandoned="true" removeAbandonedTimeout="5" logAbandoned="true" />
  <Resource name="rlzy" url="jdbc:jtds:sqlserver://192.168.0.10:1433/rlzy" username="sa" password="sa" driverClassName="net.sourceforge.jtds.jdbc.Driver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL" />
  <Resource name="wj" url="jdbc:jtds:sqlserver://192.168.0.10:1433/wj" username="sa" password="sa" driverClassName="net.sourceforge.jtds.jdbc.Driver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL" />
  <Resource name="office" url="jdbc:jtds:sqlserver://192.168.0.10:1433/office" username="sa" password="sa" driverClassName="net.sourceforge.jtds.jdbc.Driver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL" />
  <Resource name="x3_spgl" url="jdbc:jtds:sqlserver://192.168.0.10:1433/x3_spgl" username="sa" password="sa" driverClassName="net.sourceforge.jtds.jdbc.Driver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL" />
  <Resource name="X3_TEST" url="jdbc:jtds:sqlserver://192.168.0.10:1433/X3_SCGS" username="sa" password="sa" driverClassName="net.sourceforge.jtds.jdbc.Driver" auth="Container" type="javax.sql.DataSource" minIdle="5" maxIdle="50" minEvictableIdleTimeMillis="300000" timeBetweenEvictionRunsMillis="300000" maxActive="100" maxWait="2000" validationQuery="SELECT 1 FROM DUAL" />
  </Context>

服务启不来了，报错找不到表DUAL

atiger · 发表于 2010-3-3 15:12:27

那你看看当前连接的那个数据库中是否有DUAL这个表呢

如果没有，加上吧，

xhsoft · 发表于 2010-3-3 15:16:41

No.47
那你看看当前连接的那个数据库中

是指哪个数据库

xhsoft · 发表于 2010-3-3 15:42:19

请尽快

xhsoft · 发表于 2010-3-3 15:53:02

服务出错，比较急，请求QQ沟通

		自动登录	找回密码
密码			立即注册