java.sql.SQLException: ORA-00911: 无效字符

  上午一直在调试..java.sql.SQLException: ORA-00911: 无效字符这个错误..
反复检查 数据库调试都没有问题.. 没办法最终拿出杀手锏.. GOOGLE.
搜到http://blog.csdn.net/zjx2388/archive/2008/03/10/2164755.aspx博友的帖子
一语点醒梦中人. 谢谢博友..

1. public static void creNewTable(String[] arr_talColumn,String tableName){
2.         DBConnection db = new DBConnection();
3.         con = db.getCon();
4.         StringBuffer sb = new StringBuffer();
5.         sb.append("create table ");
6.         sb.append(tableName);
7.         sb.append("(");
8.         int length = 1000;
9.         for(int index=0;index<arr_talColumn.length;index++){
10.             if(index==arr_talColumn.length-1){
11.                 sb.append(arr_talColumn[index]+" varchar("+length+") null");
12.             }else{
13.                 sb.append(arr_talColumn[index]+" varchar("+length+") null,");
14.             }
15.         }
16.         sb.append(");");
17.         System.out.println(sb);
18.         try{
19.             ps = con.prepareStatement(sb.toString());
20.             boolean flag = ps.execute();
21.             System.out.println("success");
22.         }catch(SQLException e){
23.             e.printStackTrace();
24.         }finally{
25.             db.close();
26.         }
27.     }

异常提示:

1. java.sql.SQLException: ORA-00911: 无效字符
3.     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
4.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
5.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
6.     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622)
7.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:180)
8.     at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:542)
9.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027)
10.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887)
11.     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2978)
12.     at com.company.fileuploaddemo.util.DBDao.creNewTable(DBDao.java:65)
13.     at com.company.fileuploaddemo.servlet.FileToNewTableServlet.doGet(FileToNewTableServlet.java:55)
14.     at com.company.fileuploaddemo.servlet.FileToNewTableServlet.doPost(FileToNewTableServlet.java:60)
15.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
16.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
17.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
18.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
19.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
20.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
21.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
22.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
23.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
24.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
25.     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
26.     at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
27.     at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
28.     at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
29.     at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
30.     at java.lang.Thread.run(Thread.java:595)

原来是

1. sb.append(");");

后面多写了一个分号..

感谢那位博友...

特此 分享一下经验

希望同志们不要犯以上错误..