🚀 go-pugleaf

Hi Ban ,
    Should by executeUpdate(sqlText) which did not return a result set.

Thanks

Ban wrote:

> I am using JBuilder3.5, Oracle 8.05 to develop a program to create a table,
> below is the codes:
>
>       Statement  stmt=null;
>       String dburl="jdbc:odbc:chan";
>       Connection con=null;
>       String s=null;
>       try
>       {
>        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>        con = DriverManager.getConnection(dburl,"webresource","textreport");
>        stmt=con.createStatement();
>        s = "CREATE TABLE myTable " +
>      "(myID VARCHAR2(10), myTYPE VARCHAR2(4), mycontent VARCHAR2(10) )";
>        stmt.executeQuery(s);
>
>       }
>       catch(SQLException e)
>       {
>         System.out.println(e);
>       }
>
> But, when running ,there is an SQLException which is   "No ResultSet
> Produced".
> I don't know why. Please give me a hand.
> Thanks in advance.
>
> Xuegang Ban
> Department of Civil and Environmental Engineering
> University of Wisconsin at Madison
>
> Email: ban@cae.wsic.edu
> Tel: 608-260-9123 (H)
>        608-262-3967 (O)