Article View: borland.public.jbuilder.java.api
Article #2621Oracle Database : table creating Problem
From: Ban
Date: Sun, 20 Aug 2000 00:00
Date: Sun, 20 Aug 2000 00:00
35 lines
1448 bytes
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-mailShow 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