ResultSetMetaData problem, not returning data

[Jeff Foflygen]

Hello all,

My problem is that my class is not returning data at all and I'm stuck. the culprit I think is my

return null;

in the class. I need help getting past it. I am posting the whole code so everyone knows what I'm looking at. the prepared statement is being filled out based on a value entered from another class. it works, I have verified, this class allows for people to see a Spreadsheet like view of the query instead of specific data. please, any ideas or help would be awesome! thanks!

import java.awt.*;
import java.awt.event.*;
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import javax.swing.table.*;

public class PandoraSpreadsheetView extends JFrame {
	Connection connection;
        JTable table = new JTable();
	
	public static void main(String[] args) throws Exception {
		new sun.jdbc.odbc.JdbcOdbcDriver();
		PandoraSpreadsheetView Pssv = new PandoraSpreadsheetView();
	}
	
	public PandoraSpreadsheetView() throws Exception {
		ConnectionDialog cd = new ConnectionDialog(this);
		connection = cd.getConnection();
		Container pane = getContentPane();
		pane.add(getSelectionPanel(), BorderLayout.NORTH);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		pane.add(new JScrollPane(table), BorderLayout.CENTER);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(600, 450);
		setVisible(true);
	}
        
    public JPanel getSelectionPanel() {
        JPanel panel = new JPanel();
        return panel;
    } 
        
    class ConnectionDialog extends JDialog {
        public boolean canceled;
        public Connection connect;
        
        public ConnectionDialog(JFrame f) {
            super(f, "Pandora Database Table View", true);
            buildDialogLayout();
            setSize(300, 200);
        }
        
        public Connection getConnection() {
            setVisible(true);
            return connect;
        }
        
        public void buildDialogLayout() {
            Container pane = getContentPane();
            pane.add(getButtonPanel());
        }
        
        public JPanel getButtonPanel() {
            JPanel panel = new JPanel();
            JButton btnOk = new JButton("GO");
            btnOk.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent event) {
                    onDialogOk();
                }
            });
            panel.add(btnOk);
            return panel;
        }
        
        public void onDialogOk() {
            if (attemptConnection()) {
                setVisible(false);
            }
        }

		private boolean attemptConnection() {
			// TODO Auto-generated method stub
			return true;
		}
    }
	
    public class attemptConnection {
    
        Connection con = null;
        PreparedStatement prest; 
        
        
        public String[] getValues() {
            try {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                con = DriverManager.getConnection("jdbc:oracle:thin:@server:port#:schema",
                                                "username", "pwd");
                String sql = ("SELECT DISTINCT "
    					+ " substr(pov.vendor_name,1,35), "
    					+ " TO_CHAR(PHA.APPROVED_DATE,'DD-MON-YYYY'), "
    					+ " substr(rha.segment1,1,7), "
    					+ " substr(requestor.full_name,1,30), "
    					+ " substr(buyer.full_name,1,30), "
    					+ " (PLA.UNIT_PRICE * PLA.QUANTITY), "
    					+ " SUBSTR (ppa.segment1, 1, 5), "
    					+ " SUBSTR (GAA.award_number, 1, 5), " 
    					+ " pat.task_number, "
    					+ " GAA.FUNDING_SOURCE_AWARD_NUMBER, "
    					+ " SUBSTR(GLC.SEGMENT4,1,8), "
    					+ " SUBSTR(PLA.ATTRIBUTE7,1,20), "  
    					+ " hl.location_code, "
    					+ " PLA.LINE_NUM, "
    					+ " PDA.DISTRIBUTION_NUM "                                    
    					+ " FROM "
    					+ " po.po_headers_all                  pha, " 
    					+ " po.po_vendors                      pov, "
    					+ " hr.per_all_people_f                buyer, "
    					+ " po.po_lines_all                    pla, "
    					+ " po.po_distributions_all            pda, "
    					+ " pa.pa_projects_all                 ppa, "
    					+ " pa.pa_tasks                        pat, "
    					+ " GL.GL_CODE_COMBINATIONS            GLC, "
    					+ " gms.gms_award_distributions        GAD, "
    					+ " gms.gms_awards_all                 GAA, "
    					+ " po.po_req_distributions_all        rda, "
    					+ " po.po_requisition_lines_all        rla, "
    					+ " po.po_requisition_headers_all      rha, "
    					+ " hr.per_all_people_f                requestor, "
    					+ " hr.per_all_assignments_f           paa, "
    					+ " apps.hr_locations                  hl "  
    					+ " WHERE "
    					+ " pha.segment1 = ? AND "                          
    					+ "  pov.vendor_id                = pha.vendor_id " 
    					+ " AND buyer.person_id              = pha.agent_id " 
    					+ "AND pla.po_header_id             = pha.po_header_id " 
    					+ "AND pla.CANCEL_DATE              IS NULL "  
    					+ "AND pda.po_line_id               = pla.po_line_id " 
    					+ "AND pda.encumbered_amount        > 0 "                 
    					+ "AND ppa.project_id               = pda.project_id " 
    					+ "AND pat.project_id               = pda.project_id "
    					+ "AND pat.task_id                  = pda.task_id "
    					+ "AND glc.code_combination_id      = pda.code_combination_id " 
    					+ "AND gad.po_distribution_id       = pda.po_distribution_id "
    					+ "AND gad.project_id               = pda.project_id "
    					+ "AND gad.task_id                  = pda.task_id "
    					+ "AND gaa.award_id                 = gad.award_id "
    					+ "AND rda.distribution_id      (+) = pda.req_distribution_id " 
    					+ "AND rla.requisition_line_id  (+) = rda.requisition_line_id "
    					+ "AND rla.cancel_date          (+) IS NULL "
    					+ "AND rha.requisition_header_id(+) = rla.requisition_header_id " 
    					+ "AND requestor.person_id      (+) = rla.to_person_id "
    					+ "AND paa.person_id            (+) = requestor.person_id "
    					+ "AND hl.location_id           (+) = paa.location_id "
    					+ "ORDER BY pla.line_num");

                prest = con.prepareStatement(sql);
                ARLinkConnection POData = null;
        		String textfieldInput = PandoraUI.POData.getText();
        		prest.setString(1, textfieldInput); 
                ResultSet rs = prest.executeQuery();
            } catch (SQLException e) {
            	e.printStackTrace();
            } catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return null; <-------------------------This is what is throwing the whole thing from working I think????
			
			}
        		
                //class ResultSetTableModel extends AbstractTableModel {
                	protected Vector columnHeaders;
                	protected Vector tableData;
                	
                	public void ResultSetTableModel (ResultSet rset) throws SQLException {
                		Vector rowData;
                		ResultSetMetaData rsmd = rset.getMetaData();
                		int count = rsmd.getColumnCount();
                		columnHeaders = new Vector(count);
                		tableData = new Vector();
                		for (int i = 1; i <= count; i++) {
                			columnHeaders.addElement(rsmd.getCatalogName(i));
                		}
                		while (rset.next()) {
                			rowData = new Vector(count);
                			for (int i = 1; i <= count; i++) {
                				rowData.addElement(rset.getObject(i));
                			}
                			tableData.addElement(rowData);
                		}
                	}
                	public int getColumnCount() {
                		return columnHeaders.size();
                	}
                	public int getRowCount() {
                		return tableData.size();
                	}
                	public Object getValueAt(int row, int column) {
                		Vector rowData = (Vector) (tableData.elementAt(row));
                		return rowData.elementAt(column);
                	}
                	public boolean isCellEditable(int row, int column) {
                		return false;
                	}
                	public String getColumnName(int column) {
                		return (String) (columnHeaders.elementAt(column));
                	}
                	private String getTextfieldInput() {
                		// TODO Auto-generated method stub
                		return null;
                	}
                }}
     

[Albareto McKenzie]

Well, you are suppouse to return an String[] and you are returning null, you get the data from the DB, store it in a ResultSet but you don´t manipulate that ResultSet, so if you just return null... what do you expect the aplication to do?

You should manipulate the data of the rs and stored it somehow in a String[]