RE: What is the suitable JDBC Driver for an Applet to connect to an AS/400

[Kris Kottapali <kris.kottapali@xxxxxxxx>]

TRY THIS!!!
This code is from the examples and tutorials of as400 toolkit for java!
maybe you can also check the help files...

        try {

                        
            DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());1 

                        
            connection = DriverManager.getConnection ("jdbc:as400://"
                + system + "/" + collectionName);2 


            try {
                Statement dropTable = connection.createStatement ();
                dropTable.executeUpdate ("DROP TABLE " + tableName);3
            }
            catch (SQLException e) {
            }

            
            Statement createTable = connection.createStatement ();
            createTable.executeUpdate ("CREATE TABLE " + tableName
                + " (I INTEGER, WORD VARCHAR(20), SQUARE INTEGER, "
                + " SQUAREROOT DOUBLE)");4 

            

Kris Kottapali
Sr.Devloper
kris.kottapali@arch.com
Cincinnati,OH


-----Original Message-----
From: tmalin@hannasteel.com [mailto:tmalin@hannasteel.com]
Sent: Tuesday, January 02, 2001 11:28 AM
To: JAVA400-L@midrange.com
Subject: What is the suitable JDBC Driver for an Applet to connect to an
AS/400


I receive the following error with my applet 'no suitable driver' I am
using the IBM JDBC driver
Any help would greatly be appreciated...
sample code::

import java.net.URL;
import java.awt.*;
import java.applet.Applet;
import java.sql.*;
import com.ibm.as400.access.*;

// begin the applet ********************************************

public class Dbf extends java.applet.Applet
{

Button DBFConnect = new Button("Connect to AS/400");
TextField QueryField = new TextField(40);
TextArea OutputField = new TextArea(10,95);

Connection con ;

static{
  try{
          Class.forName("com.ibm.as400.access.AS400JDBCDriver");
     }catch(ClassNotFoundException e)
     { e.printStackTrace(); }
} // end static




+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---