myeclipse与sql server 2005建立连接池

Myeclipse中sql server 2005连接池的配置如下：

 

<Resource name="jdbc/SQLServerds"

      auth="Contianer"

      type="javax.sql.DataSource"

      maxActive="100"

      maxIdle="30"

      maxWait="10000"

      username="sa"

      password="root"

      driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

      url="jdbc:sqlserver://localhost:1433;DatabaseName=仓库管理"

  />

 

其中我的数据库名称是：仓库管理，

用户名（安装sql server2005时默认的）是：sa

密码是：root

 

但是在检测是否设置好没出现如下错误：

严重: Parse error in context.xml for /DataBase

com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.

  at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(UTF8Reader.java:674)

  at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(UTF8Reader.java:547)

  at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(XMLEntityScanner.java:1742)

  at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanLiteral(XMLEntityScanner.java:1064)

  at com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(XMLScanner.java:974)

  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanAttribute(XMLDocumentFragmentScannerImpl.java:1539)

  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1316)

  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)

  at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)

  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)

  at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)

  at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)

  at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)

  at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)

  at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)

  at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1644)

  at org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:789)

  at org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:728)

  at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:1009)

  at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:279)

  at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)

  at org.apache.catalina.core.StandardContext.init(StandardContext.java:5338)

  at org.apache.catalina.core.StandardContext.start(StandardContext.java:4086)

  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)

  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)

  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

  at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)

  at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)

  at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)

  at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)

  at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)

  at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)

  at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

  at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)

  at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

  at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

  at org.apache.catalina.core.StandardService.start(StandardService.java:516)

  at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

  at org.apache.catalina.startup.Catalina.start(Catalina.java:578)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)

  at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

 

我出现这个错误的原因是在配置数据库连接池时数据库的名称是汉字。

 

解决方法是：把Editplus默认编码可能是ANSI，将其改成UTF-8

 

然后，在下面的对话框中的左侧选择Files设置项，在右侧面板中选择UTF-8编码即可：

 

首先，在editplus菜单栏下的Tools下拉后选择Configure User Tools，弹出用户配置对话框，如下图：

然后，在下面的对话框中的左侧选择Files设置项，在右侧面板中选择UTF-8编码即可：

 

最后点击OK，完成设置！

 

 如果还不可以的话，把web.xml的编码也改为UTF-8