🚀 go-pugleaf

try executeUpdate(String) instead...

"Ban" <ban@cae.wisc.edu> wrote in message news:39a067f9$1_1@dnews...
> 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)
>
>
>