🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.java.api
Article #2621

Oracle Database : table creating Problem

#2621
From: Ban
Date: Sun, 20 Aug 2000 00:00
35 lines
1448 bytes
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)
Technical Details
Message-ID: <39a067f9$1_1@dnews>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1089d0,4f4725c9f78b86d4,start
X-Google-Attributes: gid1089d0,public
From: "Ban" <ban@cae.wisc.edu>
Subject: Oracle Database : table creating Problem
Date: 2000/08/20
Message-ID: <39a067f9$1_1@dnews>
X-Deja-AN: 660529847
X-Trace: 20 Aug 2000 16:21:29 -0800, 128.104.179.189
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: borland.public.jbuilder.java.api
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400