Servlet 连接Oracle 出错 高手帮我啊

Question

这是报的错的信息;
2009-3-9 19:25:57 oracle.jdbc.driver.OracleDriver registerMBeans
严重: Error while registering Oracle JDBC Diagnosability MBean.
javax.management.MalformedObjectNameException: Invalid character '
' in value part of property
at javax.management.ObjectName.construct(ObjectName.java:602)
at javax.management.ObjectName.<init>(ObjectName.java:1394)
at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:303)
at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:213)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:209)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.msg.addMsg.doPost(addMsg.java:20)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)这是我的源代码:package com.msg;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class addMsg extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
try {
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.1.100:1521:orcl", "wangmao",
"wangmao");
     Statement sta = con.createStatement();
     ResultSet set = sta.executeQuery("select * from test");
     while(set.next()){
      System.out.println(set.getString("name")); 
     }

} catch (SQLException e) { e.printStackTrace();
} } catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
我初学啊 想法很简单 只是想连上去啊 但是如今这不能实现啊P*@*(@

Answer 1

同楼上，就是驱动在注册的时候出了问题，看看有没有添加Jar包

Answer 2

at com.msg.addMsg.doPost(addMsg.java:20) 看看是不是你的引号的输入法错误了？  

Answer 3

Invalid character ' ' in value part of property 
查查引号！

Answer 4

代码 没有错误，你看看有没有加上jar包，你的错误的MBean没有注册，你加一个jar到lib目录下，
可以在this.doGet()方法调用doPost()方法在后台测试一下。

Answer 5

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {  this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html");
PrintWriter out = response.getWriter();
try { 
Class.forName("oracle.jdbc.driver.OracleDriver");  
try { 
Connection con = DriverManager.getConnection( 
"jdbc:oracle:thin:@192.168.1.100:1521:orcl", "wangmao", 
"wangmao"); 
 
    Statement sta = con.createStatement(); 
    ResultSet set = sta.executeQuery("select * from Test"); 
    while(set.next()){ 
    System.out.println(set.getString("name")); 
    }  } catch (SQLException e) {  e.printStackTrace(); 
}  } catch (ClassNotFoundException e) { 
e.printStackTrace(); 
} 
}  }

Answer 6

at com.msg.addMsg.doPost(addMsg.java:20)  
addMsg 是你写的吗？

Answer 7

我用的ibatis连接的 严重: Error while registering Oracle JDBC Diagnosability MBean.
javax.management.MalformedObjectNameException: Invalid character '
' in value part of property