very perplexing connection problem

[Matthew Phillips]

I have a very strange problem with some code. The code is as follows:
<font size=+1>

    public static List getInformation( String sqlStatement ) throws SQLException , NamingException
    {
        Connection connection = null ;
        Statement stmt = null ;
        ResultSet results = null ;
        List returnValue = new ArrayList();
        
        try
        {
            returnValue.add( "before connection" );
            connection = getConnection();
            if( connection == null )
            {
                returnValue.add( "connection is null" );
            }
            returnValue.add( "before creating statement" );
            stmt = connection.createStatement();
            returnValue.add( "statement created" );
            results = stmt.executeQuery( sqlStatement );
            returnValue.add( "query executed" );
            String columnNames[] = getColumnNames( results );
            returnValue.add( "getColumns executed" );
            
            for( int i = 0 ; i < columnNames.length ; i++ )
        {
            returnValue.add( columnNames[i] );
        }
            
            while( results.next() )
            {
            for( int i = 0 ; i < columnNames.length ; i++ )
            {
                returnValue.add( results.getString( columnNames[ i ] ) );
            }
            }
            
        }
        finally
        {
            if( results != null )
            {
                results.close();
            }
            if( stmt != null )
            {
                stmt.close();
            }
            if( connection != null )
            {
               connection.close();
            }
            return returnValue ;
        }
    }

    private static Connection getConnection() throws SQLException , NamingException
    {
        Connection connection = null ;
        
        Context context = new InitialContext();
        DataSource dataSource = (DataSource)context.lookup( "jdni source in here" );
        connection = dataSource.getConnection( "user name here" , "password here" );
        
        return connection ;
    }

</font>
The method that calls this has code that goes through the List and prints out what is in it. When the code runs, the only statement that appears inside the list is "before connection." If I put the return connection from the getConnection method in a finally block, then I get connection is null. That makes it appear that an exception is being thrown. Now here is the tricky part. The code that calls this method catches all exceptions and prints them out. It is not catching any exceptions. Does anyone have any ideas on this?

[Matthew Phillips]

It appears that I may have a rights issue with the database. I placed a try/catch block around connection = getConnection() and added the exception to my List. It appears that it is not recognizing the login password as valid. If I find anything else, I will post it here so that others may learn from my mistakes.