<parameter>
<name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>driver是jconn2.jar
其余的不变。
这个我测试过了,好用。
<name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>driver是jconn2.jar
其余的不变。
这个我测试过了,好用。
解决方案 »
- 如何获得单选钮是否选中????????
- 怎样使地址栏显示同一地址
- 请教微软的消息队列MSMQ与IBM的消息队列怎么互联啊?急
- request.getRequestDispatcher("").forward(request,response);怎样让不打开一个新的页面
- 在windows server 2003里面配置tomcat出现的问题(二天来问了N个人仍没有解决)
- 求救:关于jsp的问题
- jsp对字符串操作问题3?
- 从现在开始学JSP到能够写购物网站的程序,需要多长时间?
- JSP薪资调查:请大家写明城市,公司性质,工作时间,学历,开发网站或者产品
- 关于事务的问题?
- html的问题
- 问一个我遇到的问题(还没解决)……寻找答案
.......
<Context path="/liyl" reloadable="true" docBase="E:\myproject\liyl" workDir="E:\myproject\liyl\work" >
<!--目录,名字,换成你自己的-->
<Resource name="jdbc/sybase"
auth="Container"
type="javax.sql.DataSource"/> <ResourceParams name="jdbc/sybase">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter> <!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter> <!-- Maximum number of idle dB connections to retain in pool.
Set to -1 for no limit. See also the DBCP documentation on this
and the minEvictableIdleTimeMillis configuration parameter.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter> <!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter> <!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter> <!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next
if you want to use this driver - we recommend using Connector/J though
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
-->
<!-- Class name for the official MySQL Connector/J driver -->
<parameter>
<name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>
<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:sybase:Tds:192.168.130.199:5000/mesite?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>................在web.xml中加入: <resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/sybase</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
最后把你的那个SYBASE的JDBC驱动 JCONN2.JAR放在TOMCAT/COMMON/LIB下。上面的就是我用的,很要用。
sybase我很不熟悉,想和你探讨,
现在我要使用事务,可是程序在运行con.setAutoCommit(false);时候报以下错误,请大侠帮忙呀
java.sql.SQLException: JZ0SJ: 没有在此数据库中发现元数据存取器信息。
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.jdbc.MdaManager.loadMetaData(MdaManager.java)
at com.sybase.jdbc.MdaManager.<init>(MdaManager.java)
at com.sybase.jdbc.MdaManager.<init>(MdaManager.java)
at com.sybase.jdbc.SybConnection.checkMDA(SybConnection.java)
at com.sybase.jdbc.SybConnection.getMDA(SybConnection.java)
at com.sybase.tds.Tds.setOption(Tds.java)
at com.sybase.jdbc.SybConnection.setAutoCommit(SybConnection.java)
at com.ninetowns.mai.inquirydata.dao.impl.InquiryFormDaoImpl.saveForm(InquiryFormDaoImpl.java:104)
at com.ninetowns.mai.inquirydata.service.impl.InquiryDataServiceImpl.saveData(InquiryDataServiceImpl.java:66)
at com.ninetowns.mai.inquirydata.action.FillOutDataSaveAction.execute(FillOutDataSaveAction.java:48)
at com.ninetowns.mai.controller.MainServlet.service(MainServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
at java.lang.Thread.run(Thread.java:534)