Well, I think I fixed my JDBC problem. Now when I click on TEST, I get the
response "The following error has been recevied: NULL". That means that the
JDBC driver is correctly installed, right?
Now, I have a new problem. When I get the system to create a table, it goes
through the code, and then comes back indicating that the table was created.
However, when I look at the table list on the database, its not there. Can
someone look at this code and tell me if I'm doing something wrong??
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%
try
{
Class.forName("com.ashna.jturbo.driver.Driver");
String url="jdbc:JTurbo:dupontdb";
Connection con=DriverManager.getConnection(url);
Statement stmt = con.createStatement();
String query="CREATE TABLE COFFEES" +
"(COF_NAME VARCHAR(32),"+
"SUP_ID INTEGER,"+
"PRICE FLOAT,"+
"SALES INTEGER,"+
"TOTAL INTEGER)";
stmt.executeUpdate(query);
}
catch (Exception e) {}
out.println("table coffees created");
%>
Thanks in advance.
Brian.
-----------------------------------
Brian Piotrowski
Developer / Network Administrator
Moneyramp.com
(705) 475-9531
www.moneyramp.com
-----------------------------------
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
