freelanceprogrammers.org Forum Index » Java

View previous topic :: View next topic

Please Help - No data found

c_beginner2001 Posted: Thu Feb 21, 2002 3:14 pm

Joined: 31 Jan 2002

Posts: 24

Please Help - No data found

Hi everyone, I`m having a problem in getting a
database application to work. I have two pieces of source
code (1. CreateCoffess 2.AddressBook by Deitel &
Deitel), both compile but when I run them both the same
error occurs: Connection unsuccessful
java.sql.SQLException: No data found I have set up the databases
through the control panel>ODBC Datasource and don`t
know whats wrong, I have also set up a table for the
databases. Can anyone please exaplian whats going wrong
and how I can fix it? I have given both peices of
code below incase this helps but I`m not sure if the
problem is with the code (unlikely if the same error
happens for both applications). Source code 1:
CreateCoffess: import java.sql.*; // Create the Coffee
Table. public class CreateCoffees { public static void
main(String args[]) { String url =
"jdbc:odbc:CafeJava"; Connection con; String createString; createString
=
"create table COFFEES " + "(COF_NAME varchar(32), "
+ "SUP_ID int, " + "PRICE float, " + "SALES int, "
+ "TOTAL int)"; Statement stmt; try
{ //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Class.forName("sun.jdbc
.odbc.JdbcOdbcDriver"); } catch(java.lang.ClassNotFoundException e)
{ System.err.print("ClassNotFoundException:
"); System.err.println(e.getMessage()); } try { con =
DriverManager.getConnection(url,"Admin", "duke1"); stmt =
con.createStatement(); stmt.executeUpdate(createString); stmt.close();
 con.close(); } catch(SQLException ex)
{ System.err.println("SQLException: " +
ex.getMessage()); } } } Code
2: AddressBook: import java.sql.*; import
java.awt.*; import java.awt.event.*; import
javax.swing.*; public class AddressBook extends JFrame { private
ControlPanel controls; private ScrollingPanel
scrollArea; private JTextArea output; private String
url; private Connection connect; private JScrollPane
textpane; public AddressBook() { super( "Address Book
Database Application" ); Container c =
getContentPane(); // Start screen layout scrollArea = new
ScrollingPanel(); output = new JTextArea( 6, 30 ); c.setLayout( new
BorderLayout() ); c.add( new JScrollPane( scrollArea
), BorderLayout.CENTER ); textpane = new JScrollPane( output
); c.add( textpane, BorderLayout.SOUTH ); // Set up
database connection try { url =
"jdbc:odbc:AddressBook"; Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver"
); connect =
DriverManager.getConnection( url ); output.append( "Connection
successful
" ); } catch ( ClassNotFoundException cnfex )
{ // process ClassNotFoundExceptions
here cnfex.printStackTrace(); output.append( "Connection unsuccessful
"
+ cnfex.toString()
); } catch ( SQLException sqlex ) { // process
SQLExceptions
here sqlex.printStackTrace(); output.append( "Connection unsuccessful
"
+ sqlex.toString()
); } catch ( Exception ex ) { // process remaining
Exceptions here ex.printStackTrace(); output.append(
ex.toString() ); } // Complete screen
layout controls = new ControlPanel( connect, scrollArea,
output); c.add( controls, BorderLayout.NORTH ); setSize(
500, 500 ); show(); } public static void
main( String args[] ) { AddressBook app = new
AddressBook(); app.addWindowListener( new WindowAdapter() { public
void windowClosing(
WindowEvent e ) { System.exit( 0 ); } }
); } } Thanks everyone

dnp7 Posted: Thu Feb 21, 2002 5:17 pm

Joined: 19 Feb 2002

Posts: 22

Please Help - No data found

Your line con =
DriverManager.getConnection(url,"Admin", "duke1"); hasn`t work. Look at
ODBC source
ones more. You must have CafeJava named
source and login/passw to your database must be
Admin/duke1 Good Luck, Dmitry

c_beginner2001 Posted: Thu Feb 21, 2002 9:48 pm

Joined: 31 Jan 2002

Posts: 24

Please Help - No data found

I have changed the connection line to con
= DriverManager.getConnection(url,"",""); so
that there is no username or password and set the
system dsn to CafeJava but the same error happens.

dnp7 Posted: Fri Feb 22, 2002 3:43 pm

Joined: 19 Feb 2002

Posts: 22

Please Help - No data found

You should use connection line like this: con =
DriverManager.getConnection(url,"scott","tiger"); User name and password must
be determined. What database are you use?

freelanceprogrammers.org Forum Index » Java

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help