× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi,
I'm tring to create an applet that using jt400 classes to read an AS400
file.
The com.ibm.as400.access.AS400JDBCDriver() registation is OK!
but the getConnection (Connection connection = DriverManager.getConnection
("jdbc:as400://S655772B/CGIUTI;naming=system;errors=full;libraries=CGIUTI,QGPL;date
format=iso",userString,passwordString);) return null Exception and doesn't
read the file (there are no errors in JVM consolle!)

Here's the code :
//***********************************************************
import java.lang.Object.*;
import java.net.URLConnection.*;
import java.net.URL.*;
import java.applet.Applet;
import java.awt.*;
import java.awt.event.*;
import com.ibm.as400.access.*;
import java.sql.*;

public class AccessoDB extends Applet implements ActionListener
{

   Label systemPrompt;
   Label userPrompt;
   Label passwordPrompt;
   TextField systemField;
   TextField userField;
   TextField passwordField;
   Button okButton;
   Button cancelButton;
   String systemString;
   String userString;
   String passwordString;
   String commandString;

   public void init()
   {


      setLayout(new FlowLayout());      
      systemPrompt = new Label("Nome Sistema AS400 ");
      add(systemPrompt);
      systemField = new TextField(15);
      add(systemField);
      userPrompt = new Label("Utente");
      add(userPrompt);
      userField = new TextField(10);
      add(userField);
      passwordPrompt = new Label("Password");
      add(passwordPrompt);
      passwordField = new TextField(10);
      add(passwordField);
      okButton = new Button("OK");
      okButton.addActionListener(this);
      add(okButton);
      cancelButton = new Button("Cancel");
      cancelButton.addActionListener(this);
      add(cancelButton);
   }

   public void paint(Graphics g)
   {
        
      if ((systemString != null) &&
          (userString != null) &&
          (passwordString != null))

      {
         g.drawString("Sistema:" + systemString, 60, 100);
         g.drawString("Utente:" + userString, 60, 120);
         g.drawString("Connessione a Host ...", 60, 160);
         g.drawString("Connessione a CGIUTI ...", 60, 180);
         String system=systemString;
         try
         {

           // Load the IBM Toolbox for Java JDBC driver.
            DriverManager.registerDriver(new 
com.ibm.as400.access.AS400JDBCDriver());
                   g.drawString("Driver OK!.", 60, 200);
            Connection connection = DriverManager.getConnection 
("jdbc:as400://S655772B/CGIUTI;naming=system;errors=full;libraries=CGIUTI,QGPL;date
format=iso",userString,passwordString);
            g.drawString("Connessione OK!.", 60, 220);
            DatabaseMetaData dmd = connection.getMetaData ();
            Statement select = connection.createStatement ();
            ResultSet rs = select.executeQuery ("SELECT * FROM CGIUTI" 
+ dmd.getCatalogSeparator() + "WLUTE00F");
            g.drawString("Connessione Query!.", 60, 240);
            ResultSetMetaData rsmd = rs.getMetaData ();
            int columnCount = rsmd.getColumnCount ();
            StringBuffer dashedLine;
           while (rs.next ()) {
                for (int i = 1; i <= columnCount; ++i) {
                    String value = rs.getString (i);
                    if (rs.wasNull ())
                        value = "<null>";
                         g.drawString(value, 60, 260);
                }
            }


          connection.close();



         }
         catch (Exception e)
         {
            g.drawString("Connessione Fallita."+ e.getMessage(), 60, 220);

         }

      }

   }

   public void actionPerformed(ActionEvent e)
   {
      if (e.getActionCommand() == "Cancel")
      {
           System.exit(0);
      }

      systemString = systemField.getText();
      userString = userField.getText();
      passwordString = passwordField.getText();
      repaint();

   }

}

// end of Code ****************************************************

P.S.:In the same jar file are saved all jt400 classes needed!

Thanks in advance!!

Vincenzo Amoruso
System Project s.r.l.
Andria(BA) - Italy



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.